Testimonies: All Types of Healing
Arranged by Descending Date [reverse]

FROM: testimony, iahr_all_data

WHERE: showtestimony = 1 AND ((iahr_all_data.local_preferences_id = testimony.healingroomcode) OR (iahr_all_data.iahr_id = testimony.healingroomcode))

ORDERBYCODE: dateofhealing_year DESC, dateofhealing_month DESC, dateofhealing_day DESC

SELECT testimony.id, healingroomcode, dateofhealing, dateofhealing_year, dateofhealing_month, dateofhealing_day, dateentered, recipient_first, recipient_last, textoftestimony, hiddencomments, categories, createdby, hr_name AS local_name, iahr_id AS local_id FROM testimony, iahr_all_data WHERE showtestimony = 1 AND ((iahr_all_data.local_preferences_id = testimony.healingroomcode) OR (iahr_all_data.iahr_id = testimony.healingroomcode)) ORDER BY dateofhealing_year DESC, dateofhealing_month DESC, dateofhealing_day DESC

NOT USED: SELECT count(testimony.id) AS number_of_rows FROM testimony, iahr_all_data WHERE showtestimony = 1 AND ((iahr_all_data.local_preferences_id = testimony.healingroomcode) OR (iahr_all_data.iahr_id = testimony.healingroomcode)) GROUP BY testimony.id

SELECT count(testimony.id) AS number_of_rows FROM testimony, iahr_all_data WHERE showtestimony = 1 AND ((iahr_all_data.local_preferences_id = testimony.healingroomcode) OR (iahr_all_data.iahr_id = testimony.healingroomcode))

SELECT testimony.id, healingroomcode, dateofhealing, dateofhealing_year, dateofhealing_month, dateofhealing_day, dateentered, recipient_first, recipient_last, textoftestimony, hiddencomments, categories, createdby, hr_name AS local_name, iahr_id AS local_id FROM testimony, iahr_all_data WHERE showtestimony = 1 AND ((iahr_all_data.local_preferences_id = testimony.healingroomcode) OR (iahr_all_data.iahr_id = testimony.healingroomcode)) ORDER BY dateofhealing_year DESC, dateofhealing_month DESC, dateofhealing_day DESC

SELECT count(testimony.id) AS number_of_rows FROM testimony, iahr_all_data WHERE showtestimony = 1 AND ((iahr_all_data.local_preferences_id = testimony.healingroomcode) OR (iahr_all_data.iahr_id = testimony.healingroomcode)) LIMIT 1