SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID
FROM wp_2_posts INNER JOIN wp_2_postmeta ON ( wp_2_posts.ID = wp_2_postmeta.post_id ) INNER JOIN wp_2_postmeta AS mt1 ON ( wp_2_posts.ID = mt1.post_id )
WHERE 1=1 AND (
( wp_2_postmeta.meta_key = 'offerReference' AND wp_2_postmeta.meta_value IN ('251041','251019','251020','251029','251035','251036','251032','251042','251483','251487','251488','251489','251490','251492','251493','251495','251497','251501','251599','251600','251601','251602','251603','251604','251605','251606','251607','251608','251609','251610','251611','251612','251613','251614','251615','251616','251617','251618','251619','251620','251621','251622','251623','251624','251625','251626','251627','251628','251629','251630','251631','251632','251633','251634','251635','251636','251637','251638','251639','251640','251641','251642','251643','251644','251645','251646','251647','251648','251649','251650','251651','251652','251653','251654','251655','251692','251689','251690','251691','251965','251966','251967','251719','251720','251721','251722','251723','252134','251611','252135','252136','252137','252138','252139','251626','252140','252141','251654','252142','252143','251631','252144','252145','252146','251723','252147','252148','252213','252261','252262') )
AND
( mt1.meta_key = 'price-public' AND CAST(mt1.meta_value AS SIGNED) <= '999999' )
) AND wp_2_posts.post_type = 'veicoli' AND ((wp_2_posts.post_status = 'publish'))
GROUP BY wp_2_posts.ID
ORDER BY wp_2_posts.post_date DESC
LIMIT 0, 24