All pastes #411306 Raw Edit

Something

public sql v1 · immutable
#411306 ·published 2007-03-26 23:00 UTC
rendered paste body
ELECT `s`.`width`, `s`.`uri`, `s`.`height`, `i`.`price`, `i`.`id_tm`, `ti`.`label_en` AS `type` FROM `tm_index` AS `i` LEFT JOIN `tm_details` AS `d` ON `d`.`id_tm` = `i`.`id_tm` LEFT OUTER JOIN `tm_screenshots` AS `s` ON `s`.`id_tm` = `i`.`id_tm` LEFT JOIN `tm_types_index` AS `ti` ON `ti`.`id_type` = `i`.`id_type` WHERE (`i`.`id_tm`=12602 OR `i`.`id_tm`=11831 OR `i`.`id_tm`=11680) AND (`s`.`id_screenshot`=70282 OR `s`.`id_screenshot`=63330 OR `s`.`id_screenshot`=61771 AND `s`.`id_screenshot` NOT LIKE "%.html") GROUP BY `s`.`id_screenshot` ORDER BY `i`.`inserted_date` DESC