permaland.cz

Úvodní strana● Přihlásit se  Doručování  Obchodní podmínky  Ochrana dat  Kontakt● ReinSaat● BIO CERTIFIKÁT  AKCE

 

Hledat

SELECT *, COUNT(prd_name_cs) as countNames FROM ( SELECT prd_id, prd_category_main, prd_name_cs, prd_webname_cs, prd_name_lat, prd_specification_cs, prd_short_description_cs, prd_description_cs, prd_text_cs, 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 `shop_products` INNER JOIN `category` ON cat_id = prd_category_main AND cat_active = 2 AND cat_active_cs = 1 WHERE prd_active = 1 AND (prd_category_main = ) ORDER BY prd_name_cs ASC, prd_price_online_czk ASC LIMIT 18446744073709551615 ) AS sub GROUP BY prd_name_cs ORDER BY prd_new DESC, prd_name_cs ASC = You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY prd_name_cs ASC, prd_price_online_czk ASC LIMIT 184467440737...' at line 7
SELECT *, COUNT(prd_name_cs) as countNames FROM ( SELECT prd_id, prd_category_main, prd_name_cs, prd_webname_cs, prd_name_lat, prd_specification_cs, prd_short_description_cs, prd_description_cs, prd_text_cs, 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 `shop_products` INNER JOIN `category` ON cat_id = prd_category_main AND cat_active = 2 AND cat_active_cs = 1 WHERE prd_active = 1 AND (prd_category_main = ) ORDER BY prd_name_cs ASC, prd_price_online_czk ASC LIMIT 18446744073709551615 ) AS sub GROUP BY prd_name_cs ORDER BY prd_new DESC, prd_name_cs ASC LIMIT 0,10 = You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY prd_name_cs ASC, prd_price_online_czk ASC LIMIT 184467440737...' at line 7