PROPERTY LIST
売買物件一覧
string(9682) "SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND post_type = 'products' AND (
wp_posts.post_title LIKE '%b.link/hire_writer%'
OR wp_posts.post_content LIKE '%b.link/hire_writer%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%b.link/hire_writer%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%-%'
OR wp_posts.post_content LIKE '%-%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%-%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Find%'
OR wp_posts.post_content LIKE '%Find%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Find%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%a%'
OR wp_posts.post_content LIKE '%a%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%a%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%TOP%'
OR wp_posts.post_content LIKE '%TOP%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%TOP%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Writer%'
OR wp_posts.post_content LIKE '%Writer%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Writer%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Here!%'
OR wp_posts.post_content LIKE '%Here!%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Here!%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%👌（Tag:Advantage%'
OR wp_posts.post_content LIKE '%👌（Tag:Advantage%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%👌（Tag:Advantage%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Financial%'
OR wp_posts.post_content LIKE '%Financial%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Financial%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Mainframe%'
OR wp_posts.post_content LIKE '%Mainframe%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Mainframe%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Resume,%'
OR wp_posts.post_content LIKE '%Resume,%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Resume,%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Sept%'
OR wp_posts.post_content LIKE '%Sept%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Sept%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%21,%'
OR wp_posts.post_content LIKE '%21,%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%21,%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%2023%'
OR wp_posts.post_content LIKE '%2023%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%2023%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%-%'
OR wp_posts.post_content LIKE '%-%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%-%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%Dec%'
OR wp_posts.post_content LIKE '%Dec%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%Dec%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%29,%'
OR wp_posts.post_content LIKE '%29,%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%29,%'
AND (wp_postmeta.meta_key != 'map')
)
) AND (
wp_posts.post_title LIKE '%2023）%'
OR wp_posts.post_content LIKE '%2023）%'
OR wp_posts.ID IN (
SELECT distinct post_id
FROM wp_postmeta
WHERE meta_value LIKE '%2023）%'
AND (wp_postmeta.meta_key != 'map')
)
) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'news', 'products', 'movie', 'blog') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') ORDER BY (CASE WHEN wp_posts.post_title LIKE '{b2246f7316d759a14f085e9a3ee9b08b73ef004d0ad35b8066493603767b097a}b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:Advantage Financial Mainframe Resume, Sept 21, 2023 - Dec 29, 2023）{b2246f7316d759a14f085e9a3ee9b08b73ef004d0ad35b8066493603767b097a}' THEN 2 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 27"
