ลองเขียน
Code: Select all
SELECT max(attach_id) as id,topic_id,real_filename,physical_filename, extension, mimetype FROM (bb_attachments a) WHERE a.topic_id IN ('176', '177') AND extension = 'zip' GROUP BY topic_id ORDER BY id DESC
Moderator: mindphp
Code: Select all
SELECT max(attach_id) as id,topic_id,real_filename,physical_filename, extension, mimetype FROM (bb_attachments a) WHERE a.topic_id IN ('176', '177') AND extension = 'zip' GROUP BY topic_id ORDER BY id DESC
Code: Select all
SELECT * FROM `bb_attachments` WHERE attach_id IN (SELECT MAX(attach_id) FROM `bb_attachments` WHERE `extension`='zip' AND `topic_id` IN (176,177) GROUP BY topic_id)
Users browsing this forum: Bing [Bot] and 5 guests