Query: | SELECT C.id, C.name, C.queryString, C.images, C.parent, COUNT(CJ.id) AS subCatCount FROM rls_categories C
LEFT JOIN rls_categories CJ ON CJ.parent = C.id AND CJ.status = 1 AND CJ.isDeleted = 0
WHERE C.parent = AND C.isDeleted = 0 AND C.status = 1 AND C.queryString != 'kinamed' GROUP BY C.id ORDER BY C.name ASC LIMIT 0,40; |