order
SELECT node.created AS node_created, node.nid AS nid
FROM
{node} node
WHERE (( (node.status = '1') AND (node.type IN ('youtube', 'facebook', 'instagram', 'tweet')) AND (node.type IN ('youtube', 'facebook', 'instagram')) ))
ORDER BY node_created DESC
LIMIT 12 OFFSET 0