Get Answers: Helpdesk

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

If you or anyone you know needs help

Lifeline: 13 11 14
MensLine: 1300 789 978
Kids Helpline: 1800 551 800
1800RESPECT: 1800 737 732
National Disability Abuse and Neglect Hotline: 1800 880 052
Aboriginal Family Domestic Violence Hotline: 1800 019 123

Zero Tolerance (an NDS initiative) assists disability service providers to understand, implement and improve practices which safeguard the rights of people
they support.

Find out more about the Royal Commission

Royal Commission website

If you have a question about the Royal Commission, please visit NDS’ Helpdesk.

Questions posted to the Helpdesk are triaged to the staff member with the appropriate expertise and we aim to respond within 72 business hours.