Kann mir jemand sagen wo ich diese Spalte einfügen muß?
PHP-Code:
Query: SELECT
p.*,
pd.*,
pss.*,
pic.code_isbn,
pic.code_upc,
pic.code_mpn,
pic.code_jan,
pic.google_export_condition,
pic.google_export_availability_id,
pic.brand_name,
pic.identifier_exists,
pic.gender,
pic.age_group,
date_format(pic.expiration_date, '%Y-%m-%d') as expiration_date,
date_format(p.products_date_available, '%Y-%m-%d') as products_date_available
FROM
products p
LEFT JOIN products_description pd ON pd.products_id = p.products_id
LEFT JOIN products_slider_set pss ON pss.products_slider_set_id = p.products_id
LEFT JOIN products_item_codes pic ON pic.products_id = p.products_id
WHERE
p.products_id = '164'
AND pd.language_id = '2'
Error: Unknown column 'pic.identifier_exists' in 'field list' (error 1054)