Find a Justice of the Peace in Wellington (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 = '3359|Wellington' ) OR ( mt1.meta_key = 'jpus_hometown' AND mt1.meta_value = '3359|Wellington' ) OR ( ( mt2.meta_key = 'jpus_chosen_town' AND mt2.meta_value = '3359|Wellington' ) 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.
Recent Comments