Что-то поломалось, мы уже решаем проблему
Вернуться на главную
Disk full (/tmp/#sql_3d9_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") [ SELECT `promotion`.* FROM `promotion` AS `promotion` LEFT JOIN `promotion_statement` ON (`promotion_statement`.`id_promotion` = `promotion`.`id`) LEFT JOIN `promotion_statistic` ON (`promotion_statistic`.`id_promotion` = `promotion`.`id`) LEFT JOIN `categories` ON (`categories`.`id` = `promotion`.`category`) WHERE `categories`.`type` = 19 AND `categories`.`name` = 'class_b_1' AND (`promotion`.`start_date` <= '2024-03-29' OR `promotion`.`start_date` IS NULL) AND (`promotion`.`end_date` >= '2024-03-29' OR `promotion`.`end_date` IS NULL) AND `promotion`.`enabled` = '1' AND `promotion`.`removed` = '0' AND ((`promotion_statement`.`time_begin` <= '02' AND COALESCE(promotion_statement.time_end, 24) >= '02') OR (`promotion_statement`.`time_begin` IS NULL AND `promotion_statement`.`time_end` IS NULL)) AND (COALESCE(view_sale_count, 0) < COALESCE(promotion.view_count, 0) OR `promotion`.`view_count` = 0 OR `promotion`.`view_count` IS NULL) AND (view_limit > (SELECT COALESCE(SUM(`view_count`), 0) AS `views_on` FROM `promotion_statistic` WHERE CAST(`date` as DATE) = CURDATE() AND `promotion`.`id` = promotion_statistic.id_promotion) OR COALESCE(view_limit, 0) = 0) GROUP BY `promotion`.`id` ORDER BY RAND() LIMIT 1 ]