一応、したらばがなんかの動きをした時用の控え
-----
X-Apparently-To: sayoko_neko@yahoo.co.jp via web2307.mail.yahoo.co.jp; Mon, 07 Feb 2005 16:50:57 +0900
Return-Path: <aile@ax.mond.jp>
Received: from sv97.lolipop.jp (202.222.28.98)
by mta47.mail.bbt.yahoo.co.jp with SMTP; Mon, 07 Feb 2005 16:50:57 +0900
Received: (qmail 29844 invoked from network); 7 Feb 2005 16:50:56 +0900
Received: from unknown (HELO yourziaypnlzkn) (60.36.87.251)
by 0 with SMTP; 7 Feb 2005 16:50:56 +0900
Message-ID: <001801c50ce9$bd67fff0$020ba8c0@yourziaypnlzkn>
From: 橋本 佳美 <aile@ax.mond.jp>
To: <sayoko_neko@yahoo.co.jp>
Cc: <jbbs-support@livedoor.net>
Subject: スレッドの削除を求めます。
Date: Mon, 7 Feb 2005 16:49:12 +0900
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0014_01C50D34.F39D4D00"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
Disposition-Notification-To: 橋本 佳美 <aile@ax.mond.jp>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
邪悪なSQL
$sth = $db->prepare( "SELECT msgID, shopid, title, message, postdate FROM msgQ WHERE msgID in (select substr( MAX(
TO_CHAR(postdate, 'YYYYMMDDhh24miss' )||msgID), 15 ) FROM msgQ group by shopid) order by postdate desc" );