Die Abfrage wurde abgebrochen, kontaktieren Sie den Administrator...

SELECT p.*, pd.products_name, pd.products_short_description, pd.products_description , sl.bezeichnung as slogan FROM products p LEFT OUTER JOIN products_description pd ON (p.products_id = pd.products_id AND pd.language_id = '1') LEFT OUTER JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) LEFT OUTER JOIN categories c ON (p2c.categories_id = c.categories_id) LEFT OUTER JOIN jacha_slogenartikelvw sl ON (sl.artikelnr1 = p.products_model OR sl.artikelnr2 = p.products_model OR sl.artikelnr3 = p.products_model OR sl.artikelnr4 = p.products_model OR sl.artikelnr5 = p.products_model ) WHERE c.categories_status='1' AND p.products_status = '1' and p. products_id in () order by sl.slogannr