Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.b64c59b5dcdea6ed31d9fcfa9686c016): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.d6d2e4724b18822250562aaa5a62b343): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.d6eaa39cd7897724b365591dd392545e): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.ecd4187b43a0b0c1a8912160f5a44b3b): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.ede6f70ad67004e389a7c33f55e3c8aa): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.0f2ca0c48922b17d90a53b5285169619): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.2fd2d06fd23e411b03ab03d3e9d1273b): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.4f9a2b6be5471c67e425d7c137fad08f): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.4fa46300edb4a153012834777449308f): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.4fac51c601aeac88ba5ec4ae5b568c34): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.4fccfa503d24f7f23051ec7519d54b72): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.5011d5eb877bb793b3351b1eeab0be6b): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.853ff61c360b0910d8cf4e3a07c99ff4): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.b036a467d54925fee603f7930de5a365): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.product.ocfilter.counter.db2a3a21c02a81264d829386af37fd8e): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Notice: Error: Out of resources when opening file './imperiakovrov/oc_ocfilter_option_value_to_product.MYD' (Errcode: 24 "Too many open files")
Error No: 23
SELECT value_id, option_id, total FROM (SELECT p.manufacturer_id AS value_id, 'm' AS option_id, COUNT(p.manufacturer_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2c.category_id = '1' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_ocfilter_option_value_to_product oov2p1 INNER JOIN oc_ocfilter_option_value_to_product oov2p2 ON (oov2p1.product_id = oov2p2.product_id) WHERE oov2p1.option_id = '42' AND (oov2p1.value_id = '2097641172') AND oov2p2.option_id = '43' AND (oov2p2.value_id = '851965790' OR oov2p2.value_id = '2409687934' OR oov2p2.value_id = '2689664470' OR oov2p2.value_id = '2706818040' OR oov2p2.value_id = '2976767410' OR oov2p2.value_id = '3056975774' OR oov2p2.value_id = '3358000694' OR oov2p2.value_id = '3493589337' OR oov2p2.value_id = '3903916978')) GROUP BY p.manufacturer_id UNION ALL SELECT IF(p.quantity > '0', 'in', 'out') AS value_id, 's' AS option_id, COUNT(*) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2c.category_id = '1' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_ocfilter_option_value_to_product oov2p1 INNER JOIN oc_ocfilter_option_value_to_product oov2p2 ON (oov2p1.product_id = oov2p2.product_id) WHERE oov2p1.option_id = '42' AND (oov2p1.value_id = '2097641172') AND oov2p2.option_id = '43' AND (oov2p2.value_id = '851965790' OR oov2p2.value_id = '2409687934' OR oov2p2.value_id = '2689664470' OR oov2p2.value_id = '2706818040' OR oov2p2.value_id = '2976767410' OR oov2p2.value_id = '3056975774' OR oov2p2.value_id = '3358000694' OR oov2p2.value_id = '3493589337' OR oov2p2.value_id = '3903916978')) GROUP BY value_id UNION ALL SELECT oov2p.value_id, oov2p.option_id, COUNT(p.product_id) AS total FROM oc_ocfilter_option_value_to_product oov2p LEFT JOIN oc_product_to_category p2c ON (oov2p.product_id = p2c.product_id) LEFT JOIN oc_product p ON (oov2p.product_id = p.product_id) WHERE oov2p.value_id > '0' AND p.status = '1' AND p2c.category_id = '1' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_ocfilter_option_value_to_product oov2p1 INNER JOIN oc_ocfilter_option_value_to_product oov2p2 ON (oov2p1.product_id = oov2p2.product_id) WHERE oov2p1.option_id = '42' AND (oov2p1.value_id = '2097641172') AND oov2p2.option_id = '43' AND (oov2p2.value_id = '851965790' OR oov2p2.value_id = '2409687934' OR oov2p2.value_id = '2689664470' OR oov2p2.value_id = '2706818040' OR oov2p2.value_id = '2976767410' OR oov2p2.value_id = '3056975774' OR oov2p2.value_id = '3358000694' OR oov2p2.value_id = '3493589337' OR oov2p2.value_id = '3903916978')) GROUP BY oov2p.option_id, oov2p.value_id UNION ALL SELECT oov2p.value_id, oov2p.option_id, COUNT(p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (p.product_id = oov2p.product_id) WHERE oov2p.option_id = '42' AND p.status = '1' AND p2c.category_id = '1' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_ocfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '43' AND (oov2p1.value_id = '851965790' OR oov2p1.value_id = '2409687934' OR oov2p1.value_id = '2689664470' OR oov2p1.value_id = '2706818040' OR oov2p1.value_id = '2976767410' OR oov2p1.value_id = '3056975774' OR oov2p1.value_id = '3358000694' OR oov2p1.value_id = '3493589337' OR oov2p1.value_id = '3903916978')) GROUP BY oov2p.option_id, oov2p.value_id UNION ALL SELECT oov2p.value_id, oov2p.option_id, COUNT(p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (p.product_id = oov2p.product_id) WHERE oov2p.option_id = '43' AND p.status = '1' AND p2c.category_id = '1' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_ocfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '42' AND (oov2p1.value_id = '2097641172')) GROUP BY oov2p.option_id, oov2p.value_id) results in /var/www/imperiakovrov.com/system/database/mysql.php on line 27