SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1734760144),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734760144),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 <= 1734799745) AND (featured_end < 1 OR featured_end >= 1734799745) 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 = 1734760144),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1734799745) 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 <= 1734760144),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734760144),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 <= 1734799745) AND (featured_end < 1 OR featured_end >= 1734799745) 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 = 1734760144),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1734799745) 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 <= 1734760144),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734760144),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 >= 1734799744),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start < 1 OR featured_start <= 1734799745) AND (featured_end < 1 OR featured_end >= 1734799745) 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 = 1734760144),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1734799744),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start = 1734799745) 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 <= 1734760774),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734760774),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 <= 1734800374) AND (featured_end < 1 OR featured_end >= 1734800374) 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 = 1734760774),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1734800374) 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

Member webinar: Budget Briefing with Laurie Leigh

White background with blue text says Budget Briefing with NDS CEO Laurie Leigh. On either side of the text is a green background with outlines of piggy banks. A bronze sticker saying NDS Member Exclusive Webinar is on the top right of the image.

This is an exclusive member-only resource available to management and staff of NDS Organisational Members and Associates. It is most relevant for CEOs and senior management.Â

Webinar running time: 57:48 mins

For any enquiries, please contact Emerson Riley, Membership Services Officer, membership@nds.org.au, 02 6283 3205

Can't sign in? Become an NDS member today

Create a website account
Follow the emailed verification link
Complete your membership application

Start your application Membership information

Join now

Latest Resources

Member webinar: Budget Briefing with Laurie Leigh

Can't sign in? Become an NDS member today

Sign in to continue and access member only content