Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.0d0530bed3939cadae321328fcc106bd): 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.3903f382b3af9829364109e8a0205ee1): 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.393de7aa5f0a97e027c9c5ef49feff48): 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.39524a388d182983ff3a95d47d3aa1fc): 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.39526b4570c65c53f0d3e5d446f653ca): 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.39797af4bc5324587f2c65044f936cd6): 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.397dcb2e96c3805183d11324893dfdac): 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.398377e44d8216657bb07320596214d1): 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.3990967914e2ea5f34ff9dfe5d3e542d): 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.39a0b0fe35187dd7c1164cf846164a3b): 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.39a9d42036f9abfd541354da733a73c5): 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.39af140c41491dd97202af015e549b6f): 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.39bf973356b5175608e69402a6a87411): 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.39ce753a853a24d893c40a0577d5024c): 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.39f17561f05ef2cde3f39b6ec1d83191): 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.3a0fb647b6be9f1ea1c68318212bfd29): 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.3a155a61b42fca31948ebd860929733e): 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.3a17751446097d244eb231a2d164d9ef): 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.3a73db8f2df992442d17bcedeb1a46c1): 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.3a7e3dee2ae2cb598709ba3e8e11f8e3): 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.3a82a41e4c1d262c20daa83e88535de0): 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.3a997e87ee401692f29c15c8a1b52bb2): 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.3aa37d5340937ac002d50bbbb7e0db57): 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.3aa51488c584e88f8db3b1dba82b96e9): 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.3aaf5b4786e6a899f2da48ce67abbcfc): 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.3abbf5cd9330c25f776644a6050a1dc5): 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.3ac39caa0019fcfc55f2ca8999571aaf): 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.3ac48c6005c957379cba1b903f7633af): 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.3b3fce3f7525df803259b5fb1c754f87): 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.40dbbc9f8c3e24c89f97b728030f9f73): 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.711a64a4d081c1aa6ad0c4b540e3823e): 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.a041e2602562a7734b0ab3a910d8e32c): 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.d438137ab21c808055521089690717ad): 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.1267a6d4e3fcc6d1ab0eaa25fc36b706): 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.6241b0c679fbff90f7889441dc056bc2): 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.624baf2e7d8ae2adc1dd4e5870ee1cec): 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.b56b30c89877011917f1468c15d5c38f): No such file or directory in /var/www/imperiakovrov.com/system/library/cache.php on line 13Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /var/www/imperiakovrov.com/index.php:108) in /var/www/imperiakovrov.com/system/library/session.php on line 11Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /var/www/imperiakovrov.com/index.php:108) in /var/www/imperiakovrov.com/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /var/www/imperiakovrov.com/index.php:108) in /var/www/imperiakovrov.com/index.php on line 181Warning: Cannot modify header information - headers already sent by (output started at /var/www/imperiakovrov.com/index.php:108) in /var/www/imperiakovrov.com/system/library/currency.php on line 47Warning: Cannot modify header information - headers already sent by (output started at /var/www/imperiakovrov.com/index.php:108) in /var/www/imperiakovrov.com/system/library/currency.php on line 47Warning: Cannot modify header information - headers already sent by (output started at /var/www/imperiakovrov.com/index.php:108) in /var/www/imperiakovrov.com/system/library/agoo/multilang.php on line 247Notice: 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 = '4' 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 = '128884587' OR oov2p1.value_id = '650931736' OR oov2p1.value_id = '795911072' OR oov2p1.value_id = '954375868' OR oov2p1.value_id = '1052161238' OR oov2p1.value_id = '1107011529' OR oov2p1.value_id = '2047782018' OR oov2p1.value_id = '2473396663' OR oov2p1.value_id = '2628606504' OR oov2p1.value_id = '3290576475')) 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 = '4' 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 = '128884587' OR oov2p1.value_id = '650931736' OR oov2p1.value_id = '795911072' OR oov2p1.value_id = '954375868' OR oov2p1.value_id = '1052161238' OR oov2p1.value_id = '1107011529' OR oov2p1.value_id = '2047782018' OR oov2p1.value_id = '2473396663' OR oov2p1.value_id = '2628606504' OR oov2p1.value_id = '3290576475')) 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 = '4' 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 = '128884587' OR oov2p1.value_id = '650931736' OR oov2p1.value_id = '795911072' OR oov2p1.value_id = '954375868' OR oov2p1.value_id = '1052161238' OR oov2p1.value_id = '1107011529' OR oov2p1.value_id = '2047782018' OR oov2p1.value_id = '2473396663' OR oov2p1.value_id = '2628606504' OR oov2p1.value_id = '3290576475')) 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 = '4' GROUP BY oov2p.option_id, oov2p.value_id) results in /var/www/imperiakovrov.com/system/database/mysql.php on line 27