SELECT products.*, 
					catalog.name AS cat_name,
					manufacturer_name
				
				FROM products
				INNER JOIN products_categories ON products_categories.pid = products.pid AND products_categories.cid='5'
				INNER JOIN catalog ON products.cid=catalog.cid
				LEFT JOIN manufacturers ON products.manufacturer_id = manufacturers.manufacturer_id AND manufacturers.is_visible='1'
				WHERE products.is_visible='Yes' 
				GROUP BY products.pid
				ORDER BY products.priority DESC, products.title
				LIMIT 0, 20