WHERE modificado: AND Dgi3_posts.post_type = 'st_tours' AND ((Dgi3_posts.post_status = 'publish')) AND Dgi3_posts.ID IN (SELECT post_id FROM Dgi3_st_location_relationships WHERE 1=1 AND location_from IN ('28078','26772') AND post_type IN ('st_tours')) AND
CASE
WHEN ISNULL(tb.max_people) THEN 1=1
WHEN tb.max_people = '' THEN 1=1
WHEN tb.max_people = '0' THEN 1=1
ELSE tb.max_people >= 1 END
AND Dgi3_posts.ID IN (
SELECT post_id FROM Dgi3_st_location_relationships
WHERE location_from IN (28078)
)
