Find a Justice of the Peace in Deerfield (Rockingham County NH) **** 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 = '3013|Deerfield' ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value = '3013|Deerfield' ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value = '3013|Deerfield' ) 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 ('2492|Atkinson','3008|Auburn','3009|Brentwood','3010|Candia','3011|Chester','3012|Danville','3013|Deerfield','3014|Derry','3015|East Kingston','3016|Epping','3017|Exeter','3018|Fremont','3019|Greenland','3020|Hampstead','3021|Hampton','3022|Hampton Falls','3023|Kensington','3024|Kingston','3025|Londonderry','3026|New Castle','3027|Newfields','3028|Newington','3029|Newmarket','3030|Newton','3031|North Hampton','3032|Northwood','3033|Nottingham','3034|Plaistow','3035|Portsmouth','3036|Raymond','3037|Rye','3038|Salem','3039|Sandown','3040|Seabrook','3041|South Hampton','3042|Stratham','3043|Windham') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2492|Atkinson','3008|Auburn','3009|Brentwood','3010|Candia','3011|Chester','3012|Danville','3013|Deerfield','3014|Derry','3015|East Kingston','3016|Epping','3017|Exeter','3018|Fremont','3019|Greenland','3020|Hampstead','3021|Hampton','3022|Hampton Falls','3023|Kensington','3024|Kingston','3025|Londonderry','3026|New Castle','3027|Newfields','3028|Newington','3029|Newmarket','3030|Newton','3031|North Hampton','3032|Northwood','3033|Nottingham','3034|Plaistow','3035|Portsmouth','3036|Raymond','3037|Rye','3038|Salem','3039|Sandown','3040|Seabrook','3041|South Hampton','3042|Stratham','3043|Windham') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2492|Atkinson','3008|Auburn','3009|Brentwood','3010|Candia','3011|Chester','3012|Danville','3013|Deerfield','3014|Derry','3015|East Kingston','3016|Epping','3017|Exeter','3018|Fremont','3019|Greenland','3020|Hampstead','3021|Hampton','3022|Hampton Falls','3023|Kensington','3024|Kingston','3025|Londonderry','3026|New Castle','3027|Newfields','3028|Newington','3029|Newmarket','3030|Newton','3031|North Hampton','3032|Northwood','3033|Nottingham','3034|Plaistow','3035|Portsmouth','3036|Raymond','3037|Rye','3038|Salem','3039|Sandown','3040|Seabrook','3041|South Hampton','3042|Stratham','3043|Windham') ) 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 ('2492|Atkinson','3008|Auburn','3009|Brentwood','3010|Candia','3011|Chester','3012|Danville','3013|Deerfield','3014|Derry','3015|East Kingston','3016|Epping','3017|Exeter','3018|Fremont','3019|Greenland','3020|Hampstead','3021|Hampton','3022|Hampton Falls','3023|Kensington','3024|Kingston','3025|Londonderry','3026|New Castle','3027|Newfields','3028|Newington','3029|Newmarket','3030|Newton','3031|North Hampton','3032|Northwood','3033|Nottingham','3034|Plaistow','3035|Portsmouth','3036|Raymond','3037|Rye','3038|Salem','3039|Sandown','3040|Seabrook','3041|South Hampton','3042|Stratham','3043|Windham') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2492|Atkinson','3008|Auburn','3009|Brentwood','3010|Candia','3011|Chester','3012|Danville','3013|Deerfield','3014|Derry','3015|East Kingston','3016|Epping','3017|Exeter','3018|Fremont','3019|Greenland','3020|Hampstead','3021|Hampton','3022|Hampton Falls','3023|Kensington','3024|Kingston','3025|Londonderry','3026|New Castle','3027|Newfields','3028|Newington','3029|Newmarket','3030|Newton','3031|North Hampton','3032|Northwood','3033|Nottingham','3034|Plaistow','3035|Portsmouth','3036|Raymond','3037|Rye','3038|Salem','3039|Sandown','3040|Seabrook','3041|South Hampton','3042|Stratham','3043|Windham') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2492|Atkinson','3008|Auburn','3009|Brentwood','3010|Candia','3011|Chester','3012|Danville','3013|Deerfield','3014|Derry','3015|East Kingston','3016|Epping','3017|Exeter','3018|Fremont','3019|Greenland','3020|Hampstead','3021|Hampton','3022|Hampton Falls','3023|Kensington','3024|Kingston','3025|Londonderry','3026|New Castle','3027|Newfields','3028|Newington','3029|Newmarket','3030|Newton','3031|North Hampton','3032|Northwood','3033|Nottingham','3034|Plaistow','3035|Portsmouth','3036|Raymond','3037|Rye','3038|Salem','3039|Sandown','3040|Seabrook','3041|South Hampton','3042|Stratham','3043|Windham') ) 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