mysql errore

Ошибка (errore):
Файл (file): /modules/catalog/catalog.class.php
GET запрос (GET request):/cat.html?itemid=5365
Строка (String): 2703 (kernel->runSQL)
SQL запрос (SQL query):
'SELECT items.id , items.year, items.art, items.name, items.image, items.price_all, items.price, items.price2, items.price_min, items.kolvo, items.color, items.pol, items.harakt, items.poliarizatcia, items.brand, items.country, items.new, items.sale, items.newnew, items.newnewnew, items.desc, perchatki. FROM sf_catalog_catalog1_items AS items LEFT JOIN sf_catalog_items_catalog1_perchatki AS perchatki ON items.ext_id = perchatki.id   LEFT JOIN sf_catalog_catalog1_item2cat AS i2c ON i2c.item_id=items.id WHERE ( i2c.cat_id=27 AND  items.`available`=1 AND items.`group_id`=1) AND (true) LIMIT 0, 25'

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 'FROM sf_catalog_catalog1_items AS items LEFT JOIN sf_catalog_items_catalog1_perc' at line 1

каким-то образом прицепляется perchatki. перед FROM из другой таблицы

Comments (3)