Debut:
posts p
INNER JOIN $wpdb->postmeta pm ON pm.post_id = p ON p.ID
INNER JOIN $wpdb->postmeta pm2 ON pm2.post_id = p ON p.ID
WHERE pm.meta_key = ('PL1','PL2','PL3','PL4','PL5','PL6','PL7','PL8','PL9','PL10','PL11')
OR ((
pm.meta_key IN ('PL12', 'PL13', 'PL14', 'PL15', 'PL16', 'PL17', 'PL18')
AND pm.meta_value = %d
)
AND (
pm2.meta_key IN ('si12','si13','si14','si15','si16','si17','si18')
AND ( SUBSTR(pm2.meta_key, 3) = SUBSTR(pm.meta_key, 3) )
AND pm2.meta_value+0 > 0
))
AND pm.meta_value = $playerID
AND p.post_type = 'match'
ORDER BY p.post_date ASC
LIMIT 1
";
$debut = $wpdb->get_results($querystr, OBJECT);
if ($pageposts):
global $post;
foreach ($pageposts as $post):
setup_postdata($post);
?>
vs. post_title;?> (, ),
No Debut