Query Debug Report

Time taken: 5.19752502441E-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

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.