Ich habe 2 Artikel mit den Artikelnummern PD-02022 und PD-07300
Wenn ich in meiner stark modifizierten erweiterten Suche nach Artikel PD-07300 Suche:
SELECT DISTINCT p.products_manufacturers_model, p.products_id, p.products_ean, p.products_quantity, p.products_shippingtime, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id, p.products_fsk18, p.products_vpe, GROUP_CONCAT(DISTINCT ' ', a.autors_title, ' ', a.autors_firstname, ' ', a.autors_noble_title,' ', a.autors_lastname, ' ' SEPARATOR '|' ) AS autor, GROUP_CONCAT(DISTINCT a.autors_id) AS autor_id, p.cover, p.pages, p.products_subtitle, p.products_publishing_info, p.products_ebook_isbn, p.products_ebook_url, p.products_vpe_status, p.products_vpe_value, p.products_class_id, 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 JOIN autors_to_products ap ON p.products_id=ap.products_id LEFT JOIN autors a ON ap.autors_id=a.autors_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) AND s.status = '1' WHERE p.products_status = 1 AND pd.language_id = '2' AND p.group_permission_0=1 AND ( ( p.products_model LIKE '%PD-07300%' ) ) AND (p.products_class_id = 1 OR p.products_class_id = 2 OR p.products_class_id = 3 OR p.products_class_id = 4 OR p.products_class_id = 5 OR p.products_class_id = 6 ) GROUP BY p.products_id ORDER BY p.products_id ASC
Bekomme ich keinen Treffer.
Wenn ich irgendeine andere Artikelnummer suche wie die PD-02022
SELECT DISTINCT p.products_manufacturers_model, p.products_id, p.products_ean, p.products_quantity, p.products_shippingtime, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id, p.products_fsk18, p.products_vpe, GROUP_CONCAT(DISTINCT ' ', a.autors_title, ' ', a.autors_firstname, ' ', a.autors_noble_title,' ', a.autors_lastname, ' ' SEPARATOR '|' ) AS autor, GROUP_CONCAT(DISTINCT a.autors_id) AS autor_id, p.cover, p.pages, p.products_subtitle, p.products_publishing_info, p.products_ebook_isbn, p.products_ebook_url, p.products_vpe_status, p.products_vpe_value, p.products_class_id, 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 JOIN autors_to_products ap ON p.products_id=ap.products_id LEFT JOIN autors a ON ap.autors_id=a.autors_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) AND s.status = '1' WHERE p.products_status = 1 AND pd.language_id = '2' AND p.group_permission_0=1 AND ( ( p.products_model LIKE '%PD-02022%' ) ) AND (p.products_class_id = 1 OR p.products_class_id = 2 OR p.products_class_id = 3 OR p.products_class_id = 4 OR p.products_class_id = 5 OR p.products_class_id = 6 ) GROUP BY p.products_id ORDER BY p.products_id ASC
Bekomme ich wie gewünscht den Artikel?!?
Warum geht das bei dem einen Artikel nicht?!?
Mit
SELECT * FROM products WHERE products_model = 'PD-07300'
finde ich den Artikel aber ...
Hat irgendjemand eine Erklärung?
Linkback: https://www.modified-shop.org/forum/index.php?topic=34653.0