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

Access Tailored Employee Benefits Solutions

AccessPay provides specialised and tailored salary packaging and employee benefits services.

What are the key benefits?

Accurate processing of high volume payments within a highly regulated and complex environment
Cost reduction by eliminating the administrative burden of salary packaging and enhancing your ability to reduce staff turnover
Organisational enhancement by providing comprehensive benefits and guidance to support employee’s financial wellbeing

Who is this resource for?

NDS Organisational Members can access this resource through their NDS membership.

Further Information:

AccessPay is a leading provider of salary packaging and employee benefits services to the charitable and not-for-profit sector. Their specialist guidance delivers tailored solutions and maximises benefit opportunities for your employees to support your organisation’s strategic and operational objectives.

They provide reliable, flexible and cost effective salary packaging services that integrate into your client’s overall employee benefits arrangements to further enhance the organisation’s ability to recruit, retain and remunerate employees at all levels.

Contact information

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