+7(495) 504-55-93
Москва, ш. Энтузиастов, д.31,с.37
контакты | график работы

Зимняя обувь

Поиск по товару/арт.
Фильтр: по бренду
Введите размер



Error :
Запрос:
SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM (
select  f1.*,f2.name namefirm
        FROM fho_catalogtovar f1
         INNER JOIN fho_cross_table_belonging_multiselect tbm ON f1.id=tbm.idp  , fho_brendcatalog f2 WHERE f1.active=1  AND f2.id=f1.idfirm /* 
                    AND f1.idrazdel IN (
                        select f3.id
                        from fho_tovardirectories f3
                        where f3.idpriv = 166
                        or f1.idrazdel = 166
                    ) */
                      
        /* AND f1.belonging=7/   #Отключен. Заменен на SQL_WHERE*/
         AND f1.idrazdel IN(166)  AND tbm.idpoz = 7/  
        
         
 ORDER BY f1.novinka DESC
) tbl ORDER BY FIELD(tbl.dopsettings, 5, 2,1,3,4)
        /*ORDER BY `created` ASC,   f1.rate  */
        LIMIT 0,24

Ошибка: 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 'ORDER BY f1.novinka DESC ) tbl ORDER BY FIELD(tbl.dopsettings, 5, 2,1,3,4) ' at line 16