398 - /home/ec2-user/retrogamingstores.com/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php
#0 /home/ec2-user/retrogamingstores.com/public_html/vqmod/vqcache/vq2-catalog_controller_product_search.php(315): ModelCatalogProduct->getProducts(Array)
#1 /home/ec2-user/retrogamingstores.com/public_html/vqmod/vqcache/vq2-system_engine_front.php(42): ControllerProductSearch->index()
#2 /home/ec2-user/retrogamingstores.com/public_html/vqmod/vqcache/vq2-system_engine_front.php(29): Front->execute(Object(Action))
#3 /home/ec2-user/retrogamingstores.com/public_html/index.php(304): Front->dispatch(Object(Action), Object(Action))
#4 {main}
SELECT p.product_id,pd.name,
((pd.tag REGEXP '([[:>:]]|^)Pokemon collectibles([[:>:]]|$)') * 20),  (pd.tag LIKE '%pokemon%'),  (pd.name LIKE '%pokemon%'),  (pd.tag LIKE '%collectibles%'),  (pd.name LIKE '%collectibles%'), 
(((pd.tag REGEXP '([[:>:]]|^)Pokemon collectibles([[:>:]]|$)') * 20) + 
 (pd.tag LIKE '%pokemon%') + 
 (pd.name LIKE '%pokemon%') + 
 (pd.tag LIKE '%collectibles%') + 
 (pd.name LIKE '%collectibles%')) as weight, (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 JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = '0') WHERE p.status = '1' AND p.date_available <= NOW()  AND ( ( (pd.tag LIKE '%pokemon%') OR  (pd.name LIKE '%pokemon%') OR  (pd.tag LIKE '%collectibles%') OR  (pd.name LIKE '%collectibles%'))) GROUP BY p.product_id
 ORDER BY ((p.price > 0)*100 + (p.quantity > 0 OR p.stock_status_id = 8)*100 + (p.image != '')*100) + (((pd.tag REGEXP '([[:>:]]|^)Pokemon collectibles([[:>:]]|$)') * 20) + 
 (pd.tag LIKE '%pokemon%') + 
 (pd.name LIKE '%pokemon%') + 
 (pd.tag LIKE '%collectibles%') + 
 (pd.name LIKE '%collectibles%')) DESC, LCASE(pd.name) DESC LIMIT 0,15