stations (id, name);
events (card, event, station_id, sum, timestamp)SELECT `value`
FROM `table`
WHERE `post_id` IN (98, 54)
GROUP BY `value`
HAVING COUNT(*) > 1DELETE `p`.*
FROM (
SELECT `FIO_ID` FROM `Phone` GROUP BY `FIO_ID` HAVING COUNT(*) > 1
) AS `p1`
JOIN `Phone` AS `p` ON `p`.`FIO_ID` = `p1`.`FIO_ID` AND `p`.`Number` = :phoneNumberSELECT `os`.`service_cost`
FROM `Org_services` AS `os`
JOIN `Organizations` AS `o` ON `o`.`ID` = `os`.`org_id` AND `o`.`org_name` = :orgName
JOIN `Services_list` AS `s` ON `s`.`ID` = `os`.`service_id` AND `s`.`service_name` = :servNameSELECT DATE(`date_insert`) AS `date`, SUM(`price`), AVG(`price`), COUNT(*)
FROM `b_sale_order`
WHERE (`canceled` = 'N') AND (`date_insert` BETWEEN :StartD AND :EndD)
GROUP BY `date`
ORDER BY `date`