Skip to content

Instantly share code, notes, and snippets.

@ringmaster
Created May 1, 2012 19:54
Show Gist options
  • Save ringmaster/2570909 to your computer and use it in GitHub Desktop.
Save ringmaster/2570909 to your computer and use it in GitHub Desktop.
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