SELECT SUM(IF(A.land_size IS NULL, 0 , A.land_size)) existencia, COUNT(*) existenciaC,
SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Fully Developed' OR A.land_condition = 'Fully Developer', A.land_size, 0))) f_deleveloped,
SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Fully Developed' OR A.land_condition = 'Fully Developer', 1, 0))) f_delevelopedC,
SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Undeveloped', A.land_size, 0))) undeveloped,
SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Undeveloped', 1, 0))) undevelopedC
FROM proy_land_available A LEFT JOIN proy_industrial_park E ON A.industrial_park = E.id
LEFT JOIN proy_developer G ON A.owner = G.id LEFT JOIN proy_developer H ON A.developer = H.id LEFT JOIN proy_categoria B ON A.market = B.id LEFT JOIN proy_categoria C ON A.sub_market = C.id
LEFT JOIN proy_catalogo_detalle D ON A.region = D.id WHERE 1=1
Exisiting land site
34,522 HA
Land fully developed
9,145 HA
Land undeveloped
14,696 HA

36,650 (SF)
Class B

107,670 (SF)
Class B

50,397 (SF)
Class A

228,972 (SF)
Class A

42,820 (SF)
Class A

115,492 (SF)
Class A

52,001 (SF)
Class B

256,523 (SF)
Class A