permaland.cz

Anmelden (Kundenkonto)  Registration (Neukunde)  AGB  Zustellung  Kontakt● ReinSaat● BIO ZERTIFIKAT

 

Suchen

SELECT *, COUNT(prd_name_de) as countNames FROM ( SELECT prd_id, prd_category_main, 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_category` ON cat_id = prd_category_main AND cat_active = 2 AND cat_active_de = 1 WHERE prd_active = 1 AND (prd_category_main = 78) 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_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_category` ON cat_id = prd_category_main AND cat_active = 2 AND cat_active_de = 1 WHERE prd_active = 1 AND (prd_category_main = 78) 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'

bitte warten...