basboerman

job done!

Screenshot for point 2: https://we.tl/t-nft2yEJNIv

SELECT DISTINCT SQL_CALC_FOUND_ROWS bas_posts.* FROM bas_posts LEFT JOIN bas_postmeta AS a ON (a.post_id = bas_posts.ID) LEFT JOIN bas_postmeta AS b ON (b.post_id = bas_posts.ID) LEFT JOIN bas_posts AS c ON ((c.post_type = ‘acf-field’) AND ((c.post_content LIKE ‘%:”text”%’) OR (c.post_content LIKE ‘%:”textarea”%’) OR (c.post_content LIKE ‘%:”number”%’) OR (c.post_content LIKE ‘%:”email”%’) OR (c.post_content LIKE ‘%:”url”%’) OR (c.post_content LIKE ‘%:”wysiwyg”%’) OR (c.post_content LIKE ‘%:”select”%’) OR (c.post_content LIKE ‘%:”checkbox”%’) OR (c.post_content LIKE ‘%:”radio”%’))) WHERE 1=1 AND bas_posts.ID NOT IN (2)AND (((a.meta_value LIKE ‘%WOTS%’) AND (b.meta_id = a.meta_id + 1) AND (c.post_name = b.meta_value)) OR ((bas_posts.post_title LIKE ‘%WOTS%’) OR (bas_posts.post_content LIKE ‘%WOTS%’) OR (bas_posts.post_excerpt LIKE ‘%WOTS%’))) AND bas_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘project’) AND (bas_posts.post_status = ‘publish’ OR bas_posts.post_status = ‘acf-disabled’ OR bas_posts.post_author = 2 AND bas_posts.post_status = ‘private’) ORDER BY bas_posts.post_title LIKE ‘{0acf8a6a51a02204c8d8e665b78a8c205f5100212f087e295e4b7f640adb29ca}WOTS{0acf8a6a51a02204c8d8e665b78a8c205f5100212f087e295e4b7f640adb29ca}’ DESC, bas_posts.post_date DESC LIMIT 0, 100

Maybe it’s easier if i give you a db dumb? Running PHP 7.2 en WP 4.9.8