Royal Commission news

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

SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1734758632),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734758632),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 >= 1734798232),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start < 1 OR featured_start <= 1734798232) AND (featured_end < 1 OR featured_end >= 1734798232) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@news \"_news update_\") (@news_tags \"_royal commission_\")') AND `source_filter` IN (1, 2) 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 ORDER BY `is_featured` DESC , publish_up_days_from_now ASC , `extra_rank` DESC LIMIT 0, 20

SELECT IF ((publish_up_stamp = 1734758632),1,0) AS is_published_down, IF ((content_state = 1 OR content_state = 1734798232),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start = 1734798232) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@news \"_news update_\") (@news_tags \"_royal commission_\")') AND `source_filter` IN (1, 2) 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_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 ORDER BY `is_featured` DESC , publish_up_days_from_now ASC , `extra_rank` DESC LIMIT 0, 20

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

Sphinx debug:

SELECT IF ((publish_up_stamp < 1 OR publish_up_stamp <= 1734758632),1,0) AS is_published_up, IF ((publish_down_stamp < 1 OR publish_down_stamp >= 1734758632),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 >= 1734798232),1,0) AS is_event_start_date_stamp, *, WEIGHT() AS weight, IF ((featured_start < 1 OR featured_start <= 1734798232) AND (featured_end < 1 OR featured_end >= 1734798232) AND item_extra_rank > 0,1,0) AS is_featured FROM `com_sphinxsearch_nds_main_index_prod_index` WHERE MATCH('(@news \"_news update_\") (@news_tags \"_royal commission_\")') AND `source_filter` IN (1, 2) AND `is_published_up` = 1 AND `is_published_down` = 1 AND `is_not_archived` = 1 AND `is_event_start_date_stamp` = 1 ORDER BY `is_featured` DESC , publish_up_days_from_now ASC , `extra_rank` DESC  LIMIT 0, 20