|
|
1054 - Unknown column 'p.manufacturers_id' in 'on clause'
select d.categories_name, p.products_movie_quebec_rating, p.products_type, p.products_nodiscs, p.discs_disp, p.products_id, p.products_companions, pd.products_menu, pd.products_name,
p.products_game_rating, p.products_movie_runtime, p.products_province, p.products_movie_year, p.products_game_publisher, p.products_game_developer, p.products_game_players,
p.products_game_release_date, p.products_postal, pd.products_description, pd.products_usage, p.products_model, p.products_size, p.products_quantity,
p.products_image, p.products_video, p.products_studio, pd.products_keyword_visible, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added,
p.products_date_available, p.manufacturers_id, p.products_hold, r.manufacturers_name, r.manufacturers_image, p.directors_id,di.directors_fname, directors_lname,
di.directors_id, concat(di.directors_fname,' ',di.directors_lname) as director,
p.products_movie_screenformats, p.products_movie_subtitles, p.products_movie_language, p.products_movie_release_date, p.products_movie_otherfeatures
from products p, categories_description d, products_description pd
left join manufacturers r on p.manufacturers_id=r.manufacturers_id
left join directors di on p.directors_id=di.directors_id
where p.products_id = '1020'
and pd.products_id = '1020'
and pd.language_id = '1'
[TEP STOP]
|