SELECT count(DISTINCT wp_posts.id) as count FROM wp_posts JOIN wp_postmeta ON (wp_posts.id = wp_postmeta.post_id) WHERE 1=1 AND (MATCH(post_content) AGAINST ('lanzatech') OR MATCH(meta_value) AGAINST('lanzatech')) AND wp_posts.post_type = 'new_fundings' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')
SELECT wp_posts.*, MATCH(post_content) AGAINST ('lanzatech') as content_score, MAX(MATCH(meta_value) AGAINST ('lanzatech')) as meta_value_score, GREATEST(MATCH(post_content) AGAINST ('lanzatech'), MAX(MATCH(meta_value) AGAINST ('lanzatech'))) as score FROM wp_posts JOIN wp_postmeta ON (wp_posts.id = wp_postmeta.post_id) WHERE 1=1 AND (MATCH(post_content) AGAINST ('lanzatech') OR MATCH(meta_value) AGAINST('lanzatech')) AND wp_posts.post_type = 'new_fundings' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.id ORDER BY score DESC, wp_posts.post_date DESC LIMIT 0,20

Full access to Premium Content is only available to registered free trialists and paid subscribers. Already registered?

Sign up for a 4-week free trial and receive our weekly updates by email and access to our website features. There's no commitment after your trial has expired and your email address will not be shared. Click here to sign up.

If you want to start a CTIQ Premium 12-month subscription now and gain full access to our Premium Content including articles, reports, and data, please send an email to: subscriptions@cleantechiq.com or call us at 917-543-6746.

To learn more about our service, click here.

If you have any questions or feedback about our service, please click here.