A Database Error Occurred

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