string(323) "
SELECT p.id as id
FROM #__ksenmart_products AS p
LEFT JOIN #__ksenmart_products_categories as pc on pc.product_id = p.id
LEFT JOIN #__ksenmart_categories as c on pc.category_id = c.id
WHERE p.published=1 AND (p.parent_id=0) AND (c.id IN(1) OR c.parent_id IN(1))
GROUP BY p.id
ORDER BY p.in_stock desc,c.ordering ASC, pc.id"