You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'11 MEDIUMTEXT NOT NULL, \nCelNaz SET(\'ОСГ\', \'Под застройку\', \'Промзона\', \'Другие\'\' at line 6 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \nsuburb MEDIUMTEXT NOT NULL, \nprice MEDIUMTEXT NOT NULL, \noblast MEDIUMTEXT NOT NULL, \n11 MEDIUMTEXT NOT NULL, \nCelNaz SET(\'ОСГ\', \'Под застройку\', \'Промзона\', \'Другие\') NOT NULL, \nDostop SET(\'Асфальт. подъезд\', \'Газ\', \'Электричесиво\', \'Вода\', \'Река\', \'Озеро\', \'Лес\') NOT NULL, \nploshad MEDIUMTEXT NOT NULL, \nploshaddoma MEDIUMTEXT NOT NULL, \nnezhil SET(\'Офисы\', \'Склады\', \'Гаражи\', \'Магазины\', \'Рестораны/Кафе\', \'Прочее\') NOT NULL, \netazh MEDIUMTEXT NOT NULL, \ndopoln SET(\'Паркинг\', \'Охрана\', \'Телефон\', \'Интернет\', \'Лифт\') NOT NULL, \nploschadnezhil MEDIUMTEXT NOT NULL, \nvozrast MEDIUMTEXT NOT NULL, \nnovostroy MEDIUMTEXT NOT NULL, \nprsot MEDIUMTEXT NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;Table \'zemliua_zemliua.jos_hp_temp\' doesn\'t exist SQL=INSERT INTO jos_hp_temp (id, suburb, price) \n SELECT p.id, p.suburb, p.price\n FROM (jos_hp_properties AS p, jos_hp_companies AS c)\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())
