Remove state filters
Global Menu
Main Menu
Main Menu
Sphinx debug:
SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1734838830),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734838830),1,0) AS is_published_down, IF ((content_state = 1 OR content_state < 1),1,0) AS is_not_archived, *, WEIGHT() AS weight, IF ((featured_start < 1 OR featured_start <= 1734878430) AND (featured_end < 1 OR featured_end >= 1734878430) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@wa_resource_directory_audience \"_service providers_\")') AND `source_filter` IN (6) AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 LIMIT 0, 20

Sphinx debug:

SELECT IF ((publish_up_stamp = 1734838830),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1734878430) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@wa_resource_directory_audience \"_service providers_\")') AND `source_filter` IN (6) AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 LIMIT 0, 20
Sphinx debug:
SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1734838830),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734838830),1,0) AS is_published_down, IF ((content_state = 1 OR content_state < 1),1,0) AS is_not_archived, *, WEIGHT() AS weight, IF ((featured_start < 1 OR featured_start <= 1734878430) AND (featured_end < 1 OR featured_end >= 1734878430) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@wa_resource_directory_audience \"_service providers_\")') AND `source_filter` IN (6) AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 LIMIT 0, 20