Created
May 1, 2012 19:54
-
-
Save ringmaster/2570909 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
array ( | |
0 => 'SELECT | |
{posts}.id AS id, | |
{posts}.slug AS slug, | |
{posts}.title AS title, | |
{posts}.guid AS guid, | |
{posts}.content AS content, | |
{posts}.cached_content AS cached_content, | |
{posts}.user_id AS user_id, | |
{posts}.status AS status, | |
{posts}.pubdate AS pubdate, | |
{posts}.updated AS updated, | |
{posts}.modified AS modified, | |
{posts}.content_type AS content_type | |
FROM | |
{posts} | |
JOIN {object_terms} ON {posts}.id = {object_terms}.object_id | |
JOIN {terms} ON {object_terms}.term_id = {terms}.id | |
JOIN {vocabularies} ON {terms}.vocabulary_id = {vocabularies}.id | |
WHERE | |
( | |
{vocabularies}.name = :param_1 | |
AND | |
{terms}.id = :param_2 | |
AND | |
{object_terms}.object_type_id = :param_3 | |
AND | |
{vocabularies}.name = :param_4 | |
AND | |
{terms}.id = :param_5 | |
AND | |
{object_terms}.object_type_id = :param_6 | |
) | |
ORDER BY pubdate DESC', | |
1 => | |
array ( | |
'param_1' => 'fizz', | |
'param_2' => 348, | |
'param_3' => 1, | |
'param_4' => 'buzz', | |
'param_5' => 349, | |
'param_6' => 1, | |
), | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment