Обернуть вложенный запрос(Zend) - Visavi.net
https://visavi.net/
RSS - Visavi.nethttps://visavi.net/assets/img/images/logo_small.pngRSS - Visavi.net
https://visavi.net/
[email protected] (admin)[email protected] (admin)Sat, 28 Dec 2024 15:03:05 +0300Здравствуйте как написать данный запрос:<br>
<pre class="prettyprint">
SELECT *
FROM (
SELECT `user_id` as ids,`created`,`order_id`
FROM `order`
WHERE
`created` < ( NOW( ) - INTERVAL 30 DAY )
ORDER BY `created` DESC
) AS orders
LEFT JOIN `users` ON `orders`.`ids` = `users`.`user_id`
GROUP BY `user_id`
HAVING count( `user_id` ) >=1
</pre>
в zend orm(query_builder)
https://visavi.net/topics/37711/633511
Обернуть вложенный запрос(Zend) ИзнаурThu, 02 May 2013 14:09:34 +0400Сообщенияhttps://visavi.net/topics/37711/633511