WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #36169


Ignore:
Timestamp:
03/08/2016 11:05:06 AM (11 years ago)
Author:
dd32
Comment:

Just broke up the JOIN syntax into multiple lines for readability.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #36169

    • Property Component General → Query

  • Ticket #36169 – Description

    initial v1  
    9090
    9191{{{
    92 SELECT   wp_oiwx_posts.ID FROM wp_oiwx_posts  LEFT JOIN wp_oiwx_postmeta ON ( wp_oiwx_posts.ID = wp_oiwx_postmeta.post_id )  LEFT JOIN wp_oiwx_postmeta AS mt1 ON (wp_oiwx_posts.ID = mt1.post_id AND mt1.meta_key = 'attribute_calligraphy-style' )  LEFT JOIN wp_oiwx_postmeta AS mt2 ON ( wp_oiwx_posts.ID = mt2.post_id )  LEFT JOIN wp_oiwx_postmeta AS mt3 ON (wp_oiwx_posts.ID = mt3.post_id AND mt3.meta_key = 'attribute_product' )  LEFT JOIN wp_oiwx_postmeta AS mt4 ON ( wp_oiwx_posts.ID = mt4.post_id )  LEFT JOIN wp_oiwx_postmeta AS mt5 ON (wp_oiwx_posts.ID = mt5.post_id AND mt5.meta_key = 'attribute_ink' ) WHERE 1=1  AND wp_oiwx_posts.post_parent = 4790  AND (
     92SELECT   wp_oiwx_posts.ID FROM wp_oiwx_posts
     93  LEFT JOIN wp_oiwx_postmeta ON ( wp_oiwx_posts.ID = wp_oiwx_postmeta.post_id )
     94  LEFT JOIN wp_oiwx_postmeta AS mt1 ON (wp_oiwx_posts.ID = mt1.post_id AND mt1.meta_key = 'attribute_calligraphy-style' )
     95  LEFT JOIN wp_oiwx_postmeta AS mt2 ON ( wp_oiwx_posts.ID = mt2.post_id )
     96  LEFT JOIN wp_oiwx_postmeta AS mt3 ON (wp_oiwx_posts.ID = mt3.post_id AND mt3.meta_key = 'attribute_product' )
     97  LEFT JOIN wp_oiwx_postmeta AS mt4 ON ( wp_oiwx_posts.ID = mt4.post_id )
     98  LEFT JOIN wp_oiwx_postmeta AS mt5 ON (wp_oiwx_posts.ID = mt5.post_id AND mt5.meta_key = 'attribute_ink' )
     99 WHERE 1=1  AND wp_oiwx_posts.post_parent = 4790  AND (
    93100  (
    94101    ( wp_oiwx_postmeta.meta_key = 'attribute_calligraphy-style' AND CAST(wp_oiwx_postmeta.meta_value AS CHAR) IN ('','Julia') )