Rsa97

~(start2 > end1 || start2 > end1) = 
= ~(start2 > end1) && ~(start2 > end1) = 
= start2 <= end1 && start2 <= end1

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

(document.URL.substr(0,23)=="https://remontspb-78.ru" || document.URL.substr(0,27)=="https://www.remontspb-78.ru")?0:step=1;

	(step<1)?step=1:step>5?step=5:0;
	(step==1)?$('#prev_button').hide():$('#prev_button').show();
	(step==5)?$('#next_button').hide():$('#next_button').show();
	if (step==5){
		$('#calc_button').show();
		$('#next_button').hide();
		$('#calc_button').show();
	}
	else
		$('#calc_button').hide();
	SetNavStatus();
	$('#main_param').hide();
	$('#rooms').hide();
	$('#kitchen').hide();
	$('#corridor').hide();
	$('#bathrooms').hide();