Why am I getting only one result with "craft()->db->createCommand()"? Why am I getting only one result with the following query?

$query = craft()-&gt;db-&gt;createCommand();
$entryRecord = $query-&gt;select('craft_content.field_releaseDate, craft_content.title, craft_entries.id, craft_entries.dateCreated')-&gt;from('content')-&gt;join('entries', 'craft_content.elementId = craft_entries.id')-&gt;where('craft_entries.sectionId=2')-&gt;queryRow();


Also the documentation says that the table prefix isn't required, but this doesn't work most of the time, weird.
Completely untested but it looks like you're just querying a row instead of all.

Update queryRow() to queryAll()