prefix ."posts as i
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_active on i.ID = pm_active.post_ID
and pm_active.meta_key = '_item_active'
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_start_date on i.ID = pm_start_date.post_ID
and pm_start_date.meta_key = '_item_start_date'
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_end_date on i.ID = pm_end_date.post_ID
and pm_end_date.meta_key = '_item_end_date'
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_code on i.ID = pm_code.post_ID
and pm_code.meta_key = '_code'
WHERE i.post_type = '" . FOXYPRESS_CUSTOM_POST_TYPE . "'
AND i.post_status = 'publish'
AND pm_active.meta_value = '1'
AND (coalesce(pm_start_date.meta_value, now()) <= now() AND coalesce(pm_end_date.meta_value, now()) >= now())
AND (
pm_code.meta_value = '" . mysql_escape_string($searchterm) . "'
or i.post_title = '" . mysql_escape_string($searchterm) . "'
or i.post_content = '" . mysql_escape_string($searchterm) . "'
)
UNION
SELECT i.* FROM " . $wpdb->prefix ."posts as i
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_active on i.ID = pm_active.post_ID
and pm_active.meta_key = '_item_active'
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_start_date on i.ID = pm_start_date.post_ID
and pm_start_date.meta_key = '_item_start_date'
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_end_date on i.ID = pm_end_date.post_ID
and pm_end_date.meta_key = '_item_end_date'
LEFT JOIN " . $wpdb->prefix . "postmeta as pm_code on i.ID = pm_code.post_ID
and pm_code.meta_key = '_code'
WHERE i.post_type = '" . FOXYPRESS_CUSTOM_POST_TYPE . "'
AND i.post_status = 'publish'
AND pm_active.meta_value = '1'
AND (coalesce(pm_start_date.meta_value, now()) <= now() AND coalesce(pm_end_date.meta_value, now()) >= now())
AND (
pm_code.meta_value LIKE '%" . mysql_escape_string($searchterm) . "%'
or i.post_title LIKE '%" . mysql_escape_string($searchterm) . "%'
or i.post_content LIKE '%" . mysql_escape_string($searchterm) . "%'
)";
$searchitems = $wpdb->get_results($searchSQL);
$ShowSearchResults = true;
}
?>
FoxyPress Plugin
