Welcome, guest! Login / Register - Why register?
[email protected] webmail now available. Want one? Go here.
Windows getting boring or just want to try something Open Source for your next Desktop Environment?! Go Zorin OS.

Paste

Pasted by registered user electronico_nc ( 9 years ago )
SELECT YEAR(`mt_dateCreated`) as YYYY, MONTH(`mt_dateCreated`) as MM ,DAY(`mt_dateCreated`) as DD, `mt_trackingStatus`, count(*)
FROM `smg_mt`
WHERE `mt_trackingStatus` = "20029"
AND `_id` >= (SELECT `_id` FROM `smg_mt` WHERE `mt_trackingStatus`="20029" ORDER BY `mt_dateCreated` ASC LIMIT 1)
GROUP BY YYYY ASC, MM ASC, DD ASC
LIMIT 100

 

Revise this Paste

Your Name: Code Language: