Notice: Error: MySQL server has gone away Error No: 2006 SELECT COUNT(*) search_total FROM ( SELECT
p.product_id eid, 'product' etype, 0 priority,
pd.name,
p.quantity,
p.price,
p.model,
p.sort_order,
p.date_added,
(
SELECT AVG(rating) AS total
FROM ti9jo39em_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id
) AS rating,
(
SELECT price
FROM ti9jo39em_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 ti9jo39em_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
ti9jo39em_product p
LEFT JOIN ti9jo39em_product_description pd ON p.product_id = pd.product_id
LEFT JOIN ti9jo39em_product_to_store p2s ON p.product_id = p2s.product_id
LEFT JOIN ti9jo39em_manufacturer man ON p.manufacturer_id = man.manufacturer_id
WHERE
pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0' AND (p.quantity > 0 OR (p.quantity = 0 AND p.restock_in_future = 1)) GROUP BY p.product_id UNION
SELECT
c.category_id eid, 'category' etype, 1 priority,
cd.name,
NULL quantity,
NULL price,
NULL model,
c.sort_order,
c.date_added,
NULL rating,
NULL discount,
NULL special
FROM
ti9jo39em_category c
LEFT JOIN ti9jo39em_category_description cd ON cd.category_id = c.category_id
WHERE c.status = '1' ) t in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 182Notice: Trying to access array offset on value of type null in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 182Notice: Error: MySQL server has gone away Error No: 2006 SELECT
p.product_id eid, 'product' etype, 0 priority,
pd.name,
p.quantity,
p.price,
p.model,
p.sort_order,
p.date_added,
(
SELECT AVG(rating) AS total
FROM ti9jo39em_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id
) AS rating,
(
SELECT price
FROM ti9jo39em_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 ti9jo39em_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
ti9jo39em_product p
LEFT JOIN ti9jo39em_product_description pd ON p.product_id = pd.product_id
LEFT JOIN ti9jo39em_product_to_store p2s ON p.product_id = p2s.product_id
LEFT JOIN ti9jo39em_manufacturer man ON p.manufacturer_id = man.manufacturer_id
WHERE
pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0' AND (p.quantity > 0 OR (p.quantity = 0 AND p.restock_in_future = 1)) GROUP BY p.product_id UNION
SELECT
c.category_id eid, 'category' etype, 1 priority,
cd.name,
NULL quantity,
NULL price,
NULL model,
c.sort_order,
c.date_added,
NULL rating,
NULL discount,
NULL special
FROM
ti9jo39em_category c
LEFT JOIN ti9jo39em_category_description cd ON cd.category_id = c.category_id
WHERE c.status = '1' ORDER BY priority, sort_order ASC, LCASE(name) ASC LIMIT 15152,16 in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 233Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 233Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'p.sort_order' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'ASC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'pd.name' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'ASC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'pd.name' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'DESC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'p.price' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'ASC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'p.price' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'DESC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'rating' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'DESC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'rating' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'ASC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'p.model' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'ASC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'p.model' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = 'DESC' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '16' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '25' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '50' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '75' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '100' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '{page}' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_url_alias WHERE `query` = '947' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/controller/common/seo_url.php on line 242Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_route WHERE 'product/search' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_module WHERE layout_id = '4' AND position = 'column_left' ORDER BY sort_order in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 16Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/column_left.php on line 48Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_route WHERE 'product/search' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_module WHERE layout_id = '4' AND position = 'column_right' ORDER BY sort_order in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 16Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/column_right.php on line 48Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_route WHERE 'product/search' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_module WHERE layout_id = '4' AND position = 'content_top' ORDER BY sort_order in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 16Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/content_top.php on line 48Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_route WHERE 'product/search' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_layout_module WHERE layout_id = '4' AND position = 'content_bottom' ORDER BY sort_order in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/design/layout.php on line 16Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/content_bottom.php on line 48Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_information i LEFT JOIN ti9jo39em_information_description id ON (i.information_id = id.information_id) LEFT JOIN ti9jo39em_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/catalog/information.php on line 12Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/footer.php on line 31Notice: Error: MySQL server has gone away Error No: 2006 DELETE FROM `ti9jo39em_customer_online` WHERE date_added < '2024-11-14 17:54:50' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Error: MySQL server has gone away Error No: 2006 REPLACE INTO `ti9jo39em_customer_online` SET `ip` = '3.15.4.204', `customer_id` = '0', `url` = 'http://midteks.com/product/search?page=948&tag=Compatible+Toner+Cartridge+Replacement+For+HP+51a+Q7551a+P3005+P3005d+P3005n+P3005dn+P3005x+M3027mfp+M3027xmfp+M3035mfp+M3035xs+Mfp+%28Black%29', `referer` = '', `date_added` = '2024-11-14 18:54:50' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_extension WHERE `type` = 'analytics' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/extension/extension.php on line 6Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/vqmod/vqcache/vq2-catalog_controller_common_header.php on line 15Notice: Error: MySQL server has gone away Error No: 2006 SELECT DISTINCT *, pd.name AS name, p.image, p.ogimage, m.name AS manufacturer, (SELECT price FROM ti9jo39em_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 ti9jo39em_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, (SELECT points FROM ti9jo39em_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM ti9jo39em_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM ti9jo39em_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM ti9jo39em_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM ti9jo39em_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 ti9jo39em_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM ti9jo39em_product p LEFT JOIN ti9jo39em_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN ti9jo39em_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN ti9jo39em_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 254Notice: Error: MySQL server has gone away Error No: 2006 SELECT DISTINCT * FROM ti9jo39em_category c LEFT JOIN ti9jo39em_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN ti9jo39em_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/midteksj/public_html/catalog/model/catalog/category.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT DISTINCT * FROM ti9jo39em_manufacturer m LEFT JOIN ti9jo39em_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1') LEFT JOIN ti9jo39em_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '0' AND m2s.store_id = '0' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/model/catalog/manufacturer.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT DISTINCT *, pd.name AS name, p.image, p.ogimage, m.name AS manufacturer, (SELECT price FROM ti9jo39em_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 ti9jo39em_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, (SELECT points FROM ti9jo39em_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM ti9jo39em_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM ti9jo39em_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM ti9jo39em_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM ti9jo39em_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 ti9jo39em_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM ti9jo39em_product p LEFT JOIN ti9jo39em_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN ti9jo39em_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN ti9jo39em_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'num_rows' of non-object in /home/midteksj/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 254Notice: Error: MySQL server has gone away Error No: 2006 SELECT DISTINCT * FROM ti9jo39em_category c LEFT JOIN ti9jo39em_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN ti9jo39em_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/midteksj/public_html/catalog/model/catalog/category.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT DISTINCT * FROM ti9jo39em_manufacturer m LEFT JOIN ti9jo39em_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1') LEFT JOIN ti9jo39em_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '0' AND m2s.store_id = '0' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'row' of non-object in /home/midteksj/public_html/system/storage/modification/catalog/model/catalog/manufacturer.php on line 6Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_category c LEFT JOIN ti9jo39em_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN ti9jo39em_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/vqmod/vqcache/vq2-catalog_controller_common_header.php on line 280Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_cart WHERE customer_id = '0' AND session_id = '3fb30d6a8be9265890492ae1d1877259' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/system/library/cart.php on line 37Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_extension WHERE `type` = 'total' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/catalog/model/extension/extension.php on line 6Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/cart.php on line 19Warning: array_multisort(): Argument #3 is expected to be an array or a sort flag in /home/midteksj/public_html/catalog/controller/common/cart.php on line 23Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/catalog/controller/common/cart.php on line 25Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_cart WHERE customer_id = '0' AND session_id = '3fb30d6a8be9265890492ae1d1877259' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/system/library/cart.php on line 37Notice: Error: MySQL server has gone away Error No: 2006 SELECT * FROM ti9jo39em_cart WHERE customer_id = '0' AND session_id = '3fb30d6a8be9265890492ae1d1877259' in /home/midteksj/public_html/system/library/db/mysqli.php on line 44Notice: Trying to get property 'rows' of non-object in /home/midteksj/public_html/system/library/cart.php on line 37Warning: Invalid argument supplied for foreach() in /home/midteksj/public_html/system/library/cart.php on line 37Search - Tag - Compatible Toner Cartridge Replacement For HP 51a Q7551a P3005 P3005d P3005n P3005dn P3005x M3027mfp M3027xmfp M3035mfp M3035xs Mfp (Black)