SELECT t.*
				
			FROM (
				SELECT ps.id_prod, ps.price_dph, ps.name, p.sell_quantity, p.available, pc.pos, p.view, 
					UNCOMPRESS(ps.cache) AS cache
					, p.id_manufacturer, p.id_condition
				FROM shop_prod_search ps
					JOIN shop_prod p ON p.id = ps.id_prod
					JOIN shop_prod_cat pc ON pc.id_prod = ps.id_prod
					LEFT JOIN shop_prod_available avai ON avai.id = p.available
					
				WHERE pc.id_cat = '5' AND  ps.lang = 'cz' AND ps.price_dph >= 0 AND ps.frontend = 1 AND IF(avai.id IS NULL, true, avai.view_prod = 1)
				GROUP BY ps.id_prod
				) AS t
				
			
			
			ORDER BY t.view DESC