john2230

Hi this is the search content

SELECT DISTINCT wp_posts.ID, wp_posts.post_parent FROM wp_posts LEFT JOIN wp_postmeta AS a ON (a.post_id = wp_posts.ID) LEFT JOIN wp_postmeta AS b ON (b.post_id = wp_posts.ID) LEFT JOIN wp_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 ‘%:”wysiwyg”%’))) WHERE 1=1 AND (((a.meta_value LIKE ‘%eqh-94%’) AND (b.meta_id = a.meta_id + 1) AND (c.post_name = b.meta_value)) OR ((wp_posts.post_title LIKE ‘%eqh-94%’) OR (wp_posts.post_content LIKE ‘%eqh-94%’) OR (wp_posts.post_excerpt LIKE ‘%eqh-94%’))) AND wp_posts.post_type = ‘portfolio’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC

This is the postmeta table for the gallery posts

http://nerysjohnson.com/wp-content/uploads/2018/08/postmeta.jpg

Searching for catalogue number from the sreenshot-postpage.jpg

result:
http://nerysjohnson.com/wp-content/uploads/2018/08/screenshot-search.jpg

plugins list:

http://nerysjohnson.com/wp-content/uploads/2018/08/screenshot-plugins.jpg

Cheers

Hi

These should be the screenshots you’re after,

http://nerysjohnson.com/wp-content/uploads/2018/08/screenshot-postpage.jpg

http://nerysjohnson.com/wp-content/uploads/2018/08/screenshot-custom-field.jpg