[SELECT failed in SQL: SELECT `site_shop_produkt`.`id`,`site_shop_produkt`.`img` AS img_mas,`site_shop_produkt`.`icons`, `site_shop_produkt`.`short_name`,`site_shop_produkt`.`product_kod`, `site_shop_produkt`.`swf`, `site_shop_produkt`.`video`, `site_shop_produkt`.`price_ru`,`site_shop_produkt`.`price_ua`,`site_shop_produkt`.`price_bel`,`site_shop_produkt`.`price_tenge`,`site_shop_produkt`.`id_overview`, `site_shop_produkt`.`best_price`, `site_shop_produkt`.`instruction`, `site_shop_produkt`.`rukovodstvo`,`site_shop_produkt`.`icc`, `site_shop_produkt`.`drivers`, `site_shop_produkt`.`awards`, `site_shop_produkt`.`precisioncore`, `site_shop_produkt`.`rekomend`, `site_shop_produkt`.`set`, `site_shop_produkt`.`descr`, `site_shop_produkt`.`descr_single_goods`, `site_shop_produkt`.`alt_image`, `site_shop_produkt`.`title_image`, `site_shop_produkt`.`keyw_meta`,`site_shop_produkt`.`descr_meta`, `site_shop_produkt`.`title_meta`, `site_shop_produkt`.`seo_text`, `site_shop_produkt`.`meta_robots`, `site_shop_produkt`.`rel_canonical`, `site_shop_produkt`.`sort`,`site_shop_produkt`.`en_circle_link`, `site_shop_produkt`.`update_data`, `site_shop_produkt`.`en`, `site_shop_produkt`.`pay_part_pv`, `site_shop_produkt`.`instant_installment`, `site_shop_produkt`.`free_shipping_ru` as free_shipping, `site_shop_produkt`.`free_shipping_url`, `site_shop_produkt`.`american_product`, `site_shop_produkt`.`photopaper_gift_ru` as photopaper_gift, `site_shop_produkt`.`photopaper_gift_url`, `site_shop_produkt`.`market_name` ,site_shop_produkt_1.id AS parent_1_id, site_shop_produkt_1.pid AS parent_1_pid, site_shop_produkt_1.name AS parent_1_name, site_shop_produkt_1.url AS parent_1_url, site_shop_produkt_2.id AS parent_2_id, site_shop_produkt_2.pid AS parent_2_pid, site_shop_produkt_2.name AS parent_2_name, site_shop_produkt_2.url AS parent_2_url, site_shop_produkt_3.id AS parent_3_id, site_shop_produkt_3.pid AS parent_3_pid, site_shop_produkt_3.name AS parent_3_name, site_shop_produkt_3.url AS parent_3_url, site_shop_produkt.id, site_shop_produkt.pid, site_shop_produkt.nabor, site_shop_produkt.name, `site_shop_produkt`.`url`, `site_shop_produkt`.`price_ru` AS price, `site_shop_produkt`.`availability_ru` as availability, `site_shop_produkt`.`zamena`, `site_shop_produkt`.`new`, `site_shop_produkt`.`hit`, `site_shop_produkt`.`spec`, `site_shop_produkt`.`soput`, `site_shop_produkt`.`complect` ,( SELECT `site_shop_sale`.`name` FROM site_shop_sale WHERE site_shop_sale.`id` = site_shop_produkt.`sale_ru` LIMIT 1 ) AS sale_value,( SELECT `site_shop_produkt_img`.`img` FROM site_shop_produkt_img WHERE site_shop_produkt_img.`pid` = site_shop_produkt.`id` ORDER BY sort DESC LIMIT 1 ) AS img,( SELECT `site_shop_availability`.`name` FROM site_shop_availability WHERE site_shop_produkt.`availability_ru` = site_shop_availability.`id` LIMIT 1 ) AS availability_name,( SELECT `site_3d`.`swf` FROM site_3d WHERE site_shop_produkt.`swf` = site_3d.`id` LIMIT 1 ) AS swf_3d,COUNT(DISTINCT(site_reviews_products.id)) AS count_reviews, AVG(site_reviews_products.rate) AS avg_rate FROM `site_shop_produkt` LEFT JOIN site_shop_cat AS site_shop_produkt_1 ON site_shop_produkt.pid = site_shop_produkt_1.id LEFT JOIN site_shop_cat AS site_shop_produkt_2 ON site_shop_produkt_1.pid = site_shop_produkt_2.id LEFT JOIN site_shop_cat AS site_shop_produkt_3 ON site_shop_produkt_2.pid = site_shop_produkt_3.id LEFT JOIN site_reviews_products ON site_reviews_products.pid = site_shop_produkt.id AND site_reviews_products.en = 1 WHERE `site_shop_produkt`.`id` IN(7383,11209,11208,423) AND `site_shop_produkt`.`pid` NOT IN(4,66) GROUP BY `site_shop_produkt`.`id` ORDER BY sort DESC ] ( 1021 : Disk full (/var/lib/tmp_mysql/#sql_51f0_8); waiting for someone to free some space... )
\n