Sql sorgu çalıştırırken hata alıyorum

Aşağıda eklediğim sorguda hata nerede arkadaşlar çalıştır dediğimde hata alıyorum..
-- Tablo için tablo yapısı `emlak`
--

CREATE TABLE IF NOT EXISTS 'emlak' (
`id` int(11) NOT NULL AUTO_INCREMENT,
`durum` int(100) NOT NULL,
`emlak` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`emlaktipi` int(100) NOT NULL,
`link` varchar(250) COLLATE utf8_turkish_ci NOT NULL,
`oda` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`isinma` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`kat` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`ilce` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`il` varchar(200) COLLATE utf8_turkish_ci NOT NULL,
`fiyat` varchar(200) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
`izlenme` int(40) NOT NULL DEFAULT '0',
`kredi` int(10) NOT NULL DEFAULT '0',
`dubleks` int(10) NOT NULL DEFAULT '0',
`tersdubleks` int(10) NOT NULL DEFAULT '0',
`catidubleks` int(10) NOT NULL DEFAULT '0',
`tripleks` int(10) NOT NULL DEFAULT '0',
`terstripleks` int(10) NOT NULL DEFAULT '0',
`terasli` int(10) NOT NULL DEFAULT '0',
`bahceli` int(10) NOT NULL DEFAULT '0',
`celikkapi` int(10) NOT NULL DEFAULT '0',
`dusakabin` int(10) NOT NULL DEFAULT '0',
`ciftbanyo` int(10) NOT NULL DEFAULT '0',
`jakuzi` int(10) NOT NULL DEFAULT '0',
`somine` int(10) NOT NULL DEFAULT '0',
`mobilya` int(10) NOT NULL DEFAULT '0',
`beyazesya` int(10) NOT NULL DEFAULT '0',
`ankastre` int(10) NOT NULL DEFAULT '0',
`deniz` int(10) NOT NULL DEFAULT '0',
`bogaz` int(10) NOT NULL DEFAULT '0',
`doga` int(10) NOT NULL DEFAULT '0',
`siteici` int(10) NOT NULL DEFAULT '0',
`deprem` int(10) NOT NULL DEFAULT '0',
`asansor` int(10) NOT NULL DEFAULT '0',
`jenerator` int(10) NOT NULL DEFAULT '0',
`su` int(10) NOT NULL DEFAULT '0',
`hidrofor` int(10) NOT NULL DEFAULT '0',
`uydu` int(10) NOT NULL DEFAULT '0',
`kablotv` int(10) NOT NULL DEFAULT '0',
`guvenlik` int(10) NOT NULL DEFAULT '0',
`kapici` int(10) NOT NULL DEFAULT '0',
`otopark` int(10) NOT NULL DEFAULT '0',
`kapaliotopark` int(10) NOT NULL DEFAULT '0',
`cocukparki` int(10) NOT NULL DEFAULT '0',
`yanginmerdiveni` int(10) NOT NULL DEFAULT '0',
`havuz` int(10) NOT NULL DEFAULT '0',
`panjur` int(10) NOT NULL DEFAULT '0',
`pvc` int(10) NOT NULL DEFAULT '0',
`aluminyum` int(10) NOT NULL DEFAULT '0',
`ciftkatcam` int(10) NOT NULL DEFAULT '0',
`balkon` int(10) NOT NULL DEFAULT '0',
`alarm` int(10) NOT NULL DEFAULT '0',
`kartonpiyer` int(10) NOT NULL DEFAULT '0',
`spotisik` int(10) NOT NULL DEFAULT '0',
`klima` int(10) NOT NULL DEFAULT '0',
`ytavan` int(10) NOT NULL DEFAULT '0',
`detay` text COLLATE utf8_turkish_ci NOT NULL,
`m2` int(40) NOT NULL DEFAULT '0',
`onay` int(10) NOT NULL DEFAULT '0',
`mahalle` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
`sokak` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=123 ;


-- Tablo için tablo yapısı `emlak`
--

CREATE TABLE IF NOT EXISTS emlak (
id int(11) NOT NULL AUTO_INCREMENT,
durum int(100) NOT NULL,
emlak varchar(200) COLLATE utf8_turkish_ci NOT NULL,
emlaktipi int(100) NOT NULL,
link varchar(250) COLLATE utf8_turkish_ci NOT NULL,
oda varchar(200) COLLATE utf8_turkish_ci NOT NULL,
isinma varchar(200) COLLATE utf8_turkish_ci NOT NULL,
kat varchar(200) COLLATE utf8_turkish_ci NOT NULL,
ilce varchar(200) COLLATE utf8_turkish_ci NOT NULL,
il varchar(200) COLLATE utf8_turkish_ci NOT NULL,
fiyat varchar(200) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
izlenme int(40) NOT NULL DEFAULT '0',
kredi int(10) NOT NULL DEFAULT '0',
dubleks int(10) NOT NULL DEFAULT '0',
tersdubleks int(10) NOT NULL DEFAULT '0',
catidubleks int(10) NOT NULL DEFAULT '0',
tripleks int(10) NOT NULL DEFAULT '0',
terstripleks int(10) NOT NULL DEFAULT '0',
terasli int(10) NOT NULL DEFAULT '0',
bahceli int(10) NOT NULL DEFAULT '0',
celikkapi int(10) NOT NULL DEFAULT '0',
dusakabin int(10) NOT NULL DEFAULT '0',
ciftbanyo int(10) NOT NULL DEFAULT '0',
jakuzi int(10) NOT NULL DEFAULT '0',
somine int(10) NOT NULL DEFAULT '0',
mobilya int(10) NOT NULL DEFAULT '0',
beyazesya int(10) NOT NULL DEFAULT '0',
ankastre int(10) NOT NULL DEFAULT '0',
deniz int(10) NOT NULL DEFAULT '0',
bogaz int(10) NOT NULL DEFAULT '0',
doga int(10) NOT NULL DEFAULT '0',
siteici int(10) NOT NULL DEFAULT '0',
deprem int(10) NOT NULL DEFAULT '0',
asansor int(10) NOT NULL DEFAULT '0',
jenerator int(10) NOT NULL DEFAULT '0',
su int(10) NOT NULL DEFAULT '0',
hidrofor int(10) NOT NULL DEFAULT '0',
uydu int(10) NOT NULL DEFAULT '0',
kablotv int(10) NOT NULL DEFAULT '0',
guvenlik int(10) NOT NULL DEFAULT '0',
kapici int(10) NOT NULL DEFAULT '0',
otopark int(10) NOT NULL DEFAULT '0',
kapaliotopark int(10) NOT NULL DEFAULT '0',
cocukparki int(10) NOT NULL DEFAULT '0',
yanginmerdiveni int(10) NOT NULL DEFAULT '0',
havuz int(10) NOT NULL DEFAULT '0',
panjur int(10) NOT NULL DEFAULT '0',
pvc int(10) NOT NULL DEFAULT '0',
aluminyum int(10) NOT NULL DEFAULT '0',
ciftkatcam int(10) NOT NULL DEFAULT '0',
balkon int(10) NOT NULL DEFAULT '0',
alarm int(10) NOT NULL DEFAULT '0',
kartonpiyer int(10) NOT NULL DEFAULT '0',
spotisik int(10) NOT NULL DEFAULT '0',
klima int(10) NOT NULL DEFAULT '0',
ytavan int(10) NOT NULL DEFAULT '0',
detay text COLLATE utf8_turkish_ci NOT NULL,
m2 int(40) NOT NULL DEFAULT '0',
onay int(10) NOT NULL DEFAULT '0',
mahalle varchar(150) COLLATE utf8_turkish_ci NOT NULL,
sokak varchar(150) COLLATE utf8_turkish_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=123;

Teşekkür ederim buldum sorunu
CREATE TABLE IF NOT EXISTS `emlak`