Changes between Version 1 and Version 2 of Ticket #39358, comment 7
- Timestamp:
- 12/22/2016 12:39:01 AM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #39358, comment 7
v1 v2 11 11 For reference, this is what the SQL ends up looking like: 12 12 {{{ 13 SELECT SQL_CALC_FOUND_ROWS wp_ developsrc_posts.id14 FROM wp_ developsrc_posts15 LEFT JOIN wp_ developsrc_postmeta AS sq116 ON ( wp_ developsrc_posts.id = sq1.post_id13 SELECT SQL_CALC_FOUND_ROWS wp_posts.id 14 FROM wp_posts 15 LEFT JOIN wp_postmeta AS sq1 16 ON ( wp_posts.id = sq1.post_id 17 17 AND sq1.meta_key = '_wp_attached_file' ) 18 18 WHERE 1 = 1 19 AND (( ( wp_ developsrc_posts.post_title LIKE '%08W0zJv.jpg%' )20 OR ( wp_ developsrc_posts.post_excerpt LIKE '%08W0zJv.jpg%' )21 OR ( wp_ developsrc_posts.post_content LIKE '%08W0zJv.jpg%' )19 AND (( ( wp_posts.post_title LIKE '%08W0zJv.jpg%' ) 20 OR ( wp_posts.post_excerpt LIKE '%08W0zJv.jpg%' ) 21 OR ( wp_posts.post_content LIKE '%08W0zJv.jpg%' ) 22 22 OR ( sq1.meta_value LIKE '%08W0zJv.jpg%' ) )) 23 AND wp_ developsrc_posts.post_type = 'attachment'24 AND (( wp_ developsrc_posts.post_status = 'inherit'25 OR wp_ developsrc_posts.post_status = 'private' ))26 GROUP BY wp_ developsrc_posts.id27 ORDER BY wp_ developsrc_posts.post_title LIKE '%08W0zJv.jpg%' DESC,28 wp_ developsrc_posts.post_date DESC29 LIMIT 0, 10 23 AND wp_posts.post_type = 'attachment' 24 AND (( wp_posts.post_status = 'inherit' 25 OR wp_posts.post_status = 'private' )) 26 GROUP BY wp_posts.id 27 ORDER BY wp_posts.post_title LIKE '%08W0zJv.jpg%' DESC, 28 wp_posts.post_date DESC 29 LIMIT 0, 10 30 30 }}}