IMMOCOM: Vastgoedkantoor gespecialiseerd in VERHUUR en BEHEER van gemeubled vastgoed in het Brussels gewest. Lid van het Trevi partner netwerk.

SELECT *, slides.slide_id AS id FROM slides LEFT JOIN multipictures ON slides.slide_id = multipictures.slide_id AND multipictures.is_published = 1 AND FIND_IN_SET(nl, multipictures.lng_id) LEFT JOIN multidocuments ON slides.slide_id = multidocuments.slide_id AND multidocuments.is_published = 1 AND FIND_IN_SET(nl, multidocuments.lng_id) WHERE (slides.agency_id = 38 OR slides.is_partner = 1) AND slides.is_published = 1 AND slides.pub_date <= NOW() AND (market_id = 1 OR market_id = 3) GROUP BY slides.slide_id ORDER BY slides.agency_id asc,slide_order ASC