Skip to content

Instantly share code, notes, and snippets.

@silentworks
Forked from anonymous/gist:976600
Created May 17, 2011 14:44
Show Gist options
  • Save silentworks/976607 to your computer and use it in GitHub Desktop.
Save silentworks/976607 to your computer and use it in GitHub Desktop.
$sql = "SELECT *
FROM `content`
WHERE (content_finish >= " . $now . " OR content_finish IS NULL)
AND `content_status` = 'published'
AND `content_parent` IN (" . $content_ids . ")
ORDER BY `content_updated` desc";
$this->db->query($sql);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment