(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 = '45143'  

(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 = '45143'  

(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 = 45143 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 = '45143' 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 = '45143' AND urllink IS NOT NULL ORDER BY id  

(mercury): SELECT abbrev_name FROM mc_editorial_topic WHERE id = '28'  
Project Hope Day Comes to Orange County, California



Dynamic Chiropractic – March 28, 1990, Vol. 08, Issue 07

Project Hope Day Comes to Orange County, California

By Editorial Staff

DC: Dr. Porteous, what exactly is Project Hope?

Dr. Porteous: Food for the hungry! Project H.O.P.E. (Helping Other People Eat) was doctors of chiropractic and their patients collecting food and other items for the homeless and needy. It was really a day when people were helping people in their own neighborhoods. The project was really very simple. On February 14, Valentine's Day, patients, their families and relatives donated non-perishable food items. In return, the participating doctor offered exam and/or treatment at no cost.

Our purpose was to collect non-perishable foods and items that could be utilized by the literally hundreds of thousands of homeless people in California. Here in Orange County, over 27 chiropractic practices participated. The Food Distribution Center of Orange County estimated four to five thousand pounds of food was collected and distributed to the homeless of Orange County -- a direct result of dedicated doctors, staff and hundreds of patients. I would particularly like to express my very special appreciation for Pat Ball from the Orange County Food Distribution Organization. She really made the project a success. If it wasn't for her we wouldn't have had barrels in all the offices and all the food picked up and distributed. She really played a vital role in the success of our project.

DC: How did the idea for this project Hope Day in California come about?

Dr. Porteous: Project Hope started by the Santa Monica Chiropractic Society last year and has spread throughout California. The project is supported by the California Chiropractic Association through its county societies. The concept is not a new idea; many doctors have collected food for the less fortunate over the years. Dr. Slusher's Chiropractic Centers have collected food and toys twice a year for as long as I can recall.

"DC:" In getting feed-back from the other 27 chiropractic offices, what do you think about the overall impact chiropractic had on the general community in Orange County, California?

Dr. Porteous: This was the first year and because of this, we can call it a very successful outcome. Everyone benefits from this type of project. Several offices reported serving as many as thirty new patients. The Orange County Chiropractic Society had sent out press releases to inform the community about the effort and the turnout was wonderful. People who didn't take advantage of chiropractic services found their way to chiropractic offices to donate food.

I believe that the community was made aware of the chiropractors' concern and commitment to this social challenge. Interestingly enough, due to some postal shortcomings, we were unable to notify all 800 plus chiropractors in Orange County of Project Hope. We are confident that next year we could have in excess of 100 to 200 offices involved. We did get a marked response by chiropractors saying, "Oh, we would have loved to have participated in Project Hope, but we just didn't get the information in time." We are very encouraged at hearing from so many doctors after the fact. They're saying, "Gee, next year we definitely want to become involved." We have decided to make this an annual program.

DC: And, what are your plans for next year? Do you have any specific dates in mind for another Project Hope Day?

Dr. Porteous: We are definitely going to repeat the February 14 Valentine's Day. But because of the serious need for food and non-perishable items by the Orange County Food Distribution Center, (this organization distributes it to all the major charities) we are working on a strategy to have three dates a year. We will have a Hope Day three times a year. We are just finalizing the plans right now. And we hope that those dates would be projected out far enough that it would be convenient for more doctors to participate.

DC: What should a doctor do who is interested in participating next year?

Dr. Porteous: We are hoping that we will have workshops that will instruct the doctors on how to properly participate in the program, as well making audiocassette or videocassette tapes so that doctors can get the information and participate. With this kind of turnout, we just feel that we obviously have hit a responsive cord in the chiropractic profession, and so we are going to take advantage of it. The need is year round, so we are going to look for a consistent effort on behalf of the profession (at least here in Orange County) to feed the hungry. I would like to invite any doctor of chiropractic anywhere in the United States to write and I would be glad to give them information on how they can participate or how they can have their own special Hope Day, wherever they are. You don't need anything other than a Big Heart and committing the day to it! We are hoping that we will be able to synthesize all the information down into a brief audio cassette that we would be able to give to any doctor anywhere. A doctor does not have to practice here in Orange County to participate. I invite them to write us so that we can get them involved.

Brian Porteous, D.C.
2nd Vice President
Orange County Chiropractic Society
P.O. Box 16397
Irvine, CA, 92713
(714) 474-2188

Post Comments
Share |

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