SELECT to_char(c.date, 'YYYY-MM-dd HH24:MI:ss') as day,
c.title, c.email, c.price, c.pages
FROM (
SELECT MIN(date) AS date, email FROM customer GROUP BY email
) AS t
JOIN customer AS c ON c.date = t.date AND c.email = d.emailBIT_COUNT(HEX(:value1) ^ HEX(:value2))
ST_GeomFromText('POINT(55.0502 82.9615)', 4326)
UPDATE `address` AS `a1`
JOIN (
SELECT MIN(`id`) AS `id` FROM `address` GROUP BY `organizationfk`
) AS `a2` ON `a2`.`id` = `a1`.`id`
LEFT JOIN (
SELECT `organizationfk` FROM `address` WHERE `primary` = 1
) AS `a3` ON `a3`.`organizationfk` = `a1`.`organizationfk`
SET `a1`.`primary` = 1
WHERE `a3`.`organizationfk` IS NULLSELECT DISTINCT `t3b`.`table1_id`
FROM `table3` AS `t3a`
JOIN `table3` as `t3b` ON `t3b`.`table2_id` = `t3a`.`table2_id`
AND `t3b`.`table1_id` != `t3a`.`table1_id`
WHERE `t3a`.`table1_id` = :idSELECT id
FROM places p
JOIN (
SELECT place_id
FROM example
WHERE equi_id IN (1, 2, 3)
GROUP BY place_id
HAVING COUNT(place_id) = 3
) e ON e.place_id = p.id
WHERE p.param1 = 1 AND p.param2 = 2SELECT `t2`.`field1`
FROM `table2` AS `t2`
JOIN `table1` AS `t1` ON `t1`.`field1` = 1373369
WHERE `t2`.`field2` = 282SELECT `a`.`id_car`, `m`.`MarkName`, `a`.`CarNumber`, `a`.`Fuel`, `a`.`isActive`
FROM `Автомобили` AS `a`
LEFT JOIN `Марки` AS `m` ON `a`.`MarkID` = `m`.`id_mark`