Beiträge von joe le taxi

  • Verständnisfrage: wbdb, Sortieren nach Custom Fields

    hallo,

    du kannst ein subquery machen.

    in etwa so (ungetestet):

    SELECT post_status, post_id, post_title, meta_key, meta_value, pm1.* FROM $wpdb->posts
    LEFT JOIN $wpdb->postmeta AS pm1 ON $wpdb->posts.ID = pm1.post_id
    WHERE $wpdb->posts.post_status = 'publish'
    AND meta_key = 'Hersteller'
    AND meta_value = 'Sony'
    AND pm1.post_id
    IN
    (select post_id FROM $wpdb->postmeta where
    meta_key = 'Format'
    AND meta_value = 'Digital Betacam')
    ORDER BY meta_value ASC

    gruß,
    joe