SELECT cc.*
FROM cc
INNER JOIN cc_link ON cc_link.cc_id=cc.id
INNER JOIN cc_last_updated ON cc_last_updated.id=cc.id
GROUP BY cc.id
ORDER BY cc_last_updated.last_updated DESC, cc.last_update DESC
LIMIT 0, 50
; : SELECT cc.*
FROM cc
INNER JOIN cc_link ON cc_link.cc_id=cc.id
INNER JOIN cc_last_updated ON cc_last_updated.id=cc.id
GROUP BY cc.id
ORDER BY cc_last_updated.last_updated DESC, cc.last_update DESC
LIMIT 0, 50
; : Disk full (/tmp/#sql-temptable-422-341f3c7-2340a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")