Find a Justice of the Peace in Bal Harbour Village (Southern FL)

**** 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 = '3305|Bal Harbour Village' ) 
    OR 
    ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value = '3305|Bal Harbour Village' ) 
    OR 
    ( 
      ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value = '3305|Bal Harbour Village' ) 
      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 ('3446|Bakersfield','3445|Beverly Hills','3444|Chula Vista','3447|Fontana','3449|Irvine','3450|Long Beach','3451|Los Angeles','3452|Malibu','3136|Oceanside','3453|Oxnard','3115|Palm Desert','3454|Palm Springs','3455|Riverside','3456|San Bernardino','3457|San Diego','3458|Santa Ana','3459|Santa Barbara','3448|West Hollywood') ) 
    OR 
    ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('3446|Bakersfield','3445|Beverly Hills','3444|Chula Vista','3447|Fontana','3449|Irvine','3450|Long Beach','3451|Los Angeles','3452|Malibu','3136|Oceanside','3453|Oxnard','3115|Palm Desert','3454|Palm Springs','3455|Riverside','3456|San Bernardino','3457|San Diego','3458|Santa Ana','3459|Santa Barbara','3448|West Hollywood') ) 
    OR 
    ( 
      ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('3446|Bakersfield','3445|Beverly Hills','3444|Chula Vista','3447|Fontana','3449|Irvine','3450|Long Beach','3451|Los Angeles','3452|Malibu','3136|Oceanside','3453|Oxnard','3115|Palm Desert','3454|Palm Springs','3455|Riverside','3456|San Bernardino','3457|San Diego','3458|Santa Ana','3459|Santa Barbara','3448|West Hollywood') ) 
      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.