Find a Justice of the Peace in Otis (Western MA)

**** 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 ('2481|Adams','2661|Agawam','3156|Alford','2662|Amherst ','3175|Ashfield','3157|Becket','3207|Belchertown','2663|Bernardston','3193|Blandford','3194|Brimfield','3176|Buckland','3177|Charlemont','3158|Cheshire','3195|Chester','3208|Chesterfield','2664|Chicopee','2665|Clarksburg','3178|Colrain','2666|Conway','3209|Cummington','2667|Dalton','3179|Deerfield','3196|East Longmeadow','2668|Easthampton','3159|Egremont','2669|Erving','2670|Florence','2671|Florida','3180|Gill','3210|Goshen','2672|Granby','3197|Granville','2673|Great Barrington','3181|Greenfield','2694|Hadley','3198|Hampden','3160|Hancock','3211|Hatfield','2674|Hawley','3182|Heath','3161|Hinsdale','3199|Holland','2675|Holyoke','2676|Housatonic','2677|Huntington','3162|Lanesborough','2678|Lee','2679|Lenox','3183|Leverett','2680|Leyden','2681|Longmeadow','3200|Ludlow','2682|Middlefield','2683|Mill River','3184|Monroe','2685|Monson','2684|Montaque','3163|Monterey','3201|Montgomery','3164|Mt. Washington','3165|New Ashford','3166|New Marlborough','3185|New Salem','3167|North Adams','2686|Northampton','3186|Northfiel','3187|Orange','3168|Otis','2687|Palmer','3212|Pelham','3169|Peru','2688|Pittsfield','3213|Plainfield','2689|Richmond','3188|Rowe','3202|Russell','3170|Sandisfield','3171|Savoy','2690|Sheffield','3189|Shelburne','2691|Sherman','2692|Shutesbury','2693|South Deerfield','3214|South Hadley','3215|Southampton','3203|Southwick','2695|Springfield','2696|Stamford','2697|Stockbridge','2698|Stratford','3144|Sunderland','3204|Tolland','2699|Trumbull','3172|Tyringham','3205|Wales','2700|Ware','3190|Warwick','3173|Washington','3191|Wendell','3206|WEST SPRINGFIELD','3174|West Stockbridge','2701|Westfield','3216|Westhampton','3192|Whately','2702|Wilbraham','3217|Williamsburg','2703|Williamstown','2704|Windsor','3218|Worthington') ) 
    OR 
    ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('2481|Adams','2661|Agawam','3156|Alford','2662|Amherst ','3175|Ashfield','3157|Becket','3207|Belchertown','2663|Bernardston','3193|Blandford','3194|Brimfield','3176|Buckland','3177|Charlemont','3158|Cheshire','3195|Chester','3208|Chesterfield','2664|Chicopee','2665|Clarksburg','3178|Colrain','2666|Conway','3209|Cummington','2667|Dalton','3179|Deerfield','3196|East Longmeadow','2668|Easthampton','3159|Egremont','2669|Erving','2670|Florence','2671|Florida','3180|Gill','3210|Goshen','2672|Granby','3197|Granville','2673|Great Barrington','3181|Greenfield','2694|Hadley','3198|Hampden','3160|Hancock','3211|Hatfield','2674|Hawley','3182|Heath','3161|Hinsdale','3199|Holland','2675|Holyoke','2676|Housatonic','2677|Huntington','3162|Lanesborough','2678|Lee','2679|Lenox','3183|Leverett','2680|Leyden','2681|Longmeadow','3200|Ludlow','2682|Middlefield','2683|Mill River','3184|Monroe','2685|Monson','2684|Montaque','3163|Monterey','3201|Montgomery','3164|Mt. Washington','3165|New Ashford','3166|New Marlborough','3185|New Salem','3167|North Adams','2686|Northampton','3186|Northfiel','3187|Orange','3168|Otis','2687|Palmer','3212|Pelham','3169|Peru','2688|Pittsfield','3213|Plainfield','2689|Richmond','3188|Rowe','3202|Russell','3170|Sandisfield','3171|Savoy','2690|Sheffield','3189|Shelburne','2691|Sherman','2692|Shutesbury','2693|South Deerfield','3214|South Hadley','3215|Southampton','3203|Southwick','2695|Springfield','2696|Stamford','2697|Stockbridge','2698|Stratford','3144|Sunderland','3204|Tolland','2699|Trumbull','3172|Tyringham','3205|Wales','2700|Ware','3190|Warwick','3173|Washington','3191|Wendell','3206|WEST SPRINGFIELD','3174|West Stockbridge','2701|Westfield','3216|Westhampton','3192|Whately','2702|Wilbraham','3217|Williamsburg','2703|Williamstown','2704|Windsor','3218|Worthington') ) 
    OR 
    ( 
      ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('2481|Adams','2661|Agawam','3156|Alford','2662|Amherst ','3175|Ashfield','3157|Becket','3207|Belchertown','2663|Bernardston','3193|Blandford','3194|Brimfield','3176|Buckland','3177|Charlemont','3158|Cheshire','3195|Chester','3208|Chesterfield','2664|Chicopee','2665|Clarksburg','3178|Colrain','2666|Conway','3209|Cummington','2667|Dalton','3179|Deerfield','3196|East Longmeadow','2668|Easthampton','3159|Egremont','2669|Erving','2670|Florence','2671|Florida','3180|Gill','3210|Goshen','2672|Granby','3197|Granville','2673|Great Barrington','3181|Greenfield','2694|Hadley','3198|Hampden','3160|Hancock','3211|Hatfield','2674|Hawley','3182|Heath','3161|Hinsdale','3199|Holland','2675|Holyoke','2676|Housatonic','2677|Huntington','3162|Lanesborough','2678|Lee','2679|Lenox','3183|Leverett','2680|Leyden','2681|Longmeadow','3200|Ludlow','2682|Middlefield','2683|Mill River','3184|Monroe','2685|Monson','2684|Montaque','3163|Monterey','3201|Montgomery','3164|Mt. Washington','3165|New Ashford','3166|New Marlborough','3185|New Salem','3167|North Adams','2686|Northampton','3186|Northfiel','3187|Orange','3168|Otis','2687|Palmer','3212|Pelham','3169|Peru','2688|Pittsfield','3213|Plainfield','2689|Richmond','3188|Rowe','3202|Russell','3170|Sandisfield','3171|Savoy','2690|Sheffield','3189|Shelburne','2691|Sherman','2692|Shutesbury','2693|South Deerfield','3214|South Hadley','3215|Southampton','3203|Southwick','2695|Springfield','2696|Stamford','2697|Stockbridge','2698|Stratford','3144|Sunderland','3204|Tolland','2699|Trumbull','3172|Tyringham','3205|Wales','2700|Ware','3190|Warwick','3173|Washington','3191|Wendell','3206|WEST SPRINGFIELD','3174|West Stockbridge','2701|Westfield','3216|Westhampton','3192|Whately','2702|Wilbraham','3217|Williamsburg','2703|Williamstown','2704|Windsor','3218|Worthington') ) 
      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