|
|
|
|
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /web/htdocs/www.erreo.eu/home/login/include/_is_not_logged.php on line 92
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /web/htdocs/www.erreo.eu/home/login/include/_is_not_logged.php on line 354 Utenti registati (364) : Ultimi () utenti connessi: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /web/htdocs/www.erreo.eu/home/login/include/_is_not_logged.php on line 357 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /web/htdocs/www.erreo.eu/home/login/include/_is_not_logged.php on line 423 Could not obtain data information SELECT a.id_plan, b.num_moduli, b.watt, c.resa, c.KWh, c.SSP, b.id_p, d.id_zn, e.zona, MIN( gse_imm_a1 + gse_imm_a2 + gse_imm_a3 ) AS min_gse, MAX( gse_imm_a1 + gse_imm_a2 + gse_imm_a3 ) AS max_gse, MIN( ssp_imm_a1 + ssp_imm_a2 + ssp_imm_a3 ) AS min_imm, MAX( ssp_imm_a1 + ssp_imm_a2 + ssp_imm_a3 ) AS max_imm, MIN( ssp_pre_a1 + ssp_pre_a2 + ssp_pre_a3 ) AS min_pre, MAX( ssp_pre_a1 + ssp_pre_a2 + ssp_pre_a3 ) AS max_pre FROM energy AS a LEFT JOIN plan AS b ON (b.uid = a.id_plan) LEFT JOIN rese AS c ON (c.id_plan = a.id_plan) LEFT JOIN provincie AS d ON ( d.id_p = b.id_p ) LEFT JOIN zone AS e ON ( e.uid = d.id_zn ) WHERE (b.convenzione = 'scambio sul posto' OR b.convenzione = 'omnicomprensiva') AND c.resa > 0 AND a.fdel = 0 AND c.yield > 0 GROUP BY id_plan |
