[eluser]Unknown[/eluser]
Hello people,
I must have done something terribly wrong here in order to take such results.
Can you see anything I can't see in the following result?
Code:
488.7046 SELECT `items`.*, `media`.`id` as img_id, `media`.`title` as img_title, `media`.`file_name` as img_file_name, `media`.`created` as img_created, `title`.`title_alt`, `title`.`title_gr`, `title`.`year`, `title`.`dv_year`, `title`.`title_type`, `title`.`runtime`, `title`.`country`, `title`.`link`, `title`.`video`, `title`.`rating`, `title`.`age_rating`
FROM (`items`)
LEFT OUTER JOIN `media` ON `media`.`item_id` = `items`.`id`
LEFT OUTER JOIN `item_title` title ON `title`.`item_id` = `items`.`id`
WHERE `items`.`type` = 'title'
ORDER BY `items`.`created` desc
LIMIT 20
