Find a Justice of the Peace in Cornwall (Litchfield 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 = '2554|Cornwall' ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value = '2554|Cornwall' ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value = '2554|Cornwall' ) 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 ('2475|Barkhamsted','2550|Bethlehem','2551|Bridgewater','2552|Canaan','2553|Colebrook','2554|Cornwall','2555|Goshen','2556|Harwinton','2557|Kent','2558|Litchfield','2559|Morris','2560|New Hartford','2561|New Milford','2562|Norfolk','2563|North Canaan','2564|Plymouth','2565|Roxbury','2566|Salisbury','2567|Sharon','2568|Thomaston','2569|Torrington','2570|Warren','2571|Washington','2572|Watertown','2573|Winchester','2574|Woodbury') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2475|Barkhamsted','2550|Bethlehem','2551|Bridgewater','2552|Canaan','2553|Colebrook','2554|Cornwall','2555|Goshen','2556|Harwinton','2557|Kent','2558|Litchfield','2559|Morris','2560|New Hartford','2561|New Milford','2562|Norfolk','2563|North Canaan','2564|Plymouth','2565|Roxbury','2566|Salisbury','2567|Sharon','2568|Thomaston','2569|Torrington','2570|Warren','2571|Washington','2572|Watertown','2573|Winchester','2574|Woodbury') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2475|Barkhamsted','2550|Bethlehem','2551|Bridgewater','2552|Canaan','2553|Colebrook','2554|Cornwall','2555|Goshen','2556|Harwinton','2557|Kent','2558|Litchfield','2559|Morris','2560|New Hartford','2561|New Milford','2562|Norfolk','2563|North Canaan','2564|Plymouth','2565|Roxbury','2566|Salisbury','2567|Sharon','2568|Thomaston','2569|Torrington','2570|Warren','2571|Washington','2572|Watertown','2573|Winchester','2574|Woodbury') ) 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 ('2475|Barkhamsted','2550|Bethlehem','2551|Bridgewater','2552|Canaan','2553|Colebrook','2554|Cornwall','2555|Goshen','2556|Harwinton','2557|Kent','2558|Litchfield','2559|Morris','2560|New Hartford','2561|New Milford','2562|Norfolk','2563|North Canaan','2564|Plymouth','2565|Roxbury','2566|Salisbury','2567|Sharon','2568|Thomaston','2569|Torrington','2570|Warren','2571|Washington','2572|Watertown','2573|Winchester','2574|Woodbury') ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2475|Barkhamsted','2550|Bethlehem','2551|Bridgewater','2552|Canaan','2553|Colebrook','2554|Cornwall','2555|Goshen','2556|Harwinton','2557|Kent','2558|Litchfield','2559|Morris','2560|New Hartford','2561|New Milford','2562|Norfolk','2563|North Canaan','2564|Plymouth','2565|Roxbury','2566|Salisbury','2567|Sharon','2568|Thomaston','2569|Torrington','2570|Warren','2571|Washington','2572|Watertown','2573|Winchester','2574|Woodbury') ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2475|Barkhamsted','2550|Bethlehem','2551|Bridgewater','2552|Canaan','2553|Colebrook','2554|Cornwall','2555|Goshen','2556|Harwinton','2557|Kent','2558|Litchfield','2559|Morris','2560|New Hartford','2561|New Milford','2562|Norfolk','2563|North Canaan','2564|Plymouth','2565|Roxbury','2566|Salisbury','2567|Sharon','2568|Thomaston','2569|Torrington','2570|Warren','2571|Washington','2572|Watertown','2573|Winchester','2574|Woodbury') ) 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