Error Report

Error: MySQL: Unknown column 'item_alias' in 'where clause'

Query: SELECT `object_catalog_sklad1`.`item_id` , `object_catalogmaslo`.`item_tree` , `object_catalogmaslo`.`item_public` , `object_catalogmaslo`.`item_created` , `object_catalogmaslo`.`item_modified` , `object_catalogmaslo`.`item_parent_code` , `object_catalogmaslo`.`item_code` , `object_catalog_sklad1`.`item_name` , `object_catalog`.`item_manuf_code` , `object_catalog`.`item_manuf_code_index` , `object_catalog`.`item_analog_code` , `object_catalog_sklad1`.`item_price` , `object_catalog_sklad1`.`item_price1` , `object_catalog_sklad1`.`item_currency_id` , `object_catalog`.`item_manuf` , `object_catalog_sklad1`.`item_quantity` , `object_catalog_sklad1`.`item_quantity1` , `object_catalog_sklad1`.`item_sklad` , `object_catalog_sklad1`.`item_days_to_shipment` , `object_catalog_sklad1`.`item_coming_soon` , `object_catalog_sklad1`.`item_multiplicity` , `object_catalog_sklad1`.`item_sales` , `object_catalog_sklad1`.`item_REF_code` , `object_catalog_sklad1`.`item_REF_manuf` , `object_catalog_sklad1`.`item_REF_sklad` , `object_catalogmaslo`.`item_volume` , `object_catalogmaslo`.`item_viscosity` , `object_catalogmaslo`.`item_oil_type` , `maslo_viscosity_types`.`type_name` AS item_viscosity1 , `maslo_oil_types`.`type_name` AS item_oil_type1 , `object_catalogmaslo`.`item_file` , `object_catalogmaslo`.`item_content` FROM `object_catalogmaslo` INNER JOIN `object_catalog` ON (`object_catalogmaslo`.`item_code` = `object_catalog`.`item_code`) INNER JOIN `object_catalog_sklad1` ON (`object_catalog_sklad1`.`item_code` = `object_catalogmaslo`.`item_code`) INNER JOIN `maslo_viscosity_types` ON (`object_catalogmaslo`.`item_viscosity` = `maslo_viscosity_types`.`type_id`) INNER JOIN `maslo_oil_types` ON (`object_catalogmaslo`.`item_oil_type` = `maslo_oil_types`.`type_id`) WHERE (`object_catalog_sklad1`.`item_quantity` !="0" OR `object_catalog_sklad1`.`item_quantity1` !="0" )AND 1 AND `item_alias` = "3298" AND `object_catalogmaslo`.`item_tree` = "366" AND `object_catalogmaslo`.`item_public` = "1" ORDER BY `object_catalog_sklad1`.`item_sklad` , item_id DESC LIMIT 0, 1


File: /var/www/dias.by/data/www/opt.dias.by/includes/mysql.class.php, Line 146