SELECT `r`.`id_zadakur` AS `taskId`,
sum(BS_TIME_DIFF(`r`.`arrival`, `r`.`departure`)) AS `wait`,
sum(BS_TIME_DIFF(IFNULL(`r2`.`departure`, `r`.`arrival`), `r`.`arrival`)) AS `active`
FROM `routes` AS `r`
LEFT JOIN `routes` AS `r2` ON `r2`.`id_zadakur` = `r`.`id_zadakur` AND `r2`.`series` = `r`.`series`-1
GROUP BY `r`.`id_zadakur`SELECT `p`.*
FROM `products` AS `p`
JOIN `PropertyPivot` AS `pp1` ON `pp1`.`product_id` = `p`.`id`
AND `pp1`.`property_id` = :p1_property AND `pp1`.`option_id` = :p1_value
JOIN `PropertyPivot` AS `pp2` ON `pp2`.`product_id` = `p`.`id`
AND `pp2`.`property_id` = :p2_property AND `pp2`.`option_id` = :p2_valueSELECT `t1`.`id_house`, `t1`.`znach`, `t2`.`znach`, `t3`.`znach`, `t4`.`znach`
FROM (
SELECT `id_house`, `znach` FROM `table` WHERE `property_id` = :property1
) AS `t1`
JOIN (
SELECT `id_house`, `znach` FROM `table` WHERE `property_id` = :property2
) AS `t2` ON `t2`.`id_house` = `t1`.`id_house`
JOIN (
SELECT `id_house`, `znach` FROM `table` WHERE `property_id` = :property3
) AS `t3` ON `t3`.`id_house` = `t1`.`id_house`
JOIN (
SELECT `id_house`, `znach` FROM `table` WHERE `property_id` = :property4
) AS `t4` ON `t4`.`id_house` = `t1`.`id_house`SELECT `o`.`title`, `f`.`value` AS `filling`, `t`.`value` AS `taste`
FROM `orders` AS `o`
LEFT JOIN (
SELECT `of`.`id_order` AS `id_order`, `of`.`value` AS `value`
FROM `order_fields` AS `of`
JOIN `fields` AS `f` ON `f`.`name` = 'Начинка' AND `f`.`id` = `of`.`id_field`
) AS `f` ON `f`.`id_order` = `o`.`id`
LEFT JOIN (
SELECT `of`.`id_order` AS `id_order`, `of`.`value` AS `value`
FROM `order_fields` AS `of`
JOIN `fields` AS `f` ON `f`.`name` = 'Вкус' AND `f`.`id` = `of`.`id_field`
) AS `t` ON `t`.`id_order` = `o`.`id`ORDER BY FIELD(`p`.`product_id`, 574, 572, 573)
SELECT `u`.`gid` AS `group_id`,
`g`.`name` AS `group_name`,
GROUP_CONCAT(DISTINCT `r`.`name` SEPARATOR ",") AS roles,
FROM (
SELECT `u`.`user` AS `user`, `u`.`gid` AS `gid`, `ru`.`id` AS `role`
FROM `users` AS `u`
LEFT JOIN `roles_users` AS `ru`
ON `u`.`user` = :user_id AND `ru`.`user` = `u`.`user`
UNION SELECT `u`.`user` AS `user`, `u`.`gid` AS `gid`, `rg`.`id` AS `role`
FROM `users` AS `u`
LEFT JOIN `roles_groups` AS `rg`
ON `u`.`user` = :user_id AND `rg`.`gid` = `u`.`gid`
) AS `ur`
INNER JOIN `groups` AS `g` ON `g`.`id` = `ur`.`gid`
LEFT JOIN `roles` AS `r` ON `r`.`id` = `ur`.`role`SELECT `v`.*
FROM (
SELECT `bank_id`, MAX(`date`) AS `date`
FROM `table`
WHERE `country` = :country_id AND `currency` = :currency_code
GROUP BY `bank_id`
) AS `d`
JOIN `table` AS `v`
ON `v`.`country` = :country_id AND `v`.`currency` = :currency_code
AND `v`.`bank_id` = `d`.`bank_id` AND `v`.`date` = `d`.`date`domain_id int(9) unsigned NOT NULL default 0,
id int(9) unsigned NOT NULL,
...
deprecated datetime default NULL,
...
PRIMARY KEY (id,deprecated,domain_id)SELECT `t2`.`number`, `t2`.`area` AS `newarea`, `t2`.`date` AS `lastdate`,
`t3`.`area` AS `oldarea`, `t3`.`date` AS `prevdate`
FROM (
SELECT `number`, MAX(`date`) AS `maxdate`
FROM `table`
GROUP BY `number`
) AS `t1`
JOIN `table` AS `t2` ON `t2`.`number` = `t1`.`number` AND `t2`.`date` = `t2`.`maxdate`
JOIN `table` AS `t3` ON `t3`.`number` = `t1`.`number` AND `t3`.`date` < `t3`.`maxdate`
AND `t3`.`area` < `t3`.`area`