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

134,550 (SF)
Class A

49,310 (SF)
Class B

119,922 (SF)
Class B

118,108 (SF)
Class A

30,149 (SF)
Class A

80,654 (SF)
Class A

93,810 (SF)
Class A
Monterrey
Cienega de Flores

115,174 (SF)
Class B