Saat

SELECT *, COUNT(prd_name_de) as countNames FROM ( SELECT prd_id, prd_category_main, prd_only_store, prd_name_de, prd_webname_de, prd_name_lat, prd_specification_de, prd_short_description_de, prd_description_de, prd_text_de, prd_vat, prd_price_discount_perc_category, prd_price_discount_perc, prd_price_online_czk, prd_price_retail_czk, prd_new, prd_size, prd_unit_of_measure, prd_stock_status, prd_sold_out FROM `pl_shop_products` INNER JOIN `pl_shop_category` ON sct_id = prd_category_main AND sct_active = 2 AND sct_active_de = 1 WHERE prd_active = 1 AND (prd_category_main = 84) ORDER BY prd_name_de ASC, prd_price_online_czk ASC LIMIT 18446744073709551615 ) AS sub GROUP BY prd_name_de ORDER BY prd_new DESC, prd_name_cs ASC = Unknown column 'prd_name_cs' in 'order clause'
SELECT *, COUNT(prd_name_de) as countNames FROM ( SELECT prd_id, prd_category_main, prd_only_store, prd_name_de, prd_webname_de, prd_name_lat, prd_specification_de, prd_short_description_de, prd_description_de, prd_text_de, prd_vat, prd_price_discount_perc_category, prd_price_discount_perc, prd_price_online_czk, prd_price_retail_czk, prd_new, prd_size, prd_unit_of_measure, prd_stock_status, prd_sold_out FROM `pl_shop_products` INNER JOIN `pl_shop_category` ON sct_id = prd_category_main AND sct_active = 2 AND sct_active_de = 1 WHERE prd_active = 1 AND (prd_category_main = 84) ORDER BY prd_name_de ASC, prd_price_online_czk ASC LIMIT 18446744073709551615 ) AS sub GROUP BY prd_name_de ORDER BY prd_new DESC, prd_name_cs ASC LIMIT 0,10 = Unknown column 'prd_name_cs' in 'order clause'