Welcome to the Island of Elba

SELECT SQL_CALC_FOUND_ROWS ebl_posts.ID FROM ebl_posts INNER JOIN ebl_postmeta ON ( ebl_posts.ID = ebl_postmeta.post_id ) LEFT JOIN ebl_icl_translations t ON ebl_posts.ID = t.element_id AND t.element_type = CONCAT('post_', ebl_posts.post_type) WHERE 1=1 AND ( ebl_postmeta.meta_key = 'pw_last_valid_change_offerte' ) AND ebl_posts.post_type = 'offerte-isola-d-elba' AND (ebl_posts.post_status = 'publish') AND ( ( t.language_code = 'en' AND ebl_posts.post_type IN ('post','page','offerte-isola-d-elba','acf','wpx_bannerize','item','jv_events' ) ) OR ebl_posts.post_type NOT IN ('post','page','offerte-isola-d-elba','acf','wpx_bannerize','item','jv_events' ) ) GROUP BY ebl_posts.ID ORDER BY ebl_postmeta.meta_value DESC LIMIT 0, 10