Reply To: Repeater Plugin – Group By Help

• robbiegod

• November 12, 2013 at 3:52 am

Does this look correct? I’m getting good results with it. So, i think i got it.

$plfsByState = $wpdb->get_results($wpdb->prepare( 
"
SELECT pm.meta_value as state, count(*) as postcount 
FROM $wpdb->posts p
			join $wpdb->postmeta pm on p.ID = pm.post_id
where p.post_type = 'plfmaps'
and p.post_status = 'publish'
AND meta_key LIKE %s 
AND meta_value LIKE %s 
GROUP BY meta_value ASC",
'locations_%_state',
'%',
""		
));

Thanks for your help. This appears to be showing all of the states, grouped by the state and then showing a count of the total number of results from that state. This is a little tricky with those % signs.

Question about the query. At the very end, ‘locations_%_state” is the meta_key, and ‘%’ is the meta_value, so then what is the “” at the very end? What does that do?