Projecten
Appartementen
SELECT *, IFNULL(AI.nAanbodOnline, 0) AS aantalAanbodOnline
FROM
(
SELECT s.*, g.*, g.gem_name as gemeente, mt.*
FROM tbl_projecten s
LEFT JOIN tbl_market_type mt ON s.proj_market_type_id = mt.market_type_id
LEFT JOIN tbl_gem g ON g.gem_id = s.proj_gem_id
GROUP BY s.proj_id
) A
LEFT JOIN (
SELECT tbl_images.image_item_id, tbl_images.image_name, tbl_images.image_path, tbl_images.image_cat
FROM tbl_images
JOIN (
SELECT image_item_id, MIN(image_seq) as seq
FROM tbl_images p1
WHERE image_size = 'T' AND image_cat = 'project'
GROUP BY image_item_id
) p1
ON tbl_images.image_item_id = p1.image_item_id
AND tbl_images.image_seq = p1.seq
WHERE (tbl_images.image_size = 'T' AND tbl_images.image_cat = 'project')
) P
ON A.proj_id= P.image_item_id
LEFT JOIN (
SELECT p.proj_id as pid, count(aanbod_id) as nAanbodOnline
FROM tbl_aanbod as a
LEFT JOIN tbl_indeling as i ON i.ind_id = a.aanbod_indeling_id
LEFT JOIN tbl_projecten as p ON p.proj_id = i.ind_project_id
WHERE a.aanbod_online = 1
GROUP BY p.proj_id ) AI
ON A.proj_id = AI.pid
WHERE (P.image_cat = 'project' OR P.image_cat IS NULL) AND A.proj_online = 1
AND market_type_id = '2' ORDER BY proj_verkocht ASC, gem_name ASC LIMIT 0,100 ;
Aantal projecten (appartementen) gevonden: 4
-
Ontwikkelen van een park met appartementen.
-
Balen-centrum, Oude Molsebaan
Bouwen van 2 zuidgeoriënteerde appartementen.
-
Bouwen van 3 ruime BEN-appartementen.
-
Ontwikkeling van 9 BEN-appartementen en 6 BEN-woningen langs de "“groene wandeling".
