SELECT SQL_CALC_FOUND_ROWS blue_posts.ID FROM blue_posts INNER JOIN blue_postmeta ON ( blue_posts.ID = blue_postmeta.post_id ) JOIN blue_icl_translations t ON blue_posts.ID = t.element_id AND t.element_type = CONCAT('post_', blue_posts.post_type) WHERE 1=1 AND ( ( blue_postmeta.meta_key = 'package_last_check_in' AND CAST(blue_postmeta.meta_value AS SIGNED) >= '1685715205' ) ) AND blue_posts.post_type = 'blue_packages' AND (blue_posts.post_status = 'publish') AND ( ( ( t.language_code = 'en' OR 0 ) AND blue_posts.post_type IN ('post','page','attachment','property','blue_events','destination','blue_packages','gallery','team' ) ) OR blue_posts.post_type NOT IN ('post','page','attachment','property','blue_events','destination','blue_packages','gallery','team' ) ) GROUP BY blue_posts.ID ORDER BY blue_posts.post_date DESC LIMIT 0, 9