SELECT pages.id,
						pages_text.name as title,
						COUNT(products.id) as cnt
				FROM pages 
				INNER JOIN pages_text ON pages.id = pages_text.page_id  AND pages_text.language_id = 1
				LEFT JOIN products 
				ON pages.id = products.category
				WHERE pages.status != 'deleted'
				AND pages.category = 'category'
				AND pages_text.language_id = 1
				
				GROUP BY pages.id
				ORDER BY pages.order_id
				

Unknown column 'products.id' in 'field list'

file -
line -