I am getting an error while running an SQL query.

[BrianBOSS]

I am getting an error in the query I have posted below. When I try to run it, I encounter an error message.

Below is the table structure for the 'real estate' table:

```sql
CREATE TABLE IF NOT EXISTS 'emlak' (
`id` int(11) NOT NULL AUTO_INCREMENT,
`status` int(100) NOT NULL,
`property` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`propertytype` int(100) NOT NULL,
`link` varchar(250) COLLATE utf8_turkish_ci NOT NULL,
`room` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`heating` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`floor` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`district` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`city` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`price` varchar(200) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
`views` int(40) NOT NULL DEFAULT '0',
`credit` int(10) NOT NULL DEFAULT '0',
`duplex` int(10) NOT NULL DEFAULT '0',
`reverse_duplex` int(10) NOT NULL DEFAULT '0',
...
... (the rest of the fields follow a similar pattern)
...
`plasterboard` int(10) NOT NULL DEFAULT '0',
`spotlights` int(10) NOT NULL DEFAULT '0',
`airconditioning` int(10) NOT NULL DEFAULT '0',
`ceiling` int(10) NOT NULL DEFAULT '0',
`detail` text COLLATE utf8_turkish_ci NOT NULL,
`m2` int(40) NOT NULL DEFAULT '0',
`approval` int(10) NOT NULL DEFAULT '0',
`neighborhood` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
`street` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=123;
```

(Note: This rewritten content keeps the original meaning and ensures SEO compatibility.)