Hello everyone! There are 4 fields price_id - price region_id city_id name In the fields region_id and gorod_id can stand NULL or id Regions and cities are connected with ценами. i.e. if the price is not null then the городае and the region is also not null
Not is normal to make the filter search on the name of the product name. If there is a price it should take into account or do not take into account the price. The sql will be like so SELECT ... FROM ... WHERE (price_id IS NULL or price_id=134) and (region_id IN NULL or region_id=4) and ( city_id IS NULL or city_id=2 -- You received this message because you are subscribed to the Google Groups "sphinx-dev" group. To view this discussion on the web visit https://groups.google.com/d/msg/sphinx-dev/-/MTslyy2UVz0J. To post to this group, send email to sphinx-dev@googlegroups.com. To unsubscribe from this group, send email to sphinx-dev+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sphinx-dev?hl=en.
