Query Debug Report

Time taken: 5.69820404053E-5

Error Returned:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND  AND node.shop_id = 1 AND parent.shop_id=1 GROUP BY node.id HAVING depth < 2' at line 1

Query Used:

SELECT node.*,  node.id, (COUNT(parent.id) - 1) AS depth 
FROM cat AS node, cat AS parent 
WHERE node.lft BETWEEN parent.lft AND parent.rgt AND parent.lft BETWEEN  AND  AND node.shop_id = 1 AND parent.shop_id=1 
GROUP BY node.id HAVING depth < 2 
ORDER BY node.lft

Query Debug Report

Time taken: 9.60826873779E-5

Error Returned:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cat.lft <= GROUP BY products.id HAVING (p_zeroqoh=1 OR type='ENQUIRY')' at line 1

Query Used:

SELECT products.type, products.profitability, products.name, products.id, products.brand_id, MAX(p_zeroqoh) as p_zeroqoh, GROUP_CONCAT(pricing.p_shippingclass) as shipping_classes, short_desc, products.tags, products.shop_id as supplier_id, MIN(pricing.p_price_s) as price_s, MIN(pricing.p_price) as price, MAX(pricing.p_price) as m_price, MAX(pricing.p_price_s) as m_price_s, (
SELECT count(*) 
FROM pricing as pr2 
WHERE pr2.p_p_id=products.id) as skuqty, (
SELECT AVG(rating) 
FROM product_ratings 
WHERE product_ratings.product_id=products.id) as rating 
FROM products 
LEFT JOIN product_tags_map ON product_tags_map.product_id=products.id 
LEFT JOIN product_tags ON product_tags_map.tag_id=product_tags.id 
LEFT JOIN pricing ON p_p_id=products.id 
LEFT JOIN category_map ON category_map.product_id=products.id 
LEFT JOIN cat ON category_map.category_id=cat.id  
WHERE deleted=0 AND cat.shop_id=1 AND cat.lft >= AND cat.lft <= 
GROUP BY products.id HAVING (p_zeroqoh=1 OR type='ENQUIRY')

Products | Mega Health

Information

Security

We Accept:

Products

View

Currency

No Results

Sorry, I could not find any results for . Remove it to see more results.

Help

Proud Sponsor Of

This information is general in nature and should not be used for diagnosing or treating a health problem or disease.
This information is not intended to replace the advice of qualified health care practitioners.

This information is being continually updated and is subject to change without notice. No warranty or guarantee of a cure is expressed or
implied with any information included herein, nor does Cynergy Health Pty Ltd make any representations regarding the use or the results obtained
with the information. In no event shall Cynergy Health Pty Ltd, its employees or associates be liable to any person or individual for any loss or
damage whatsoever which may arise from the use of this information. The information contained herein should be used at your own discretion.