CategoriesInformationPopular Searches
maxiscan ms509', multiplexer diagnose mercedes- benz, mercedes star diagnosis compact 3, mercedes benz das software, manual tacho universal 2008, mvp key programmer, mitsubishi diagnostic software, Mercedes Benz Star compact3, MAZDA VCM USB CONNECTION, Mercedes Carsoft interface, maxiscan ms509, mb star |
Advanced Search1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_sort_order, pd.products_name limit 0, 10' at line 34
in: [SELECT DISTINCT p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%mercedes%' OR p.products_model LIKE '%mercedes%' OR m.manufacturers_name LIKE '%mercedes%' OR (mtpd.metatags_keywords LIKE '%mercedes%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%mercedes%' AND mtpd.metatags_description !='')) or (pd.products_name LIKE '%ecu%' OR p.products_model LIKE '%ecu%' OR m.manufacturers_name LIKE '%ecu%' OR (mtpd.metatags_keywords LIKE '%ecu%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%ecu%' AND mtpd.metatags_description !='')) or (pd.products_name LIKE '%flash%' OR p.products_model LIKE '%flash%' OR m.manufacturers_name LIKE '%flash%' OR (mtpd.metatags_keywords LIKE '%flash%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%flash%' AND mtpd.metatags_description !='')) )) order by p.products_sort_order, pd.products_name order by p.products_sort_order, pd.products_name limit 0, 10] |
