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

NDS Legal Helpline

Facilitated by Holman Webb Lawyers, the national helpline allows not-for-profit members a free over-the-phone 15-minute initial consultation on any business-related issue.

What are the key benefits?

Holman Webb lawyers provide legal advice on any business-related issue including governance, intellectual property, contracts and human resources
NDS members can access discounted fees for prolonged consultations
Regularly used as service to obtain a secondary legal opinion or check if something is likely to become an issue in future

Who is this resource for?

NDS Organisational Members (not-for-profit members only).

Further information:

Holman Webb Lawyers will respond to queries within 24 hours (where possible). The helpline operates during business hours (8.30am-6pm, Australian Eastern Time). Members can access 15 minutes free over-the-phone advice per issue.

Contact information

For any enquiries, please contact NDS Membership Team, 02 6283 3205, membership@nds.org.au