SELECT p.*, p.series_id AS `SeriesId`, DATE_FORMAT( p.preorder_end_date, '%d.%m.%Y' ) AS preorder_end_date_DD_MM_YYYY, a.title AS author_title, a.born_date, a.born_town, a.biography, a.photo, i.file_path, pu.title AS publisher_title, ps.Id AS series_id, ps.Name AS series_name, m.show_issues FROM libro_products AS p LEFT JOIN libro_products_1_pic_en AS i ON p.id=i.item_id AND i.default_item='1' LEFT JOIN libro_authors AS a ON a.id=p.author_id LEFT JOIN libro_publishers AS pu ON pu.id=p.publisher_id LEFT JOIN libro_series AS ps ON p.series_id = ps.Id LEFT JOIN libro_products_magazines AS m ON p.magazine_id = m.id WHERE p.id='43512' AND p.visible='1' AND p.date_visible <= '1511608128' Table 'libro.libro_products_1_pic_en' doesn't exist