Каталог Товаров
Показано из товаров

MySQL Query Error: SELECT BE.ID as ID, BE.CREATED_BY as CREATED_BY, BE.NAME as NAME, BE.CODE as CODE, BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID, FPS0.PROPERTY_36 as PRICE, FPS0.PROPERTY_174 as PRICE_OLD, FPS0.PROPERTY_175 as DISCOUNT, FPS0.PROPERTY_39 as CITY_ID, CT.NAME AS CITY_NAME, CT.CODE AS CITY_CODE, FPS0.PROPERTY_37 as PHOTO, FPS0.PROPERTY_3 as DELIVERY_RUSSIA, FPS0.PROPERTY_2 as DELIVERY_CITY, FPS0.PROPERTY_38 as STATUS, FPS0.PROPERTY_95 as URL, FPS0.PROPERTY_74 as MODER_USER_ID,R.RATE, OD.TEXT as PARAMS_TEXT, U.NAME as SHOP_NAME, U.WORK_CITY as SHOP_WORK_CITY, U.WORK_WWW as SHOP_WORK_WWW, UM.UF_DELIVERY AS SHOP_DELIVERY, UM.UF_GEO AS SHOP_GEO, UM.UF_ALL_CLICK AS SHOP_ALL_CLICK, UM.UF_GOOGLE_UZAB_M AS SHOP_GOOGLE_MOBILE, UM.UF_CHECK_ONLINECONS as CHECK_ONLINECONS, UM.UF_CHECK_FREPHONE as CHECK_FREPHONE, UM.UF_CHECK_ONECLICK as CHECK_ONECLICK FROM ( (SELECT RT.ITEM_ID as ID,RT.RATING as RATE FROM b_pdev_rate_v2_223 RT WHERE SECTION_ID IN ()) UNION ALL (SELECT RO.ITEM_ID as ID,RO.RATING as RATE FROM b_pdev_rate_v2 RO LEFT JOIN b_pdev_rate_v2_223 RT2 ON RT2.ITEM_ID=RO.ITEM_ID WHERE RT2.ITEM_ID IS NULL AND RO.SECTION_ID IN ()) ) as R LEFT JOIN b_iblock_element BE ON BE.ID=R.ID INNER JOIN b_iblock_element_prop_s3 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = R.ID LEFT JOIN b_uts_user UM ON UM.VALUE_ID=BE.CREATED_BY INNER JOIN b_user U ON U.ID=BE.CREATED_BY LEFT JOIN b_pdev_offers_description OD ON OD.USER_ID=BE.CREATED_BY AND OD.XML_ID=BE.OFFER_ID LEFT JOIN b_pdev_company_region DR ON DR.USER_ID=BE.CREATED_BY AND DR.TYPE=2 AND DR.CITY_ID=223 LEFT JOIN b_iblock_element CT ON CT.IBLOCK_ID=6 AND CT.ID=FPS0.PROPERTY_39 WHERE BE.ACTIVE="Y" AND FPS0.PROPERTY_36 > "0" AND ( FPS0.PROPERTY_38 = 32 OR (FPS0.PROPERTY_38 = 30 AND UM.UF_TRUST=14) OR (FPS0.PROPERTY_38 = 86 AND FPS0.PROPERTY_184=32) OR (FPS0.PROPERTY_38 = 86 AND FPS0.PROPERTY_184=30 AND UM.UF_TRUST=14)) AND ( FPS0.PROPERTY_39 = 223 OR ((FPS0.PROPERTY_39!=223 OR DR.ID IS NULL) AND FPS0.PROPERTY_3 IS NOT NULL AND FPS0.PROPERTY_3!=0) OR (DR.ID IS NOT NULL AND (FPS0.PROPERTY_3 IS NULL OR FPS0.PROPERTY_3=0)) ) AND ( U.LAST_LOGIN>=now() - INTERVAL 3 MONTH OR UM.UF_TIMESTAMP_XML_L>=UNIX_TIMESTAMP(now() - INTERVAL 3 MONTH) ) ORDER BY R.RATE DESC LIMIT 0,28[[1064] 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 ')) UNION ALL (SELECT RO.ITEM_ID as ID,RO.RATING as RATE FROM b_pdev_rate_v2 RO L' at line 1]

DB query error.
Please try later.