Disk full (/tmp/#sql_28bc_3.MAI); waiting for someone to free some space... (errno: 28 &quot;No space left on device&quot;)<br /><br /><pre>SELECT
                `fvl`.`value`,
                COUNT(`p`.`id_product`) AS `count_product`
            FROM `ps_category` AS `c`
            INNER JOIN `ps_product` AS `p` ON (`c`.`id_category` = `p`.`id_category_default`)
            INNER JOIN `ps_feature_product` AS `fp`
                ON ((`p`.`id_product` = `fp`.`id_product`) AND (`fp`.`id_feature` = '5'))
            INNER JOIN `ps_feature_value_lang` AS `fvl`
                ON ((`fp`.`id_feature_value` = `fvl`.`id_feature_value`) AND (`fvl`.`id_lang` = '6'))
            /* dwa złączenia służące określeniu widoczności produktu */
            LEFT JOIN `ps_group_lang` AS `gl`
                ON ((`p`.`target_group` = `gl`.`name`) AND (`gl`.`id_lang` = '6'))
            LEFT JOIN `ps_customer_group` AS `cg`
                ON ((`gl`.`id_group` = `cg`.`id_group`) AND (`cg`.`id_customer` = '0'))
            WHERE (`c`.`id_category` = '492') AND (`c`.`active` = '1')
                /* sprawdzenie widoczności produktu */
                AND (`p`.`active` = '1') AND ((`p`.`target_group` = 'ALL') OR (`cg`.`id_customer` IS NOT NULL))
            GROUP BY `fvl`.`value`
            /* posortuj według ilości produktów */
            ORDER BY `count_product` DESC
            LIMIT 0, 5
        </pre>