Notice: Error: Out of resources when opening file './bigtoysv2/oc_product_to_category.MYD' (Errcode: 24) Error No: 23 SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' and (`show_on_category`=0 or `show_on_category` is NULL) AND cp.path_id = '289' AND (p.hide_on_category=0 or p.hide_on_category is null) in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 749Notice: Error: Out of resources when opening file './bigtoysv2/oc_product_ostatki.MYD' (Errcode: 24) Error No: 23 SELECT p.product_id,IF(p.synchro_id<>'',
(select sum(IF(po.skald_name<>'PODZAKAZ',if(po.quantity>0,po.quantity+if(DATEDIFF(now(),p.date_added)<30,100000,1000),0),1)) as c from oc_product_ostatki po Where po.product_id=p.product_id),
if(p.quantity>0,p.quantity+if(DATEDIFF(now(),p.date_added)<30,100000,10000) ,0)
) as quantitytst, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_v ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' and (`show_on_category`=0 or `show_on_category` is NULL) AND cp.path_id = '289' AND (p.hide_on_category=0 or p.hide_on_category is null) GROUP BY p.product_id ORDER BY quantitytst desc,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,25 in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 365Warning: Invalid argument supplied for foreach() in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 365Notice: Error: Out of resources when opening file './bigtoysv2/oc_attribute.MYD' (Errcode: 24) Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`oc_product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 4
INNER JOIN
`oc_attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`oc_attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 4
INNER JOIN
`oc_attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`oc_attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 4
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND (p.hide_on_category is NULL or p.hide_on_category=0 ) AND `cp`.`path_id` IN(289)
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Error: Out of resources when opening file './bigtoysv2/oc_product_option_value.MYD' (Errcode: 24) Error No: 23
SELECT
`o`.`option_id`,
`ov`.`option_value_id`,
`od`.`name` AS `gname`,
`ov`.`image`,
`ovd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_option_value` AS `pov`
ON
`p`.`product_id` = `pov`.`product_id`
INNER JOIN
`oc_option_value` AS `ov`
ON
`ov`.`option_value_id` = `pov`.`option_value_id`
INNER JOIN
`oc_option_value_description` AS `ovd`
ON
`ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 4
INNER JOIN
`oc_option` AS `o`
ON
`o`.`option_id` = `pov`.`option_id`
INNER JOIN
`oc_option_description` AS `od`
ON
`od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 4
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND (p.hide_on_category is NULL or p.hide_on_category=0 ) AND `cp`.`path_id` IN(289) AND `o`.`type` IN('radio','checkbox','select','image','image_radio')
GROUP BY
`o`.`option_id`, `ov`.`option_value_id`
ORDER BY
`ov`.`sort_order`, `ovd`.`name`
in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 2662Warning: Invalid argument supplied for foreach() in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 2662Notice: Error: Out of resources when opening file './bigtoysv2/oc_product_filter.MYD' (Errcode: 24) Error No: 23
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`oc_filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`oc_filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 4
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 4
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND (p.hide_on_category is NULL or p.hide_on_category=0 ) AND `cp`.`path_id` IN(289)
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 2552Warning: Invalid argument supplied for foreach() in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 2552Notice: Error: Out of resources when opening file './bigtoysv2/oc_category_path.MYD' (Errcode: 24) Error No: 23
SELECT
`c`.`parent_id`,
`c`.`category_id`,
`cd`.`name`,
(
SELECT
COUNT(DISTINCT `p`.`product_id`) AS total
FROM
`oc_product_to_category` AS `p2c`
INNER JOIN
`oc_product` AS `p`
ON
`p`.`product_id` = `p2c`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND (p.hide_on_category is NULL or p.hide_on_category=0 ) AND `cp`.`path_id` = `c`.`category_id`
) AS `aggregate`
FROM
`oc_category` AS `c`
INNER JOIN
`oc_category_description` AS `cd`
ON
`cd`.`category_id` = `c`.`category_id` AND `cd`.`language_id` = '4'
WHERE
`c`.`status` = '1' AND `c`.`parent_id` = 289
GROUP BY
`c`.`category_id`
ORDER BY
`c`.`sort_order` ASC, `cd`.`name` ASC
in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 1507Warning: Invalid argument supplied for foreach() in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 1507Notice: Error: Can't open file: './bigtoysv2/oc_manufacturer_to_store.frm' (errno: 24) Error No: 1016
SELECT
`m`.*
FROM
`oc_manufacturer` AS `m`
INNER JOIN
`oc_manufacturer_to_store` AS `m2s`
ON
`m`.`manufacturer_id` = `m2s`.`manufacturer_id` AND `m2s`.`store_id` = '0'
INNER JOIN `oc_product` AS `p` ON `p`.`manufacturer_id` = `m`.`manufacturer_id`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND (p.hide_on_category is NULL or p.hide_on_category=0 ) AND `cp`.`path_id` IN(289)
GROUP BY `m`.`manufacturer_id`
ORDER BY
`m`.`name` ASC
in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 2455Warning: Invalid argument supplied for foreach() in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 2455Notice: Error: Out of resources when opening file './bigtoysv2/oc_product_description.MYD' (Errcode: 24) Error No: 23 SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM(
SELECT
IFNULL( (SELECT `price` FROM `oc_product_special_v` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1), IFNULL( (SELECT `price` FROM `oc_product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1), `p`.`price` ) ) AS `price_tmp`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_description` AS `pd`
ON
`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 4
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
INNER JOIN
`oc_category_path` AS `cp`
ON
`cp`.`category_id` = `p2c`.`category_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND (p.hide_on_category is NULL or p.hide_on_category=0 ) AND `cp`.`path_id` IN(289)
) AS `tmp` ) AS `tmp` in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-system_storage_modification_catalog_model_module_mega_filter.php on line 1397Notice: Error: Out of resources when opening file './bigtoysv2/oc_review.MYD' (Errcode: 24) Error No: 23 SELECT p.product_id,IF(p.synchro_id<>'',
(select sum(IF(po.skald_name<>'PODZAKAZ',if(po.quantity>0,po.quantity+if(DATEDIFF(now(),p.date_added)<30,100000,1000),0),1)) as c from oc_product_ostatki po Where po.product_id=p.product_id),
if(p.quantity>0,p.quantity+if(DATEDIFF(now(),p.date_added)<30,100000,10000) ,0)
) as quantitytst, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_v ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' and (`show_on_category`=0 or `show_on_category` is NULL) AND p2c.category_id = '289' GROUP BY p.product_id ORDER BY quantitytst desc,p.sort_order ASC, LCASE(pd.name) ASC in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 365Warning: Invalid argument supplied for foreach() in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 365Notice: Error: Out of resources when opening file './bigtoysv2/oc_product_special_v.frm' (Errcode: 24) Error No: 23 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_v ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/bigtoys.com.ua/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/bigtoys.com.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 149Спортивне харчування- купити в Україні з доставкою | інтернет магазин Big Toys