Rsa97

SELECT `p`.`product_id`, `p2s`.`price`
  FROM `product` AS `p`
  JOIN (
    SELECT `product_id`, MIN(`price`) AS `min_price`
      FROM `product_to_supplier`
      WHERE `price` > 0 AND `quantity` > 0
      GROUP BY `product_id`
  ) AS `p2s` ON `p2s`.`product_id` = `p`.`product_id`
  WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() 
    AND `p`.`manufacturer_id` = '5011' 
  ORDER BY `p`.`sort_order` ASC, LCASE(`p`.`name`) ASC
  LIMIT 0,15

UPDATE `table` AS `t1`
  LEFT JOIN `table` AS `t2`
    ON `t2`.`phone` = `t1`.`phone` AND ...
      AND `t2`.`works` > `t1`.`works`
  SET `t1`.`delete` = 1

SELECT *
  FROM `table`
  WHERE `user_id` IN (
    SELECT `id`
      FROM `users`
      WHERE `id` > :lastUserId
      ORDER BY `id`
      LIMIT 1000
  )

SELECT `d`.`datetime`, COUNT(`th`.`create_time`) AS `count`
  FROM (
    SELECT DISTINCT DATE(`create_time`) + INTERVAL 22 HOUR AS `datetime`
      FROM `tick`
  ) AS `d`
  LEFT JOIN `tick_history` AS `th` 
    ON `th`.`create_time` < `d`.`datetime`
      AND `th`.`state` NOT IN (1, 4, 9)
      AND `th`.`queue` = 1
  GROUP BY `d`.`datetime`

IF NEW.`Course` = '6' THEN SET NEW.`Course` = 'Web design';

UPDATE `table` AS `t1`
  JOIN `table` AS `t2`
    ON `t2`.`user_id` = `t1`.`user_id`
      AND `t2`.`param` = :param2 AND `t2`.`value` = :value2
      AND `t1`.`param` = :param1
  SET `t1`.`value` = :newValue1