Find a Justice of the Peace in Denver (Metro CO) **** extra-shortcodes.php 662: SELECT jp_posts.ID FROM jp_posts INNER JOIN jp_postmeta ON ( jp_posts.ID = jp_postmeta.post_id ) INNER JOIN jp_postmeta AS mt1 ON ( jp_posts.ID = mt1.post_id ) INNER JOIN jp_postmeta AS mt2 ON ( jp_posts.ID = mt2.post_id ) INNER JOIN jp_postmeta AS mt3 ON ( jp_posts.ID = mt3.post_id ) WHERE 1=1 AND ( jp_postmeta.meta_key = 'jpus_town_count' AND ( ( mt1.meta_key = 'jpus_feat_town' AND mt1.meta_value = '3480|Denver' ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value = '3480|Denver' ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value = '3480|Denver' ) AND ( mt3.meta_key = 'jpus_town_count' ) ) ) ) AND jp_posts.post_type = 'jpus_justice' AND ((jp_posts.post_status = 'publish' OR jp_posts.post_status = 'acf-disabled' OR jp_posts.post_status = 'private')) GROUP BY jp_posts.ID ORDER BY jp_postmeta.meta_value+0 DESC, RAND() ASC **** extra-shortcodes.php 662: SELECT jp_posts.ID FROM jp_posts INNER JOIN jp_postmeta ON ( jp_posts.ID = jp_postmeta.post_id ) INNER JOIN jp_postmeta AS mt1 ON ( jp_posts.ID = mt1.post_id ) INNER JOIN jp_postmeta AS mt2 ON ( jp_posts.ID = mt2.post_id ) INNER JOIN jp_postmeta AS mt3 ON ( jp_posts.ID = mt3.post_id ) WHERE 1=1 AND ( jp_postmeta.meta_key = 'jpus_town_count' AND ( ( mt1.meta_key = 'jpus_feat_town' AND mt1.meta_value IN ('3480|Denver') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('3480|Denver') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('3480|Denver') ) AND ( mt3.meta_key = 'jpus_town_count' ) ) ) ) AND jp_posts.post_type = 'jpus_justice' AND ((jp_posts.post_status = 'publish' OR jp_posts.post_status = 'acf-disabled' OR jp_posts.post_status = 'private')) GROUP BY jp_posts.ID ORDER BY jp_postmeta.meta_value+0 DESC, RAND() ASC Unfortunately no Justices of the Peace were found here, but new JPs join daily so please check back again soon. Town Clerk Filter JPs Advertisment
