Query:
SELECT `Field_ID` as `id`, `Field_Name` as `name`, `TypeOfData_ID` as `type`, `Format` as `format`, `Description` AS `description`, `NotNull` AS `not_null`, `DefaultState` as `default`, `TypeOfEdit_ID` AS `edit_type`, `System_Table_ID` AS `system_table_id`, `Class_ID` AS `class_id`, IF(`TypeOfData_ID` IN (4, 10), SUBSTRING_INDEX(`Format`, ':', 1), '') AS `table`, 1 AS `search`, `Inheritance` AS `inheritance`, `Extension` as `extension`, `InTableView` AS `in_table_view` FROM `Field` WHERE `Checked` = 1 AND `System_Table_ID` = '1' ORDER BY `Priority`
Error:
Unknown column 'Extension' in 'field list'