Hallo franky_n,
danke erst einmal für deine schnelle Hilfe! Das mit dem Like war mir auch schon aufgefallen und ich hatte es schon geändert.
Du hast recht, das ich dort die Suche auch noch erweitert hatte.
Nach der Änderung von dir sieht die SQL nun wie folgt aus:
SELECT DISTINCT p.products_id, p.products_ean, p.products_manufacturers_model, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_name, pd.products_short_description, pd.products_description FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) WHERE p.products_status = '1' AND s.status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%hp%') OR p.products_ean LIKE ('%hp%') OR p.products_manufacturers_model LIKE ('%hp%') OR pd.products_description LIKE ('%hp%') OR pd.products_short_description LIKE ('%hp%') OR pd.products_name LIKE ('%hp%') OR p.products_model LIKE ('%hp%') OR (pov.products_options_values_name LIKE ('%hp%') AND pov.language_id = '2') ) OR ( pd.products_keywords LIKE ('%98a%') OR p.products_ean LIKE ('%98a%') OR p.products_manufacturers_model LIKE ('%98a%') OR pd.products_description LIKE ('%98a%') OR pd.products_short_description LIKE ('%98a%') OR pd.products_name LIKE ('%98a%') OR p.products_model LIKE ('%98a%') OR (pov.products_options_values_name LIKE ('%98a%') AND pov.language_id = '2') ) ) GROUP BY p.products_id ORDER BY p.products_id
Allerdings findet er so nun garnichts mehr! D.H. es kommt immer "Die Suche ergab keine genauen Treffer."
Gruss