Forum Replies Created

Viewing 3 replies - 16 through 18 (of 18 total)
  • Thread Starter John

    (@groupewibi)

    I did my best, but i do not understand why it’s retriveing only some value, and it’s not ordering ;o(

    SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) 
    
    INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id) WHERE 1=1 AND wp_posts.post_type = 'matchs' AND (wp_posts.post_status = 'publish') 
    
    AND ( (wp_postmeta.meta_key = 'rel_equip_visitor' AND CAST(wp_postmeta.meta_value AS CHAR) = '201') OR (mt1.meta_key = 'rel_equip_host' AND CAST(mt1.meta_value AS CHAR) = '201') )  
    
    AND (wp_postmeta.meta_key = 'date_match' ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value ASC LIMIT 0, 10
    Thread Starter John

    (@groupewibi)

    Ok. Thank u.

    Im not very fimiliar with these way to process.
    I will have a check on both method.

    But i finding this meta_query, not very logic, or maibe i using it on a wrong way ?

    Forum: Fixing WordPress
    In reply to: Nested Loop issues
    Thread Starter John

    (@groupewibi)

    Sorry Max,

    Here more informations :
    I have create Custom Content using Custom Content Type Manager.

    I think it’s neither Taxonomy or Category. Or maibe i missing some stuff there.

Viewing 3 replies - 16 through 18 (of 18 total)