SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_331_16.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT SQL_CALC_FOUND_ROWS DISTINCT `i`.*, `d`.`name`, `d`.`name_decl_1`, `d`.`name_decl_2`, `d`.`status`, `d`.`h1`, `d`.`description`, `d`.`meta_title`, `d`.`meta_keywords`, `d`.`meta_description`, `cd`.`item_info`, `cd`.`item_faq`, `d`.`playlist_links`, `c`.`url` AS `category_url`, `c`.`is_hidden` AS `category_is_hidden`, `cd`.`name` AS `category_name`, `cd`.`default_item_delivery_params` AS `category_default_item_delivery_params`, `b`.`id` AS `brand_id`, `b`.`link` AS `brand_url`, `b`.`name` AS `brand_name`, `b`.`item_remark` AS `brand_item_remark`, `d`.`quick_desc`, `d`.`created_date`, `tags`.`tags`, IF(`tracker`.`cart_counter` IS NULL, 0, `tracker`.`cart_counter`) AS `cart_counter`, IF(`tracker`.`order_counter` IS NULL, 0, `tracker`.`order_counter`) AS `order_counter`, IF(`tracker`.`favorite_counter` IS NULL, 0, `tracker`.`favorite_counter`) AS `favorite_counter` FROM `catalog_item` AS `i` LEFT JOIN `catalog_item_data` AS `d` ON `d`.`item_id` = `i`.`id` LEFT JOIN `catalog_cat` AS `c` ON `c`.`id` = `i`.`cat_id` LEFT JOIN `catalog_cat_data` AS `cd` ON `cd`.`cat_id` = `i`.`cat_id` LEFT JOIN `catalog_brands` AS `b` ON `b`.`id` = `i`.`brand_id` LEFT JOIN ( SELECT `item_id`, GROUP_CONCAT(`tag_id` SEPARATOR ',') AS `tags` FROM `catalog_tags` GROUP BY `item_id` ) AS `tags` ON `tags`.`item_id` = `i`.`id` LEFT JOIN `catalog_item_trackers` AS `tracker` ON `tracker`.`item_id` = `i`.`id` WHERE i.is_hidden IN('0', '1') AND i.is_disabled = '0' AND i.cat_id IS NOT NULL AND i.is_ghost = '0' AND i.link = 'andrej-melamed' AND c.url = '/vedushhie-zarubezhom/' ORDER BY i.popularity DESC LIMIT 0, 1