Error Number: 1054
Unknown column 'index.html' in 'where clause'
SELECT COUNT(*) AS `numrows` FROM `ana_immobili` LEFT JOIN `ana_zone` ON `azon_code` = `aimm_zone_code` LEFT JOIN `ana_comuni` ON `acom_code` = `ana_zone`.`azon_comuni_code` LEFT JOIN `tbl_dati_sistema` as `tip_imm` ON `tip_imm`.`tbds_keytab_txt` = `ana_immobili`.`aimm_tipologia_code` and `tip_imm`.`tbds_tblname_txt`='TIP_IMMOB' LEFT JOIN `tbl_dati_sistema` as `stip_imm` ON `stip_imm`.`tbds_keytab_txt` = `ana_immobili`.`aimm_subtipologia_code` and `stip_imm`.`tbds_tblname_txt`='SUBTIP_IMMOB' WHERE `aime_web_flg` = 1 AND `aimm_agenzia_code` = 7 AND `aimm_situazione_code` = 1 AND `aimm_immobile_code` = `index`.`html` AND `aimm_agenzia_code` = 7 AND `aime_web_flg` = 1 AND `aime_web_flg` = 1
Filename: models/Index_model.php
Line Number: 74