public function index() {
$query = 'UPDATE `'.DB_PREFIX.'product` AS `p`
INNER JOIN (
SELECT `t`.`sku`, MIN(`p`.`product_id`) AS `product_id`
FROM (
SELECT `sku`, MIN(`price`) AS `price`
FROM `'.DB_PREFIX.'product`
WHERE `quantity` != 0
GROUP BY `sku`
) AS `t`
JOIN `'.DB_PREFIX.'product` AS `p`
ON `p`.`sku` = `t`.`sku` AND `p`.`price` = `t`.`price`
WHERE `p`.`quantity` != 0
GROUP BY `t`.`sku`
) AS `i` ON `i`.`product_id` = `p`.`product_id`
SET `p`.`status` = (`i`.`product_id` IS NOT NULL)';
$response = $this->db->query($query)->rows;
if(is_object($response)){
echo 'Все ок '.$query.' вернул обьект '.PHP_EOL;
}else{
echo 'Все пропало! '.$query.' не вернул обьект! '.PHP_EOL;
}
echo "ok";
}} else {
return true;
}update table set field1 = field2 where id in (1,2,3,4,5,6,7,1000);