/bags/bracher-emden/ - menu=bags&path=bracher-emden
SELECT * ,(SELECT Thumb FROM product_image WHERE ProductID = a.ProductID && Status = 'default') as thumb FROM product a WHERE a.SubCategory = (SELECT ID FROM setting_product_sub_category WHERE SubPath = 'bracher-emden' && CatID = '1') ORDER BY Stock ASC LIMIT 0, 16