SELECT
wp_term_taxonomy.term_id
FROM
wp_term_taxonomy
INNER JOIN
wp_terms USING ( term_id )
WHERE
taxonomy = 'beer_style' AND
wp_terms.slug IN ( 'ipa', 'pale' )
Slide 15
Slide 15 text
SELECT
term_taxonomy_id
FROM
wp_term_taxonomy
WHERE
taxonomy = 'beer_style' AND
term_id IN ( 2, 3 )
Slide 16
Slide 16 text
SELECT SQL_CALC_FOUND_ROWS
wp_posts.ID
FROM
wp_posts
INNER JOIN
wp_term_relationships ON (
wp_posts.ID = wp_term_relationships.object_id
)
WHERE
1=1 AND
wp_term_relationships.term_taxonomy_id IN ( 5, 7 ) AND
wp_posts.post_type = 'post' AND
…
GROUP BY
wp_posts.ID
ORDER BY
wp_posts.post_date DESC
LIMIT
0, 25
Slide 17
Slide 17 text
SELECT SQL_CALC_FOUND_ROWS
wp_posts.ID
FROM
wp_posts
INNER JOIN
wp_term_relationships ON (
wp_posts.ID = wp_term_relationships.object_id
)
WHERE
1=1 AND
wp_term_relationships.term_taxonomy_id IN ( 5, 7 ) AND
wp_posts.post_type = 'post' AND
…
GROUP BY
wp_posts.ID
ORDER BY
wp_posts.post_date DESC
LIMIT
0, 25
SELECT SQL_CALC_FOUND_ROWS
wp_posts.ID
FROM
wp_posts
INNER JOIN
wp_term_relationships
wp_posts.ID = wp_term_relationships.object_id
)
WHERE
1=1
wp_term_relationships.term_taxonomy_id
wp_posts.post_type =
…
GROUP BY
wp_posts.ID
ORDER BY
wp_posts.post_date
LIMIT
0, 25
Slide 18
Slide 18 text
SELECT
wp_posts.*
FROM
wp_posts
INNER JOIN
wp_postmeta ON (
wp_posts.ID = wp_postmeta.post_id
)
WHERE
wp_postmeta.meta_key = 'hops' AND
wp_postmeta.meta_value IN (
'Amarillo', 'Calypso'
)
Slide 19
Slide 19 text
wp_postmeta.meta_value IN (
'Amarillo', 'Calypso'
)
SELECT
wp_posts.*
FROM
wp_posts
INNER JOIN
wp_postmeta
wp_posts.ID = wp_postmeta.post_id
WHERE
wp_postmeta.meta_key =
wp_postmeta.meta_value