• RSS feed
• Twitter
• Facebook
• Follow Entertainment

Entertainment

 SELECT   slnm_posts.* FROM slnm_posts  INNER JOIN slnm_term_relationships ON (slnm_posts.ID = slnm_term_relationships.object_id) INNER JOIN
slnm_postmeta ON (slnm_posts.ID = slnm_postmeta.post_id) WHERE [XXX]=[XXX]  AND ( slnm_term_relationships.term_taxonomy_id IN ([XXX]) ) AND
(slnm_posts.post_author = [XXX]) AND slnm_posts.post_type = [XXX] AND (slnm_posts.post_status = [XXX]) AND ( (slnm_postmeta.meta_key = [XXX] AND
CAST(slnm_postmeta.meta_value AS CHAR) = [XXX]) ) GROUP BY slnm_posts.ID ORDER BY slnm_posts.post_date DESC LIMIT [XXX], [XXX] /* 
entertainment.dev[XXX].salon.com/ */;

 SELECT SQL_CALC_FOUND_ROWS  slnm_posts.* FROM slnm_posts  INNER JOIN slnm_term_relationships ON (slnm_posts.ID = slnm_term_relationships.object_id)
WHERE [XXX]=[XXX]  AND ( slnm_term_relationships.term_taxonomy_id IN ([XXX]) ) AND slnm_posts.post_type = [XXX] AND (slnm_posts.post_status = [XXX])
GROUP BY slnm_posts.ID ORDER BY slnm_posts.post_date DESC LIMIT [XXX], [XXX] /*  entertainment.dev[XXX].salon.com/ */; SELECT FOUND_ROWS();

 SELECT   slnm_posts.* FROM slnm_posts  INNER JOIN slnm_postmeta ON (slnm_posts.ID = slnm_postmeta.post_id) WHERE [XXX]=[XXX]  AND
(slnm_posts.post_author = [XXX]) AND slnm_posts.post_type = [XXX] AND (slnm_posts.post_status = [XXX]) AND ( (slnm_postmeta.meta_key = [XXX] AND
CAST(slnm_postmeta.meta_value AS CHAR) = [XXX]) ) GROUP BY slnm_posts.ID ORDER BY slnm_posts.post_date DESC LIMIT [XXX], [XXX] /* 
entertainment.dev[XXX].salon.com/ */;

                SELECT wposts.*, wpostmeta_coverline.meta_value as post_coverline, wpostmeta_priority.meta_value as post_priority 
                    FROM slnm_posts wposts
                        LEFT JOIN slnm_postmeta wpostmeta_priority ON wposts.ID = wpostmeta_priority.post_id 
                        LEFT JOIN slnm_postmeta wpostmeta_shelf ON wposts.ID = wpostmeta_shelf.post_id 
                        LEFT JOIN slnm_postmeta wpostmeta_pics ON wposts.ID = wpostmeta_pics.post_id  
                        LEFT JOIN slnm_term_relationships ON (wposts.ID = slnm_term_relationships.object_id)
                        LEFT JOIN slnm_term_taxonomy ON (slnm_term_relationships.term_taxonomy_id = slnm_term_taxonomy.term_taxonomy_id)
                        LEFT JOIN slnm_terms ON (slnm_term_taxonomy.term_id = slnm_terms.term_id)
                        LEFT JOIN slnm_postmeta wpostmeta_coverline on wposts.ID = wpostmeta_coverline.post_id
                        WHERE wpostmeta_priority.meta_key = [XXX] AND wpostmeta_pics.meta_key = [XXX]
                            AND wpostmeta_coverline.meta_key = [XXX]
                            AND wposts.post_type = [XXX]
                            AND wposts.post_status = [XXX]
                            AND TRIM(wposts.post_excerpt) != [XXX] 
                            AND wposts.post_excerpt IS NOT NULL
                            AND wpostmeta_pics.meta_value IS NOT NULL
                            AND wpostmeta_priority.meta_value in ( [XXX], [XXX], [XXX], [XXX], [XXX])  
                            AND wpostmeta_shelf.meta_key = [XXX]
                            AND wposts.post_date_gmt > DATE_SUB(NOW(), INTERVAL wpostmeta_shelf.meta_value SECOND)
                            AND slnm_term_taxonomy.taxonomy = [XXX]
                            AND slnm_terms.slug = [XXX] 
                        ORDER BY wpostmeta_priority.meta_value ASC, wposts.post_date DESC
                        LIMIT [XXX] /*  entertainment.dev[XXX].salon.com/ */;

                SELECT wposts.*, wpostmeta_coverline.meta_value as post_coverline, wpostmeta_priority.meta_value as post_priority 
                    FROM slnm_posts wposts
                        LEFT JOIN slnm_postmeta wpostmeta_priority ON wposts.ID = wpostmeta_priority.post_id 
                        LEFT JOIN slnm_postmeta wpostmeta_pics ON wposts.ID = wpostmeta_pics.post_id  
                        LEFT JOIN slnm_postmeta wpostmeta_coverline on wposts.ID = wpostmeta_coverline.post_id
                        LEFT JOIN slnm_term_relationships ON (wposts.ID = slnm_term_relationships.object_id)
                        LEFT JOIN slnm_term_taxonomy ON (slnm_term_relationships.term_taxonomy_id = slnm_term_taxonomy.term_taxonomy_id)
                        LEFT JOIN slnm_terms ON (slnm_term_taxonomy.term_id = slnm_terms.term_id)
                        WHERE wpostmeta_priority.meta_key = [XXX]
                            AND wposts.ID NOT IN ([XXX]) 
                            AND wpostmeta_pics.meta_key = [XXX]
                            AND wpostmeta_coverline.meta_key = [XXX]
                            AND wposts.post_type = [XXX]
                            AND wposts.post_status = [XXX]
                            AND TRIM(wposts.post_excerpt) != [XXX] 
                            AND wposts.post_excerpt IS NOT NULL
                            AND wpostmeta_pics.meta_value IS NOT NULL
                            AND wpostmeta_priority.meta_value >= [XXX] 
                            AND wpostmeta_priority.meta_value <= [XXX] 
                            AND slnm_term_taxonomy.taxonomy = [XXX]
                            AND slnm_terms.slug = [XXX] 
                        ORDER BY wposts.post_date DESC
                    LIMIT [XXX] /*  entertainment.dev[XXX].salon.com/ */;

SELECT * FROM slnm_posts WHERE ID = [XXX] LIMIT [XXX] /*  entertainment.dev[XXX].salon.com/ */;

SELECT t.*, tt.* FROM slnm_terms AS t INNER JOIN slnm_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN slnm_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ([XXX]) AND tr.object_id IN ([XXX]) ORDER BY tr.term_order ASC /* 
entertainment.dev[XXX].salon.com/ */;

SELECT t.*, tt.* FROM slnm_terms AS t INNER JOIN slnm_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN slnm_term_relationships AS tr ON
tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ([XXX]) AND tr.object_id IN ([XXX]) ORDER BY t.name ASC /* 
entertainment.dev[XXX].salon.com/ */;

					SELECT term_taxonomy_id
					FROM slnm_term_taxonomy
					WHERE taxonomy = [XXX]
					AND term_id IN ([XXX]) /*  entertainment.dev[XXX].salon.com/ */;

SELECT t.*, tt.* FROM slnm_terms AS t INNER JOIN slnm_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = [XXX] AND t.slug = [XXX] LIMIT
[XXX] /*  entertainment.dev[XXX].salon.com/ */;

 SELECT   slnm_posts.* FROM slnm_posts  WHERE [XXX]=[XXX]  AND slnm_posts.ID IN
([XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX])
AND slnm_posts.post_type = [XXX] AND (slnm_posts.post_status = [XXX])  ORDER BY menu_order ASC /*  entertainment.dev[XXX].salon.com/ */;

SELECT `post_parent` FROM slnm_posts WHERE ID = [XXX] LIMIT [XXX] /*  entertainment.dev[XXX].salon.com/ */;

SELECT tr.object_id FROM slnm_term_relationships AS tr INNER JOIN slnm_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE
tt.taxonomy IN ([XXX]) AND tt.term_id IN ([XXX]) ORDER BY tr.object_id ASC /*  entertainment.dev[XXX].salon.com/ */;

 SELECT   slnm_posts.* FROM slnm_posts  WHERE [XXX]=[XXX]  AND slnm_posts.ID IN ([XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX]) AND
slnm_posts.post_type = [XXX] AND (slnm_posts.post_status = [XXX])  ORDER BY slnm_posts.post_date DESC /*  entertainment.dev[XXX].salon.com/ */;

 SELECT   slnm_posts.* FROM slnm_posts  WHERE [XXX]=[XXX]  AND slnm_posts.ID IN
([XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX],[XXX]) AND slnm_posts.post_type = [XXX]
AND (slnm_posts.post_status = [XXX])  ORDER BY menu_order ASC /*  entertainment.dev[XXX].salon.com/ */;

 SELECT   slnm_posts.* FROM slnm_posts  INNER JOIN slnm_term_relationships ON (slnm_posts.ID = slnm_term_relationships.object_id) WHERE [XXX]=[XXX] 
AND ( slnm_term_relationships.term_taxonomy_id IN ([XXX]) ) AND slnm_posts.post_type = [XXX] AND (slnm_posts.post_status = [XXX]) GROUP BY
slnm_posts.ID ORDER BY slnm_posts.post_date DESC LIMIT [XXX], [XXX] /*  entertainment.dev[XXX].salon.com/ */;

SELECT t.*, tt.* FROM slnm_terms AS t INNER JOIN slnm_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = [XXX] AND t.term_id = [XXX]
LIMIT [XXX] /*  entertainment.dev[XXX].salon.com/ */;

 SELECT   slnm_posts.* FROM slnm_posts  WHERE [XXX]=[XXX]  AND slnm_posts.ID IN ([XXX],[XXX]) AND slnm_posts.post_type = [XXX] AND
(slnm_posts.post_status = [XXX])  ORDER BY menu_order ASC /*  entertainment.dev[XXX].salon.com/ */;

					SELECT slnm_term_taxonomy.term_id
					FROM slnm_term_taxonomy
					INNER JOIN slnm_terms USING (term_id)
					WHERE taxonomy = [XXX]
					AND slnm_terms.slug IN ([XXX]) /*  entertainment.dev[XXX].salon.com/ */;

SELECT add_terms,exclude_terms FROM adserver_terms WHERE request_uri=[XXX] /*  entertainment.dev[XXX].salon.com/ */;