SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1735790835),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1735790835),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 <= 1735830435) AND (featured_end < 1 OR featured_end >= 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_news_\")') AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 ORDER BY publish_up_days_from_now ASC , `title_ordering` ASC , `extra_rank` DESC LIMIT 0, 3

SELECT IF ((publish_up_stamp = 1735790835),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_news_\") (@type \"_news_\")') 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 ORDER BY publish_up_days_from_now ASC , `title_ordering` ASC , `extra_rank` DESC LIMIT 0, 3

SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1735790835),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1735790835),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 <= 1735830435) AND (featured_end < 1 OR featured_end >= 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_resources_\")') AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 ORDER BY publish_up_days_from_now ASC , `title_ordering` ASC , `extra_rank` DESC LIMIT 0, 3

SELECT IF ((publish_up_stamp = 1735790835),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_resources_\") (@type \"_resources_\")') 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 ORDER BY publish_up_days_from_now ASC , `title_ordering` ASC , `extra_rank` DESC LIMIT 0, 3

SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1735790835),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1735790835),1,0) AS is_published_down, IF ((content_state = 1 OR content_state < 1),1,0) AS is_not_archived, IF ((event_start_date_stamp < 1 OR event_start_date_stamp >= 1735830435),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start < 1 OR featured_start <= 1735830435) AND (featured_end < 1 OR featured_end >= 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_events and training_\")') AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_event_start_date_stamp` = 1 ORDER BY publish_up_days_from_now ASC , `title_ordering` ASC , `extra_rank` DESC LIMIT 0, 3

SELECT IF ((publish_up_stamp = 1735790835),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1735830435),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start = 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_events and training_\") (@type \"_events and training_\")') AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_event_start_date_stamp` = 1 AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_event_start_date_stamp` = 1 ORDER BY publish_up_days_from_now ASC , `title_ordering` ASC , `extra_rank` DESC LIMIT 0, 3

Latest Resources

Sphinx debug:

SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1735790835),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1735790835),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 <= 1735830435) AND (featured_end < 1 OR featured_end >= 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_resources_\")') AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 ORDER BY publish_up_days_from_now ASC , `extra_rank` DESC  LIMIT 0, 3

Sphinx debug:

SELECT IF ((publish_up_stamp = 1735790835),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1735830435) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@type \"_resources_\") (@type \"_resources_\")') 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 ORDER BY publish_up_days_from_now ASC , `extra_rank` DESC  LIMIT 0, 3

PACE: What you need to know

In our recent webinars on PACE and the upcoming rollout, members raised some questions that were provided to the NDIA for follow up. The following is their response.

PACE: Frequently asked questions

The NDIA has also created a general list of frequently asked questions to assist providers in their transition.

Latest Resources

PACE: What you need to know

Can't sign in? Become an NDS member today

Sign in to continue and access member only content