Find a Justice of the Peace in Fremont (Northern CA)

**** 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 ('3460|Chico','3461|Eureka','3463|Fremont','3462|Fresno','3464|Modesto','3465|Oakland','3466|Redding','3467|Sacramento','3468|San Francisco','3469|San Jose','3470|Santa Rosa','3471|Stockton','3472|Turlock','3473|Ukiah','3474|Visalia','3475|Yreka','3476|Yuba city') ) 
    OR 
    ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value IN ('3460|Chico','3461|Eureka','3463|Fremont','3462|Fresno','3464|Modesto','3465|Oakland','3466|Redding','3467|Sacramento','3468|San Francisco','3469|San Jose','3470|Santa Rosa','3471|Stockton','3472|Turlock','3473|Ukiah','3474|Visalia','3475|Yreka','3476|Yuba city') ) 
    OR 
    ( 
      ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value IN ('3460|Chico','3461|Eureka','3463|Fremont','3462|Fresno','3464|Modesto','3465|Oakland','3466|Redding','3467|Sacramento','3468|San Francisco','3469|San Jose','3470|Santa Rosa','3471|Stockton','3472|Turlock','3473|Ukiah','3474|Visalia','3475|Yreka','3476|Yuba city') ) 
      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.