Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_description.MYD' (Errcode: 24) Error No: 23 SELECT COUNT(DISTINCT p.product_id) AS total 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) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pd.tag LIKE '%hybrid books%') in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/system/modification/catalog/model/catalog/product.php on line 876Notice: Error: Out of resources when opening file './ebcbgc_live/oc_review.MYD' (Errcode: 24) Error No: 23 SELECT p.product_id, (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 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 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) WHERE pd.language_id = '2' AND p.status = '1' AND p.sort_order > '-1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pd.tag LIKE '%Hybrid Books%') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12 in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/system/modification/catalog/model/catalog/product.php on line 232Warning: Invalid argument supplied for foreach() in /var/www/html/ebc/system/modification/catalog/model/catalog/product.php on line 232Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_to_store.MYD' (Errcode: 24) Error No: 23
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`ad`.`mf_tooltip` AS `tooltip`,
`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` = 2
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` = 2
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` = 2
INNER JOIN
`oc_product_description` AS `pd`
ON
`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2
WHERE
`p`.`status` = '1' AND `p`.`date_available` <= NOW() AND (LCASE(`pd`.`tag`) LIKE '%hybrid books%')
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_to_store.MYD' (Errcode: 24) Error No: 23
SELECT
`o`.`option_id`,
`ov`.`option_value_id`,
`od`.`name` AS `gname`,
`od`.`mf_tooltip` AS `tooltip`,
`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` = 2
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` = 2
INNER JOIN
`oc_product_description` AS `pd`
ON
`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2
WHERE
`p`.`status` = '1' AND `p`.`date_available` <= NOW() AND (LCASE(`pd`.`tag`) LIKE '%hybrid books%') 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/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/catalog/model/module/mega_filter.php on line 1211Warning: Invalid argument supplied for foreach() in /var/www/html/ebc/catalog/model/module/mega_filter.php on line 1231Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_to_store.MYD' (Errcode: 24) Error No: 23
SELECT
`fgd`.`name` AS `gname`,
`fgd`.`mf_tooltip` AS `tooltip`,
`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` = 2
INNER JOIN
`oc_filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`oc_product_description` AS `pd`
ON
`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2
WHERE
`p`.`status` = '1' AND `p`.`date_available` <= NOW() AND (LCASE(`pd`.`tag`) LIKE '%hybrid books%')
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/catalog/model/module/mega_filter.php on line 991Warning: Invalid argument supplied for foreach() in /var/www/html/ebc/catalog/model/module/mega_filter.php on line 1011Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_special.MYD' (Errcode: 24) Error No: 23
SELECT
ROUND( 100 - ( ( (
IFNULL( (
SELECT
`price`
FROM
`oc_product_special` 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` ) )
) / `p`.`price` ) * 100 ) ) AS `discount`
FROM
`oc_product` AS `p`
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`oc_product_description` AS `pd`
ON
`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`price` > 0 AND (LCASE(`pd`.`tag`) LIKE '%hybrid books%')
GROUP BY `p`.`product_id`
HAVING
`discount` > 0
ORDER BY
`discount` ASC
in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/catalog/model/module/mega_filter.php on line 900Warning: Invalid argument supplied for foreach() in /var/www/html/ebc/catalog/model/module/mega_filter.php on line 900Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_discount.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` 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` = 2
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
WHERE
`p`.`status` = '1' AND `p`.`date_available` <= NOW() AND (LCASE(`pd`.`tag`) LIKE '%hybrid books%')
) AS `tmp` ) AS `tmp` in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/system/library/mfilter_core.php on line 1Notice: Error: Out of resources when opening file './ebcbgc_live/oc_product_discount.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` 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` = 2
INNER JOIN
`oc_product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
WHERE
`p`.`status` = '1' AND `p`.`date_available` <= NOW() AND (LCASE(`pd`.`tag`) LIKE '%hybrid books%')
) AS `tmp` ) AS `tmp` in /var/www/html/ebc/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/html/ebc/system/library/mfilter_core.php on line 1
Търсене - Tag - Hybrid Books
