(mercury): SELECT id, issue_date, volume_no, issue_no, DATE_FORMAT(issue_date, '%Y-%c-%e') AS current_issue_document_date FROM mc_cms_issue_dc WHERE current = '1'  

(mercury): SELECT id, issue_date, volume_no, issue_no, DATE_FORMAT(issue_date, '%Y-%c-%e') AS current_issue_document_date FROM mc_cms_issue_dc_ca WHERE current = '1'  

(mercury): SELECT a.id FROM mc_cms_article_dc a WHERE a.issue_dc_ca <= '1034' AND a.issue_dc_ca <> 0 AND a.issue_dc_ca IS NOT NULL AND a.title_ca <> '' AND a.title_ca IS NOT NULL AND a.body_ca <> '' AND a.body_ca IS NOT NULL AND (a.body = '' OR a.body IS NULL) AND a.id = '44170'  

(mercury): SELECT a1.first_name AS a1_first_name, a1.last_name AS a1_last_name, a1.degree AS a1_degree, a1.dc_staff_editor_title AS a1_dc_staff_editor_title, a1.dc_source_type AS a1_source_type, a1.dc_bio AS a1_bio, a1.id AS a1_id, a1.dc_talk_forum_url AS a1_dc_talk_forum_url, a2.first_name AS a2_first_name, a2.last_name AS a2_last_name, a2.degree AS a2_degree, a2.dc_staff_editor_title AS a2_dc_staff_editor_title, a2.dc_source_type AS a2_source_type, a2.dc_bio AS a2_bio, a2.id AS a2_id, a3.first_name AS a3_first_name, a3.last_name AS a3_last_name, a3.degree AS a3_degree, a3.dc_staff_editor_title AS a3_dc_staff_editor_title, a3.dc_source_type AS a3_source_type, a3.dc_bio AS a3_bio, a3.id AS a3_id, a4.first_name AS a4_first_name, a4.last_name AS a4_last_name, a4.degree AS a4_degree, a4.dc_staff_editor_title AS a4_dc_staff_editor_title, a4.dc_source_type AS a4_source_type, a4.dc_bio AS a4_bio, a4.id AS a4_id, a5.first_name AS a5_first_name, a5.last_name AS a5_last_name, a5.degree AS a5_degree, a5.dc_staff_editor_title AS a5_dc_staff_editor_title, a5.dc_source_type AS a5_source_type, a5.dc_bio AS a5_bio, a5.id AS a5_id, ga1.first_name AS ga1_first_name, ga1.last_name AS ga1_last_name, ga1.degree AS ga1_degree, ga1.dc_staff_editor_title AS ga1_dc_staff_editor_title, ga1.dc_source_type AS ga1_source_type, ga1.dc_bio AS ga1_bio, ga1.id AS ga1_id, ga2.first_name AS ga2_first_name, ga2.last_name AS ga2_last_name, ga2.degree AS ga2_degree, ga2.dc_staff_editor_title AS ga2_dc_staff_editor_title, ga2.dc_source_type AS ga2_source_type, ga2.dc_bio AS ga2_bio, ga2.id AS ga2_id, ga3.first_name AS ga3_first_name, ga3.last_name AS ga3_last_name, ga3.degree AS ga3_degree, ga3.dc_staff_editor_title AS ga3_dc_staff_editor_title, ga3.dc_source_type AS ga3_source_type, ga3.dc_bio AS ga3_bio, ga3.id AS ga3_id, ga4.first_name AS ga4_first_name, ga4.last_name AS ga4_last_name, ga4.degree AS ga4_degree, ga4.dc_staff_editor_title AS ga4_dc_staff_editor_title, ga4.dc_source_type AS ga4_source_type, ga4.dc_bio AS ga4_bio, ga4.id AS ga4_id, ga5.first_name AS ga5_first_name, ga5.last_name AS ga5_last_name, ga5.degree AS ga5_degree, ga5.dc_staff_editor_title AS ga5_dc_staff_editor_title, ga5.dc_source_type AS ga5_source_type, ga5.dc_bio AS ga5_bio, ga5.id AS ga5_id, DATE_FORMAT(i.issue_date, '%Y-%c-%e') AS document_date, i.year AS issue_year, e.abbrev_name_google_ad_manager, a.issue_nw, a.dcpi_placement FROM mc_cms_article_dc a LEFT JOIN mc_cms_issue_dc i ON a.issue_dc = i.id LEFT JOIN mc_editorial_topic e ON a.editorial_primary = e.id LEFT JOIN mc_cms_author_columnist a1 ON (a.source_1 = a1.id) LEFT JOIN mc_cms_author_columnist a2 ON (a.source_2 = a2.id) LEFT JOIN mc_cms_author_columnist a3 ON (a.source_3 = a3.id) LEFT JOIN mc_cms_author_columnist a4 ON (a.source_4 = a4.id) LEFT JOIN mc_cms_author_columnist a5 ON (a.source_5 = a5.id) LEFT JOIN mc_cms_author_columnist ga1 ON (a.guest_source_1 = ga1.id) LEFT JOIN mc_cms_author_columnist ga2 ON (a.guest_source_2 = ga2.id) LEFT JOIN mc_cms_author_columnist ga3 ON (a.guest_source_3 = ga3.id) LEFT JOIN mc_cms_author_columnist ga4 ON (a.guest_source_4 = ga4.id) LEFT JOIN mc_cms_author_columnist ga5 ON (a.guest_source_5 = ga5.id) WHERE a.id = '44170'  

(mercury): SELECT mc_cms_article_dc.crr_topic AS crr_topic_id, CONCAT_WS(" ",l1.last_name,l1.first_name) AS source_1, CONCAT_WS(" ",l2.last_name,l2.first_name) AS source_2, CONCAT_WS(" ",l3.last_name,l3.first_name) AS source_3, CONCAT_WS(" ",l4.last_name,l4.first_name) AS source_4, CONCAT_WS(" ",l5.last_name,l5.first_name) AS source_5, CONCAT_WS(" ",l6.last_name,l6.first_name) AS guest_source_1, CONCAT_WS(" ",l7.last_name,l7.first_name) AS guest_source_2, CONCAT_WS(" ",l8.last_name,l8.first_name) AS guest_source_3, CONCAT_WS(" ",l9.last_name,l9.first_name) AS guest_source_4, CONCAT_WS(" ",l10.last_name,l10.first_name) AS guest_source_5, mc_cms_article_dc.title, mc_cms_article_dc.sub_title, mc_cms_article_dc.title_ca, mc_cms_article_dc.sub_title_ca, mc_cms_article_dc.meta_keywords, mc_cms_article_dc.meta_description, l11.title AS issue_dc, l12.title AS issue_dc_ca, mc_cms_article_dc.body, mc_cms_article_dc.body_ca, mc_cms_article_dc.online_only, mc_cms_article_dc.breaking_news, mc_cms_article_dc.online_only_breaking_news_date, mc_cms_article_dc.use_submitted_by, mc_cms_article_dc.author_string, mc_cms_article_dc.editorial_primary, mc_cms_article_dc.no_index_meta, mc_cms_article_dc.banner_override, mc_cms_article_dc.banner_override_text, mc_cms_article_dc.dcpi_featured, mc_cms_article_dc.dcpi_category, mc_cms_article_dc.google_one_off FROM mc_cms_article_dc LEFT JOIN mc_cms_author_columnist l1 ON (l1.id = mc_cms_article_dc.source_1) LEFT JOIN mc_cms_author_columnist l2 ON (l2.id = mc_cms_article_dc.source_2) LEFT JOIN mc_cms_author_columnist l3 ON (l3.id = mc_cms_article_dc.source_3) LEFT JOIN mc_cms_author_columnist l4 ON (l4.id = mc_cms_article_dc.source_4) LEFT JOIN mc_cms_author_columnist l5 ON (l5.id = mc_cms_article_dc.source_5) LEFT JOIN mc_cms_author_columnist l6 ON (l6.id = mc_cms_article_dc.guest_source_1) LEFT JOIN mc_cms_author_columnist l7 ON (l7.id = mc_cms_article_dc.guest_source_2) LEFT JOIN mc_cms_author_columnist l8 ON (l8.id = mc_cms_article_dc.guest_source_3) LEFT JOIN mc_cms_author_columnist l9 ON (l9.id = mc_cms_article_dc.guest_source_4) LEFT JOIN mc_cms_author_columnist l10 ON (l10.id = mc_cms_article_dc.guest_source_5) LEFT JOIN mc_cms_issue_dc l11 ON (l11.id = mc_cms_article_dc.issue_dc) LEFT JOIN mc_cms_issue_dc_ca l12 ON (l12.id = mc_cms_article_dc.issue_dc_ca) WHERE mc_cms_article_dc.id = 44170 AND mc_cms_article_dc.active = 1  

(mercury): SELECT ls.name AS mediatype, m.id AS mediasetid, m.caption, sl.slotnumber, sl.nav, m.title, mf.filename, mf.id, mf.width, mf.height, m.thumb_filename, m.thumb_width, m.thumb_height, m.alt_tag, m.hideborder, m.link_url, m.open_in_new_window, mfl.filename AS l_filename, mfl.id AS l_id, mfl.width AS l_width, mfl.height AS l_height, mfl2.filename AS m_filename, mfl2.id AS m_id, mfl2.width AS m_width, mfl2.height AS m_height FROM mc_mediaslot sl, mc_ls_mediatype ls, mc_mediaset m, mc_cms_article_dc sec, mc_mediasetfile mf LEFT JOIN mc_mediasetfile mfl ON (mfl.mediasetid = m.id AND mfl.filenumber = 2) LEFT JOIN mc_mediasetfile mfl2 ON (mfl2.mediasetid = m.id AND mfl2.filenumber = 1) WHERE sec.id = sl.itemid AND m.id = sl.mediasetid AND mf.mediasetid = m.id AND m.mediatype = ls.id AND sl.itemid = '44170' AND sl.itemtype = 'ARC' AND mf.filenumber = 1 ORDER BY ls.name, sl.slotnumber  

(mercury): SELECT id, urllink, urlcaption, urltitle FROM mc_urllink WHERE section = 'ARC' AND itemid = '44170' AND urllink IS NOT NULL ORDER BY id  

(mercury): SELECT abbrev_name FROM mc_editorial_topic WHERE id = '15'  
Australian DC Visits Life College



Dynamic Chiropractic – March 15, 1991, Vol. 09, Issue 06

Australian DC Visits Life College

By Editorial Staff

Australian chiropractor Dr. Rod Bonello, president of Sydney College of Chiropractic, visited the United States to help Life College unveil its newly expanded campus, and to observe American chiropractic education.

A 1980 graduate of Sydney College of Chiropractic, Dr. Bonello explained, "Education in Australia is quite different. We have smaller institutions, and we share our facilities. It is very encouraging to see such fine facilities at Life College devoted to chiropractic."

The Sydney College of Chiropractic recently became the Centre for Chiropractic Studies within MacQuaire University. The Centre will work in conjunction with the University's School of Biological Studies. MacQuaire University does not have a medical school. The Sydney College is the largest health discipline at the university.

"To gain academic respect for the profession (chiropractic) in Australia, we needed to become affiliated with a university," said Dr. Bonello. He reports that in January, 1992 the college will relocate to the MacQuaire campus; the official name will be the Centre for Chiropractic and Osteopathy. In Australia, osteopathy is similar in philosophy to chiropractic. Manipulation is used but drugs are not.

Post Comments
Share |

Do you consult with a tax advisor (CPA, etc.) year-round, or only during tax season?
Year-round
Tax season only