Warning: unlink(/var/www/imperiakovrov.com/system/cache/cache.ocfilter.product.price.1.1.0.fbff68d30dd686b2356edd0af42febf2): 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.17f16d1ce440c6012cfeeae1f672354c): 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.30b99306869ebaffda051e8ed12c635a): 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.30bea2621055a3199f49899598c94616): 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.30bf3a890b539c7827885f4b17e18e9a): 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.30c1942136f3a788df1de6e0da780726): 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.30c2c804b68b4273a92b4f55509aa756): 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.30c33f15eac04ecd7e03145783003f76): 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.30c4fb0851863fcd47b9af7f50c1043a): 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.30cd1f8f8cad62618edaffd8f9013294): 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.30ceed5ff5d7a7193bc85bc387e12ad0): 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.30d0d344d9d98daf37eb73720312b9b2): 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.30d95153cc2a14943892ecaebe060e0f): 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.30ee385c79b111533c79ea534cfcee09): 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.3102197761b884af840591be57e8512a): 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.3115a46eb4637ac9aa866212a9410517): 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.3117bd8818dd0f8a1d91774732fec8ea): 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.311b112dbf6474d491e4cacb142739e9): 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.3122c5730df5491dd6e7ccbade585daf): 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.31406f85b30c687cfd8243466ac9bf96): 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.315774a04ad24e9e99542a37ac952fc9): 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.3176dab158c7064f98740e3f20c5b6b8): 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.3186ac3a289bf96a83748d6c2b1cae62): 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.339488f731398adea5ed9c9dd7a7428b): 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.56109f747830b13b1454ee36a7e7a7bb): 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.7d8ea814d481ed44839ad2e05bcb6946): 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.9aba890b179dc6e22ce3f5afe6f846ef): 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.cff6a153b8bcae5f54d86cc1e195eb6c): 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.f4646eaaf6e5fc5ff80dbe7734b53a67): 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_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 WHERE oov2p1.option_id = '43' AND (oov2p1.value_id = '625558286' OR oov2p1.value_id = '690294136' OR oov2p1.value_id = '851965790' OR oov2p1.value_id = '1343731165' OR oov2p1.value_id = '1856895442' OR oov2p1.value_id = '2323353659' OR oov2p1.value_id = '2937114599' OR oov2p1.value_id = '2976767410' OR oov2p1.value_id = '3092116153' OR oov2p1.value_id = '3236746612' OR oov2p1.value_id = '3429089862' OR oov2p1.value_id = '3493589337' OR oov2p1.value_id = '3581473543' OR oov2p1.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 WHERE oov2p1.option_id = '43' AND (oov2p1.value_id = '625558286' OR oov2p1.value_id = '690294136' OR oov2p1.value_id = '851965790' OR oov2p1.value_id = '1343731165' OR oov2p1.value_id = '1856895442' OR oov2p1.value_id = '2323353659' OR oov2p1.value_id = '2937114599' OR oov2p1.value_id = '2976767410' OR oov2p1.value_id = '3092116153' OR oov2p1.value_id = '3236746612' OR oov2p1.value_id = '3429089862' OR oov2p1.value_id = '3493589337' OR oov2p1.value_id = '3581473543' OR oov2p1.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 WHERE oov2p1.option_id = '43' AND (oov2p1.value_id = '625558286' OR oov2p1.value_id = '690294136' OR oov2p1.value_id = '851965790' OR oov2p1.value_id = '1343731165' OR oov2p1.value_id = '1856895442' OR oov2p1.value_id = '2323353659' OR oov2p1.value_id = '2937114599' OR oov2p1.value_id = '2976767410' OR oov2p1.value_id = '3092116153' OR oov2p1.value_id = '3236746612' OR oov2p1.value_id = '3429089862' OR oov2p1.value_id = '3493589337' OR oov2p1.value_id = '3581473543' 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' GROUP BY oov2p.option_id, oov2p.value_id) results in /var/www/imperiakovrov.com/system/database/mysql.php on line 27