Find a Justice of the Peace in Salem (New London County CT) **** 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 = '2630|Salem' ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value = '2630|Salem' ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value = '2630|Salem' ) 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 ('2478|Bozrah','2615|Colchester','2616|East Lyme','2617|Franklin','2618|Griswold','2619|Groton','2620|Lebanon','2621|Ledyard','2622|Lisbon','2623|Lyme','2624|Montville','2625|New London','2626|North Stonington','2627|Norwich','2628|Old Lyme','2629|Preston','2630|Salem','2631|Sprague','2632|Stonington','2633|Voluntown','2634|Waterford') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2478|Bozrah','2615|Colchester','2616|East Lyme','2617|Franklin','2618|Griswold','2619|Groton','2620|Lebanon','2621|Ledyard','2622|Lisbon','2623|Lyme','2624|Montville','2625|New London','2626|North Stonington','2627|Norwich','2628|Old Lyme','2629|Preston','2630|Salem','2631|Sprague','2632|Stonington','2633|Voluntown','2634|Waterford') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2478|Bozrah','2615|Colchester','2616|East Lyme','2617|Franklin','2618|Griswold','2619|Groton','2620|Lebanon','2621|Ledyard','2622|Lisbon','2623|Lyme','2624|Montville','2625|New London','2626|North Stonington','2627|Norwich','2628|Old Lyme','2629|Preston','2630|Salem','2631|Sprague','2632|Stonington','2633|Voluntown','2634|Waterford') ) 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 ('2478|Bozrah','2615|Colchester','2616|East Lyme','2617|Franklin','2618|Griswold','2619|Groton','2620|Lebanon','2621|Ledyard','2622|Lisbon','2623|Lyme','2624|Montville','2625|New London','2626|North Stonington','2627|Norwich','2628|Old Lyme','2629|Preston','2630|Salem','2631|Sprague','2632|Stonington','2633|Voluntown','2634|Waterford') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2478|Bozrah','2615|Colchester','2616|East Lyme','2617|Franklin','2618|Griswold','2619|Groton','2620|Lebanon','2621|Ledyard','2622|Lisbon','2623|Lyme','2624|Montville','2625|New London','2626|North Stonington','2627|Norwich','2628|Old Lyme','2629|Preston','2630|Salem','2631|Sprague','2632|Stonington','2633|Voluntown','2634|Waterford') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2478|Bozrah','2615|Colchester','2616|East Lyme','2617|Franklin','2618|Griswold','2619|Groton','2620|Lebanon','2621|Ledyard','2622|Lisbon','2623|Lyme','2624|Montville','2625|New London','2626|North Stonington','2627|Norwich','2628|Old Lyme','2629|Preston','2630|Salem','2631|Sprague','2632|Stonington','2633|Voluntown','2634|Waterford') ) 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