Disk full (/tmp/#sql_512_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (1021)
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM mvy_products as products LEFT JOIN mvy_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru' LEFT JOIN mvy_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN mvy_companies AS companies ON companies.company_id = products.company_id INNER JOIN mvy_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN mvy_categories ON mvy_categories.category_id = products_categories.category_id AND (mvy_categories.usergroup_ids = '' OR FIND_IN_SET(0, mvy_categories.usergroup_ids) OR FIND_IN_SET(1, mvy_categories.usergroup_ids)) AND mvy_categories.status IN ('A', 'H') AND mvy_categories.storefront_id IN (0, 1) WHERE 1 AND mvy_categories.category_id IN (217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 264, 265, 266, 267, 268, 269, 270, 271, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id = 7 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.company_id = 7 AND products.master_product_status IN ('A') GROUP BY product_id ORDER BY product asc, products.product_id ASC LIMIT 180, 12
app/Tygh/Database/Connection.php, line: 1713
| File: | app/Tygh/Database/Connection.php |
| Line: | 1490 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 700 |
| Function: | execQuery |
| File: | app/Tygh/Database/Connection.php |
| Line: | 333 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 35 |
| Function: | getArray |
| File: | app/functions/fn.products.php |
| Line: | 2361 |
| Function: | db_get_array |
| File: | app/functions/fn.products.php |
| Line: | 2444 |
| Function: | {closure} |
| File: | app/controllers/frontend/companies.php |
| Line: | 404 |
| Function: | fn_get_products |
| File: | app/functions/fn.control.php |
| Line: | 727 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |