<b>Warning</b>: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in <b>/var/www/japvit/data/www/japvit.ru/system/database/mysql.php</b> on line <b>21</b><b>Notice</b>: Error: Disk full (/tmp/#sql-temptable-2f7-5c77d-2511.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />SELECT c.*, cd.*, COUNT(p2c.category_id) AS products_count
                FROM category c
                INNER JOIN category_description cd ON (c.category_id = cd.category_id)
                INNER JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
                LEFT JOIN product_to_store AS p2s ON p2s.store_id = c2s.store_id
                LEFT JOIN product_to_category AS p2c ON c.category_id = p2c.category_id AND p2c.product_id = p2s.product_id
                WHERE c.parent_id = 138
                      AND cd.language_id = 1
                      AND c2s.store_id = 0
                      AND c.status = 1 AND c.sort_order <> -1
                GROUP BY c.category_id
                ORDER BY c.sort_order, LCASE(cd.name) in <b>/var/www/japvit/data/www/japvit.ru/system/database/mysql.php</b> on line <b>49</b>