Vanilla 1.1.10 es un producto de Lussumo. Para más información: Documentación, Soporte.
$querystr = "
SELECT wposts.*
FROM $wpdb->posts wposts
INNER JOIN $wpdb->postmeta wpostmeta ON wposts.ID= wpostmeta.post_id
INNER JOIN $wpdb->term_relationships wptr ON wposts.ID = wptr.object_id
WHERE wptr.term_taxonomy_id='7'
AND wpostmeta.meta_key = 'vid_mostrar'
AND wpostmeta.meta_value = 'S'
AND wposts.post_status = 'publish'
AND wposts.post_type = 'post'
ORDER BY RAND() LIMIT 1
";
Posted By: fcovicente¿No sería un poco menos complicado usando el objeto WP Query?
$args = array(
'tag' => 'etiqueta-a,etiqueta-b',
'meta_query' => array(
'key' => 'vid_mostrar',
'value' => 'S',
),
'orderby' => 'rand'
);
$query = new WP_Query( $args );
1 a 7 de 7