Бот удаляет конечный запрос, там вообщем сравнение идет как текст, а не как число
dima shevchenko:
SELECT SQL_CALC_FOUND_ROWS msProduct.id, msProduct.type, msProduct.contentType, msProduct.pagetitle, msProduct.longtitle, msProduct.description, msProduct.alias, msProduct.alias_visible, msProduct.link_attributes, msProduct.published, msProduct.pub_date, msProduct.unpub_date, msProduct.parent, msProduct.isfolder, msProduct.introtext, msProduct.richtext, msProduct.template, msProduct.menuindex, msProduct.searchable, msProduct.cacheable, msProduct.createdby, msProduct.createdon, msProduct.editedby, msProduct.editedon, msProduct.deleted, msProduct.deletedon, msProduct.deletedby, msProduct.publishedon, msProduct.publishedby, msProduct.menutitle, msProduct.donthit, msProduct.privateweb, msProduct.privatemgr, msProduct.content_dispo, msProduct.hidemenu, msProduct.class_key, msProduct.context_key, msProduct.content_type, msProduct.uri, msProduct.uri_override, msProduct.hide_children_in_tree, msProduct.show_in_tree, msProduct.properties, Data.article, Data.price, Data.old_price, Data.weight, Data.image, Data.thumb, Data.vendor, Data.made_in, Data.new, Data.popular, Data.favorite, Data.tags, Data.color, Data.size, Data.source, Vendor.name AS vendor.name, Vendor.resource AS vendor.resource, Vendor.country AS vendor.country, Vendor.logo AS vendor.logo, Vendor.address AS vendor.address, Vendor.phone AS vendor.phone, Vendor.fax AS vendor.fax, Vendor.email AS vendor.email, Vendor.description AS vendor.description, Vendor.properties AS vendor.properties, medium.url as medium FROM modx_site_content AS msProduct LEFT JOIN modx_ms2_products Data ON msProduct.id = Data.id LEFT JOIN modx_ms2_vendors Vendor ON Data.vendor=Vendor.id LEFT JOIN modx_ms2_product_files medium ON medium.product_id = msProduct.id AND medium.rank = 0 AND medium.path LIKE '%/medium/%' LEFT JOIN modx_ms2_product_options Year_payment ON Year_payment.product_id = Data.id AND Year_payment.key = 'Year_payment' LEFT JOIN modx_ms2_product_options Cash_take ON Cash_take.product_id = Data.id AND Cash_take.key = 'Cash_take' LEFT JOIN modx_ms2_product_options Cash_back ON Cash_back.product_id = Data.id AND Cash_back.key = 'Cash_back' WHERE ( msProduct.class_key = 'msProduct' AND Year_payment.value >= '99' AND Year_payment.value <= '4250' AND Cash_take.value >= '100000' AND Cash_take.value <= '500000' AND Cash_back.value >= '1' AND Cash_back.value <= '30' AND Year_payment.value != '' AND Cash_take.value != '' AND Cash_back.value != '' AND msProduct.parent IN (3,18,19,20,21,22,23,24,25,26,27,28,29,30) AND msProduct.published = 1 AND msProduct.deleted = 0 ) GROUP BY msProduct.id, medium.url, Cash_back.value, Cash_take.value, Year_payment.value ORDER BY CAST(Cash_back.value AS UNSIGNED INTEGER),CAST(Cash_take.value AS UNSIGNED INTEGER),CAST(Year_payment.value AS UNSIGNED INTEGER) ASC LIMIT 30; Опции для сравнения идут в '' и сравниваются как текст а не как integer