$mysqli->query("INSE..."); UPDATE linestatuslog s, (SELECT * FROM linestatuslog ORDER BY startDate) n
SET s.endDate = n.startDate
WHERE n.line = s.line AND n.startDate > s.startDateSELECT t1.name, UNIX_TIMESTAMP(t1.create_time) - UNIX_TIMESTAMP(t2.create_time) as second -- время между событиями в секундах
FROM ticket_history t1
INNER JOIN ticket_history t2 ON t2.ticket_id = t1.ticket_id AND t2.hystory_type_id=2 -- открытие тикета
WHERE t1.hystory_type_id=15 -- закрытые тикетыSELECT order_id, COUNT(*) as cnt
FROM markers
WHERE m_id IN (10, 20, 30)
GROUP BY order_id
HAVING cnt=3 -- тут количество искомых параметров 10, 20, 30SELECT
COUNT(*)
FROM
`item` AS `i`
LEFT JOIN `cat_struct` AS `cs` ON (i.cat_id = cs.id)
WHERE
(`i`.`status` = 'active')
AND (`i`.`has_image` = 'yes')
AND (`i`.`type` = 'advert')
AND (`cs`.`lkey` BETWEEN '4094'AND '4877')
AND (`cs`.`rkey` BETWEEN '0' AND '4877')
GROUP BY `i`.`id`SELECT m.*, GROUP_CONCAT(g.genre_title ORDER BY g.genre_title ASC SEPARATOR'; ') as genre_titles
FROM music m
INNER JOIN xref_music_genre mg ON mg.music_id = m.id
INNER JOIN genre g ON g.genre_id = mg.genre_id
GROUP BY m.idselect *
from table
order by ifnull(r.time_pay_for, r.time_update)