testArray ( [id] => 65 [form_id] => 2 [post_id] => [date_created] => 2018-12-12 09:22:24 [date_updated] => 2018-12-12 09:22:24 [is_starred] => 0 [is_read] => 1 [ip] => 92.29.64.191 [source_url] => https://bizl.co/lastform/2 [user_agent] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 [currency] => GBP [payment_status] => [payment_date] => [payment_amount] => [payment_method] => [transaction_id] => [is_fulfilled] => [created_by] => 1 [transaction_type] => [status] => active [1] => 20000 [6] => Asset Purchase [7] => No [10] => Sole Trader [11] => No [12] => No [15] => [email protected] [16] => John's Widgets [17.3] => John [17.6] => Doe [18] => 01234567890 [19] => [22.1] => [22.2] => [22.3] => [8] => [9] => [13] => [14] => [17.2] => [17.4] => [17.8] => [20.1] => [21.1] => ) *430125420*


Array ( [relation] => OR )

SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) INNER JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id ) INNER JOIN wp_postmeta AS mt6 ON ( wp_posts.ID = mt6.post_id ) INNER JOIN wp_postmeta AS mt7 ON ( wp_posts.ID = mt7.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'loan_type_rating' AND ( ( mt1.meta_key = 'active' AND mt1.meta_value = '1' ) AND ( mt2.meta_key = 'loan_amount_minimum' AND CAST(mt2.meta_value AS SIGNED) <= '0' ) AND ( mt3.meta_key = 'loan_amount_maximum' AND CAST(mt3.meta_value AS SIGNED) >= '0' ) AND ( mt4.meta_key = 'trading_minimum' AND CAST(mt4.meta_value AS DECIMAL) <= '0' ) AND ( mt5.meta_key = 'turnover_minimum' AND mt5.meta_value = '0' ) AND ( mt6.meta_key = 'security_required' AND mt6.meta_value NOT REGEXP '[[:<:]]Property[[:>:]]' ) AND ( mt7.meta_key = 'home_ownership_required' AND mt7.meta_value != '1' ) ) ) AND wp_posts.post_type = 'lender' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC