A Database Error Occurred

Error Number: 1054

Unknown column 'place.place_id' in 'where clause'

SELECT `equipment`.`equipment_id`, `equipment_type`, `eq_name`, `model`, `manufac`.`vendor_name` as `manufacturer`, `supp`.`vendor_name` as `supplier`, `serial_number`, `mac_address`, `asset_number`, `donor`.`vendor_name` as `donor`, `proc`.`vendor_name` as `procured_by`, `equipment_procurement_type`.`procurment_type`, FORMAT(cost, 2, 'en_IN') as cost_INR, `invoice_number`, DATE_FORMAT(purchase_order_date, '%d %b %Y') as purchase_order_date, DATE_FORMAT(invoice_date, '%d %b %Y') as invoice_date, DATE_FORMAT(purchase_order_date, '%d %b %Y') as purchase_order_date, DATE_FORMAT(supply_date, '%d %b %Y') as supply_date, DATE_FORMAT(installation_date, '%d %b %Y') as installation_date, DATE_FORMAT(warranty_start_date, '%d %b %Y') as warranty_start_date, DATE_FORMAT(warranty_end_date, '%d %b %Y') as warranty_end_date, `journal_type`, `journal_number`, DATE_FORMAT(journal_date, '%d %b %Y') as journal_date, `address`, `place`, `custodian` as `user`, DATE_FORMAT(delivery_date, '%d %b %Y') as delivery_date, `working_status`, `equipment`.`equipment_id` as `equipment_ID` FROM `equipment` LEFT JOIN `equipment_type` ON `equipment_type`.`equipment_type_id` = `equipment`.`equipment_type_id` LEFT JOIN `equipment_procurement_type` ON `equipment_procurement_type`.`equipment_procurement_type_id` = `equipment`.`equipment_procurement_type_id` LEFT JOIN `vendor` as `manufac` ON `manufac`.`vendor_id` = `equipment`.`manufacturer_id` LEFT JOIN `vendor` as `supp` ON `supp`.`vendor_id` = `equipment`.`supplier_id` LEFT JOIN `vendor` as `proc` ON `proc`.`vendor_id` = `equipment`.`procured_by_id` LEFT JOIN `vendor` as `donor` ON `donor`.`vendor_id` = `equipment`.`donor_id` LEFT JOIN `journal_type` ON `journal_type`.`journal_type_id` = `equipment`.`journal_type_id` LEFT JOIN `equipment_functional_status` ON `equipment_functional_status`.`functional_status_id` = `equipment`.`functional_status_id` LEFT JOIN (SELECT * FROM (SELECT equipment_id, place.place, vendor_name as custodian, equipment_location_log.delivery_date as delivery_date, address FROM equipment_location_log LEFT JOIN vendor ON equipment_location_log.vendor_id = vendor.vendor_id LEFT JOIN place ON equipment_location_log.place_id = place.place_id ORDER BY delivery_date desc) as ordrd GROUP BY delivery_date) as eq_loc_log ON `eq_loc_log`.`equipment_id` = `equipment`.`equipment_id` WHERE LOWER(equipment_type.equipment_type) = 'computers' AND `place`.`place_id` IS NULL ORDER BY `eq_name` ASC

Filename: models/Equipment_model.php

Line Number: 200