SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-26:2026-07-26' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('23','781152','777570','777565','777564','777563','777544','777526','777524','777523','777520','777519','777518','777516','777515','777514','777511','777508','777507','777506','777505','777503','777502','777500','777499','777493','777492','777491','777490','777478','777476','777475','777474','777473','777470','777469','777467','777466','777465','777463','777462','777461','777460','777458','777456','777454','777453','777451','777450','777449','777448','777447','777446','777443','777442','777440','777439','777438','777436','777432','777431','777430','777429','777428','777427','777426','777425','777424','777423','777422','777421','777420','777419','777418','777417','777416','777415','777414','777413','777412','777411','777410','777409','777408','777407','777405','777404','777403','777402','777400','777399','777398','777397','777396','777395','777394','777393','777392','777390','777389','777388','777387','777386','777384','777381','777378','777375','777372','777369','777366','777363','777360','777357','777354','777351','777347','777344','777341','777338','777335','448980','448802','448573','448348','448256','447985','204214','31','30','29','28','26','25','24') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
LIMIT 0, 12
Nažalost, smještaj nije pronađen.