Ranking moviemakerów na netmovies.pl
Array
(
[0] => stdClass Object
(
[umeta_id] => 6097
[user_id] => 1
[meta_key] => fightstats
[meta_value] => Array (1=>1000, 2=>7, 3=>3, 4=>2, 5=>10, 6=>1223);
[user_nicename] => adrix
)
)
AND wusermeta.meta_key = 'win'
AND wusermeta.meta_key = 'lost'
AND wusermeta.meta_key = 'draw'
AND wusermeta.meta_key = 'streak'
AND wusermeta.meta_key = 'all4all'
AND wusermeta.meta_key = 'status'
$querystr = "
SELECT wusermeta.*, wusers.user_nicename
FROM $wpdb->users wusers, $wpdb->usermeta wusermeta
WHERE wusers.ID = wusermeta.user_id
AND wusermeta.meta_key = 'points'
ORDER BY wusermeta.umeta_id DESC
";
$query = "
SELECT *
FROM {$wpdb->prefix}posts
INNER JOIN {$wpdb->prefix}postmeta m1
ON ( {$wpdb->prefix}posts.ID = m1.post_id )
INNER JOIN {$wpdb->prefix}postmeta m2
ON ( {$wpdb->prefix}posts.ID = m2.post_id )
WHERE
{$wpdb->prefix}posts.post_type = 'post'
AND {$wpdb->prefix}posts.post_status = 'publish'
AND ( m1.meta_key = 'date' AND m1.meta_value > '2010-12-05 00:00:00' )
AND ( m1.meta_key = 'date' AND m1.meta_value < '2010-12-12 00:00:00' )
AND ( m2.meta_key = 'some_other_meta_value' AND m2.meta_value != '' )
GROUP BY {$wpdb->prefix}posts.ID
ORDER BY {$wpdb->prefix}posts.post_date
DESC;
";
Najnowsze komentarze