New user? Sign up here |
In Brief: August 10, 2018

Inside This Issue: Highlights from the 2018 International AIDS Conference in Amsterdam, The Netherlands. 

In Brief  is NEAETC's news service covering the latest developments and educational resources about HIV, hepatitis, health disparities, and related topics. To subscribe, please click HERE.  

Highlights from the 2018 International AIDS Conference 

The 2018 International AIDS Conference (AIDS 2018) took place in Amsterdam, the Netherlands, between July 23 and 27.  This biennial event is the largest conference on any global health issue in the world. The theme of AIDS 2018 was “Breaking Barriers Building Bridges” – designed to draw attention to the need for rights-based approaches to more effectively reach key populations, including in Eastern Europe and Central Asia and the North-African/Middle Eastern regions where epidemics are growing.  

This issue of In Brief is devoted to highlights from AIDS 2018 in the form of headlines from the HIV, medical, and scientific press, together with links to more detailed coverage.  For your convenience, we have curated the headlines by topic, so that you may quickly review important developments and then explore in depth the news of greatest interest to you. 

Video Sessions from AIDS 2018

The AIDS 2018 YouTube Channel includes videos of many presentations, daily summaries, and highlights from the conference.  As this newsletter went to press, new content was still being added to the page.

Daily Summaries from AIDS 2018

Rapporteur Summaries: This page on the official AIDS 2018 site has links to daily summaries from the five main conference tracks: basic and translational research; clinical research; epidemiology and prevention research; social and political research, law, policy, and human rights; and implementation research, economics, systems, and synergies with other health and development sectors. Summaries are also provided for community and leadership activities.

Blog Posts and Videos from HIV.gov: The Department of Health and Human Services HIV.gov site has published a series of blog posts and associated videos summarizing news from AIDS 2018:

Live from AIDS 2018 with HRSA’s Harold Phillips

New HIV Research Findings from AIDS 2018 with NIH’s Dr. Carl Dieffenbach

New Data Show Dramatic Progress in Namibia Toward HIV Epidemic Control and Substantial Gaps in Cote d'Ivoire and Cameroon

Elton John AIDS Foundation and PEPFAR Reaffirm Commitments to HIV Support for Key Populations

Fauci: HIV Remission Free of Antiretroviral Therapy Is a Feasible Goal

Multi-Disease Health Fairs, Universal "Test and Treat" Help East African Communities Achieve HIV Benchmarks

Live from AIDS 2018 with USAID’s Polly Dunford

CDC’s Hank Tomlinson Live from AIDS 2018 on Successes in the Global Response to HIV

NIH’s Dr. Carl Dieffenbach Shares Research Highlights from the Second Day of AIDS 2018

CDC’s Eugene McCray Discusses HIV Prevention Advances from AIDS 2018

Ambassador Birx Discusses PEPFAR’s 15th Anniversary and Highlights of AIDS 2018

Research Highlights Wrap-up from AIDS 2018 with NIH’s Dr. Carl Dieffenbach

Really Rapid Review: International AIDS Conference 2018, Amsterdam: This brief summary by Paul Sax was published in NEJM Journal Watch shortly after the conference ended.  It includes a series of two- to four-sentence summaries of over 20 developments in the prevention, treatment, and management of HIV infection and viral hepatitis.

AIDS 2018: Focus on Specific Population Groups

African Americans

Kaposi Sarcoma Still a Concern, Especially for African-American Men (Poz)

LGBT

Digital Innovations Are Promoting HIV Testing and Prevention to MSM in Asia (AIDSmap)

Elton John Announces HIV Funding for LGBT and People Who Inject Drugs in Eastern Europe, Central Asia (Science Speaks Blog)

HIV Elimination in Gay Men: What Is Working? (AIDSmap)

Hormone Treatment Tied to Lower Truvada Level in Trans Women on PrEP (Poz)

Persons Who Inject Drugs

Researchers Warn of More HIV Outbreaks Among Injection Drug Users (Poz)

Series of HIV Outbreaks in People Who Inject Drugs Shows That ‘Complacency Is the New Problem’ (AIDSmap)

Opioid Medication Treatment, Outreach to Sex Workers Rank Among Most Cost Effective HIV Interventions, Researchers Say (Science Speaks Blog)

Sex Workers

Laws Meant to End Demand for Sex Work Increase Workers’ HIV Risks, Researchers Say (Science Speaks Blog)

Opioid Medication Treatment, Outreach to Sex Workers Rank Among Most Cost Effective HIV Interventions, Researchers Say (Science Speaks Blog)

Prosecuting Clients vs. Sex Workers Doesn’t Ease Health Care Access (Poz)

Women

Dolutegravir Brings Faster Viral Suppression in Late Pregnancy (AIDSmap)

Lynne Mofenson, M.D., Explains the Dolutegravir Risks for People with HIV Who Want to Get Pregnant (TheBodyPro)

Unintended Pregnancies and Desire for Children: Reproductive Health Needs of Women Living with HIV (AIDSmap)

Most Adolescent PrEP Users in U.S. Are Young Women (AIDSmap)

Hormone Treatment Tied to Lower Truvada Level in Trans Women on PrEP (Poz)

Youth

Most Adolescent PrEP Users in U.S. Are Young Women (AIDSmap)

Progress Against HIV in Young People Lags Behind as Africa’s Youth Population Grows (AIDSmap)

Young Adults with Life-Long HIV Have a Higher Risk of Cancer (AIDSmap); related coverage from Poz

 

AIDS 2018: Focus on the Global Epidemic

Donor Funding for HIV Stalls, Increasing Pressure on High-Burden Countries to Mobilise Domestic Resources (AIDSmap)

Is the Golden Age of International HIV Funding Coming to an End? (Poz)

The HIV Pandemic: Time to Recalibrate and Target the Weak Spots (TheBodyPro)

Series of Community-Wide HIV Household Surveys Have Shown Directions, Possibilities, PEPFAR Leader Says (Science Speaks Blog)

The Way to 90-90-90 Success Against HIV (and More) Can Be Found in Amsterdam (Science Speaks Blog)

Why Are Some Countries Slow to Implement HIV Treatment Guidelines? (AIDSmap)

Elton John Announces HIV Funding for LGBT and People Who Inject Drugs in Eastern Europe, Central Asia (Science Speaks Blog)

Deal Gives Resource-Limited Countries Affordable Access to ID Testing (Healio)

HIV Treatment Services in African Countries Need to Adapt to Serve Mobile and Migrant Populations (AIDSmap)

PrEP Spreads Across Africa – Slowly (AIDSmap)

Progress Against HIV in Young People Lags Behind as Africa’s Youth Population Grows (AIDSmap)

Botswana Benefits from Enhanced HIV Treatment and Prevention Program (Poz)

Dolutegravir: Update on Infant Neural Tube Defects from Botswana (AIDSmap)

High Uptake of HIV Testing When Self-Tests Are Offered to Outpatients in Malawi (AIDSmap)

HIV Test-and-Treat Program Posts Great Success in Kenya and Uganda (Poz)

Nearly 8 in 10 Namibians With HIV Are Virally Suppressed (Poz)

Digital Innovations Are Promoting HIV Testing and Prevention to MSM in Asia (AIDSmap)

AIDS 2018: Focus on HIV Continuum of Care & Ending the Epidemic

The Way to 90-90-90 Success Against HIV (and More) Can Be Found in Amsterdam (Science Speaks Blog)

What’s Right – and What’s Not – On the Road Towards Epidemic Control? (AVAC)

Series of Community-Wide HIV Household Surveys Have Shown Directions, Possibilities, PEPFAR Leader Says (Science Speaks Blog)

Universal Test and Treat Greatly Improves Retention in Care (AIDSmap)

Test and Treat Studies Show High Rates of HIV Diagnosis, Viral Suppression (AIDSmap)

PrEP Use Linked to Fewer New HIV Infections in U.S. States (AIDSmap); related coverage from Poz

Rapid Treatment Initiation and Less Time with Detectable HIV Linked to Falls in New HIV Diagnoses in San Francisco and Melbourne (AIDSmap); related coverage from Poz

HIV Elimination in Gay Men: What Is Working? (AIDSmap)

Opioid Medication Treatment, Outreach to Sex Workers Rank Among Most Cost Effective HIV Interventions, Researchers Say (Science Speaks Blog)

Prosecuting Clients vs. Sex Workers Doesn’t Ease Health Care Access (Poz)


AIDS 2018: Focus on Living with HIV

Three-Quarters of Deaths of People with HIV in London Are Due to Non-AIDS Conditions (AIDSmap)

Young Adults with Life-Long HIV Have a Higher Risk of Cancer (AIDSmap); additional coverage from Poz

Diarrhoea Continues to Affect the Quality of Life of People with HIV in the Modern Treatment Era (AIDSmap)

Having HIV Is Independently Linked to Heart Failure (Poz)

HIV Is Independently Linked to Poorer Mental Health (Poz)

HIV Linked to Higher Risk of Heart Failure (AIDSmap)

Kaposi Sarcoma Still a Concern, Especially for African-American Men (Poz); related coverage from AIDSmap


AIDS 2018: Focus on Policy and Legal Issues

The HIV Pandemic: Time to Recalibrate and Target the Weak Spots (TheBodyPro)

Why Are Some Countries Slow to Implement HIV Treatment Guidelines? (AIDSmap)

Donor Funding for HIV Stalls, Increasing Pressure on High-Burden Countries to Mobilise Domestic Resources (AIDSmap); related coverage from Poz

Expanded Mexico City Policy Built Barriers to HIV Services, Researchers Say (Science Speaks Blog)

Harm Reduction, Human Rights, Meaningful Involvement of Most Affected Get Focus, Raise Questions of Commitment (Science Speaks Blog)

Criminalisation of HIV High on Agenda at AIDS 2018 (AIDSmap)

20 Global Experts Agree: Science Doesn’t Back HIV Crime Laws (Poz); related coverage from AIDSmap and Poz

Prosecuting Clients vs. Sex Workers Doesn’t Ease Health Care Access (Poz)



AIDS 2018: Focus on Transmission and Prevention

The “Undetectable = Untransmittable” Message Goes Global: I=I, N=N and B=B (AIDSmap); related coverage from Science Speaks Blog and TheBodyPro

Zero Transmissions Mean Zero Risk – PARTNER 2 Study Results Announced (AIDSmap); related coverage from Poz and TheBodyPro

Time San Franciscans Spend with Transmissible HIV Has Greatly Declined (Poz)

Digital Innovations Are Promoting HIV Testing and Prevention to MSM in Asia (AIDSmap)

HIV Vax in Advanced Trial Posts Promising 2-Year Results (Poz)

PrEP Use Linked to Fewer New HIV Infections in U.S. States (AIDSmap); related coverage from Poz

PrEP Spreads Across Africa - Slowly (AIDSmap)

On-Demand Dosing as Effective as Daily Dosing in First Year of French PrEP Study (AIDSmap); related coverage from Poz

PrEP Before and After Sex Worked as Well as Daily PrEP in Preventing HIV, New Study Finds (TheBodyPro)

Unprecedented Hepatitis C Infection Rates Seen in Gay Men in Amsterdam PrEP Programme (AIDSmap); related coverage from Poz

Starting PrEP Is Tied to 21% Rise in STI Rate in Gay and Bi Australians (Poz); related coverage from AIDSmap

Hormone Treatment Tied to Lower Truvada Level in Trans Women on PrEP (Poz)

Just 15% of Those Who’ve Started PrEP Are Younger Than 25 (Poz)

Most Adolescent PrEP Users in U.S. Are Young Women (AIDSmap)

PrEP Does Not Lower Feminising Hormone Level in Transgender Women (AIDSmap)

Futuristic PrEP Tablets Can Signal Adherence to Regimen Via Computer (Poz)


AIDS 2018: Focus on Treatment and Cure Research

Anthony Fauci Discusses Research Approaches to Sustaining HIV Remission Without Antiretroviral Therapy (TheBodyPRO)

The Kick That Didn’t Kill: First-Ever Randomised HIV Cure Study Fails to Eliminate Infected Cells (AIDSmap); related coverage from Poz

Patients with HIV ‘Highly Satisfied’ with Long-Acting Injectable Therapy (Healio)

Why Are Some Countries Slow to Implement HIV Treatment Guidelines? (AIDSmap)

HIV Treatment Services in African Countries Need to Adapt to Serve Mobile and Migrant Populations (AIDSmap)

Dolutegravir-Based ART Recommended for All – if Reliable Contraception Is Available (AIDSmap); related coverage from TheBodyPro

Dolutegravir Dual Therapy Works Well for First-Time HIV Treatment (AIDSmap); related coverage from TheBodyPro

Brazil Confirms Dolutegravir Is the Most Effective Drug for First-Line HIV Treatment (AIDSmap)

Dolutegravir: Update on Infant Neural Tube Defects from Botswana (AIDSmap); related coverage from Poz

Dolutegravir Brings Faster Viral Suppression in Late Pregnancy (AIDSmap)

Doravirine Maintains Higher Rate of Virological Suppression Over Darunavir/Ritonavir Though 96 Weeks of Follow-Up (AIDSmap); related coverage from Healio and Poz

Reduced Dose Darunavir/Ritonavir Effective and Safe for People Switching While Virally Suppressed (AIDSmap); related coverage from Poz

Patients with HIV Achieve Virologic Suppression with Rapid Initiation Symtuza Treatment (Healio); related coverage from Poz

Switching to Symtuza Is Safe and Effective Regardless of Previous HIV Regimen (Poz)

Switching to ViiV’s Juluca Proves Effective Two Years into Major Trial (Poz)

ViiV’s 2-Drug Regimen Is on Par With a 3-Drug Combo (Poz)

AIDS 2018: Focus on Viral Hepatitis

Supervised Drug Consumption Sites Offer Opportunities for HCV Testing and Treatment (AIDSmap); related coverage from Poz and Science Speaks Blog

Unprecedented Hepatitis C Infection Rates Seen in Gay Men in Amsterdam PrEP Programme (AIDSmap); related coverage from Poz

Zepatier Beats Almost All Acute Hepatitis C in Just 8 Weeks (Poz)

 

 

This is a DEBUG feature. This will not Transfer to production

(production) 19 queries took 26 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Aetc`.`id`, `Aetc`.`name_short`, `Aetc`.`url` FROM `cakedb`.`aetcs` AS `Aetc` LEFT JOIN `cakedb`.`users` AS `Creator` ON (`Aetc`.`created_by` = `Creator`.`id`) LEFT JOIN `cakedb`.`users` AS `Updater` ON (`Aetc`.`updated_by` = `Updater`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HeaderImage` ON (`Aetc`.`header_image` = `HeaderImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HomepageMapImage` ON (`Aetc`.`homepage_map_image` = `HomepageMapImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `RibbonImage` ON (`Aetc`.`ribbon_image` = `RibbonImage`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Aetc`.`timezone_id` = `Timezone`.`id`) WHERE 1 = 1331
2SELECT `Site`.`id`, `Site`.`title`, `Site`.`code`, `Site`.`description`, `Site`.`image`, `Site`.`imagecaption`, `Site`.`address1`, `Site`.`address2`, `Site`.`city`, `Site`.`state`, `Site`.`zip`, `Site`.`phone`, `Site`.`fax`, `Site`.`email`, `Site`.`active`, `Site`.`sortorder`, `Site`.`aetc_id`, `Site`.`timezone_id` FROM `cakedb`.`sites` AS `Site` WHERE `Site`.`aetc_id` IN (1, 2, 3)27271
3SELECT `Aetc`.`id`, `Aetc`.`name`, `Aetc`.`name_short`, `Aetc`.`code`, `Aetc`.`url`, `Aetc`.`color_1`, `Aetc`.`color_2`, `Aetc`.`color_3`, `Aetc`.`top_bar_color`, `Aetc`.`ribbon_image`, `Aetc`.`header_image`, `Aetc`.`admin_name`, `Aetc`.`admin_email`, `Aetc`.`admin_phone`, `Aetc`.`web_name`, `Aetc`.`web_email`, `Aetc`.`web_phone`, `Aetc`.`removable`, `Aetc`.`created`, `Aetc`.`created_by`, `Aetc`.`updated`, `Aetc`.`updated_by`, `Aetc`.`timezone_id`, `Aetc`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Creator`.`id`, `Creator`.`email`, `Creator`.`password`, `Creator`.`first_name`, `Creator`.`last_name`, `Creator`.`credentials`, `Creator`.`organization`, `Creator`.`address1`, `Creator`.`address2`, `Creator`.`city`, `Creator`.`state`, `Creator`.`zip`, `Creator`.`phone`, `Creator`.`dob`, `Creator`.`uniqueidnumber`, `Creator`.`active`, `Creator`.`created`, `Creator`.`role`, `Creator`.`taap_access`, `Creator`.`email_list_bak`, `Creator`.`site`, `Creator`.`last_login`, `Creator`.`attempt_time`, `Creator`.`attempt_try`, `Creator`.`speaker`, `Creator`.`ftcc_id`, `Creator`.`pif_id`, `Creator`.`email_list`, `Creator`.`deleted`, `Creator`.`deleted_flag`, (CONCAT(`Creator`.`first_name`, " ", `Creator`.`last_name`)) AS `Creator__name`, `Updater`.`id`, `Updater`.`email`, `Updater`.`password`, `Updater`.`first_name`, `Updater`.`last_name`, `Updater`.`credentials`, `Updater`.`organization`, `Updater`.`address1`, `Updater`.`address2`, `Updater`.`city`, `Updater`.`state`, `Updater`.`zip`, `Updater`.`phone`, `Updater`.`dob`, `Updater`.`uniqueidnumber`, `Updater`.`active`, `Updater`.`created`, `Updater`.`role`, `Updater`.`taap_access`, `Updater`.`email_list_bak`, `Updater`.`site`, `Updater`.`last_login`, `Updater`.`attempt_time`, `Updater`.`attempt_try`, `Updater`.`speaker`, `Updater`.`ftcc_id`, `Updater`.`pif_id`, `Updater`.`email_list`, `Updater`.`deleted`, `Updater`.`deleted_flag`, (CONCAT(`Updater`.`first_name`, " ", `Updater`.`last_name`)) AS `Updater__name`, `HeaderImage`.`id`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`name`, `HeaderImage`.`attachment`, `HeaderImage`.`dir`, `HeaderImage`.`type`, `HeaderImage`.`size`, `HeaderImage`.`url`, `HeaderImage`.`visibility`, `HeaderImage`.`active`, `HeaderImage`.`category_id`, `HeaderImage`.`created`, `HeaderImage`.`aetc_id`, `HomepageMapImage`.`id`, `HomepageMapImage`.`model`, `HomepageMapImage`.`foreign_key`, `HomepageMapImage`.`name`, `HomepageMapImage`.`attachment`, `HomepageMapImage`.`dir`, `HomepageMapImage`.`type`, `HomepageMapImage`.`size`, `HomepageMapImage`.`url`, `HomepageMapImage`.`visibility`, `HomepageMapImage`.`active`, `HomepageMapImage`.`category_id`, `HomepageMapImage`.`created`, `HomepageMapImage`.`aetc_id`, `RibbonImage`.`id`, `RibbonImage`.`model`, `RibbonImage`.`foreign_key`, `RibbonImage`.`name`, `RibbonImage`.`attachment`, `RibbonImage`.`dir`, `RibbonImage`.`type`, `RibbonImage`.`size`, `RibbonImage`.`url`, `RibbonImage`.`visibility`, `RibbonImage`.`active`, `RibbonImage`.`category_id`, `RibbonImage`.`created`, `RibbonImage`.`aetc_id`, `Timezone`.`id`, `Timezone`.`name`, `Timezone`.`abbreviation` FROM `cakedb`.`aetcs` AS `Aetc` LEFT JOIN `cakedb`.`users` AS `Creator` ON (`Aetc`.`created_by` = `Creator`.`id`) LEFT JOIN `cakedb`.`users` AS `Updater` ON (`Aetc`.`updated_by` = `Updater`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HeaderImage` ON (`Aetc`.`header_image` = `HeaderImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HomepageMapImage` ON (`Aetc`.`homepage_map_image` = `HomepageMapImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `RibbonImage` ON (`Aetc`.`ribbon_image` = `RibbonImage`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Aetc`.`timezone_id` = `Timezone`.`id`) WHERE `Aetc`.`id` = 3 LIMIT 1111
4SELECT `Site`.`id`, `Site`.`title`, `Site`.`code`, `Site`.`description`, `Site`.`image`, `Site`.`imagecaption`, `Site`.`address1`, `Site`.`address2`, `Site`.`city`, `Site`.`state`, `Site`.`zip`, `Site`.`phone`, `Site`.`fax`, `Site`.`email`, `Site`.`active`, `Site`.`sortorder`, `Site`.`aetc_id`, `Site`.`timezone_id` FROM `cakedb`.`sites` AS `Site` WHERE `Site`.`aetc_id` = (3)14141
5SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Aetc`.`id`, `Aetc`.`name`, `Aetc`.`name_short`, `Aetc`.`code`, `Aetc`.`url`, `Aetc`.`color_1`, `Aetc`.`color_2`, `Aetc`.`color_3`, `Aetc`.`top_bar_color`, `Aetc`.`ribbon_image`, `Aetc`.`header_image`, `Aetc`.`admin_name`, `Aetc`.`admin_email`, `Aetc`.`admin_phone`, `Aetc`.`web_name`, `Aetc`.`web_email`, `Aetc`.`web_phone`, `Aetc`.`removable`, `Aetc`.`created`, `Aetc`.`created_by`, `Aetc`.`updated`, `Aetc`.`updated_by`, `Aetc`.`timezone_id`, `Aetc`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `top_bar_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC001
6SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Aetc`.`id`, `Aetc`.`name`, `Aetc`.`name_short`, `Aetc`.`code`, `Aetc`.`url`, `Aetc`.`color_1`, `Aetc`.`color_2`, `Aetc`.`color_3`, `Aetc`.`top_bar_color`, `Aetc`.`ribbon_image`, `Aetc`.`header_image`, `Aetc`.`admin_name`, `Aetc`.`admin_email`, `Aetc`.`admin_phone`, `Aetc`.`web_name`, `Aetc`.`web_email`, `Aetc`.`web_phone`, `Aetc`.`removable`, `Aetc`.`created`, `Aetc`.`created_by`, `Aetc`.`updated`, `Aetc`.`updated_by`, `Aetc`.`timezone_id`, `Aetc`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `quick_links_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC555
7SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (246, 247, 285, 248, 249)000
8SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Aetc`.`id`, `Aetc`.`name`, `Aetc`.`name_short`, `Aetc`.`code`, `Aetc`.`url`, `Aetc`.`color_1`, `Aetc`.`color_2`, `Aetc`.`color_3`, `Aetc`.`top_bar_color`, `Aetc`.`ribbon_image`, `Aetc`.`header_image`, `Aetc`.`admin_name`, `Aetc`.`admin_email`, `Aetc`.`admin_phone`, `Aetc`.`web_name`, `Aetc`.`web_email`, `Aetc`.`web_phone`, `Aetc`.`removable`, `Aetc`.`created`, `Aetc`.`created_by`, `Aetc`.`updated`, `Aetc`.`updated_by`, `Aetc`.`timezone_id`, `Aetc`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `national_resources_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC111110
9SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260)000
10SELECT `Site`.`id`, `Site`.`title` FROM `cakedb`.`sites` AS `Site` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Site`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Site`.`timezone_id` = `Timezone`.`id`) WHERE `Site`.`aetc_id` = 314141
11SELECT `ContentPage`.`id`, `ContentPage`.`user_id`, `ContentPage`.`title`, `ContentPage`.`subtitle`, `ContentPage`.`body`, `ContentPage`.`slug`, `ContentPage`.`keywords`, `ContentPage`.`sidebar_flag`, `ContentPage`.`sidebar`, `ContentPage`.`content_status_id`, `ContentPage`.`published`, `ContentPage`.`created`, `ContentPage`.`updated`, `ContentPage`.`group_id`, `ContentPage`.`public`, `ContentPage`.`featured`, `ContentPage`.`content_type_id`, `ContentPage`.`news_id`, `ContentPage`.`site_id`, `ContentPage`.`aetc_id`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`credentials`, `User`.`organization`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`dob`, `User`.`uniqueidnumber`, `User`.`active`, `User`.`created`, `User`.`role`, `User`.`taap_access`, `User`.`email_list_bak`, `User`.`site`, `User`.`last_login`, `User`.`attempt_time`, `User`.`attempt_try`, `User`.`speaker`, `User`.`ftcc_id`, `User`.`pif_id`, `User`.`email_list`, `User`.`deleted`, `User`.`deleted_flag`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Status`.`id`, `Status`.`name`, `Status`.`description`, `Content`.`id`, `Content`.`user_id`, `Content`.`content_id`, `Content`.`content_type_id`, `Content`.`site_id` FROM `cakedb`.`content_pages` AS `ContentPage` LEFT JOIN `cakedb`.`users` AS `User` ON (`ContentPage`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`content_statuses` AS `Status` ON (`ContentPage`.`content_status_id` = `Status`.`id`) LEFT JOIN `cakedb`.`contents` AS `Content` ON (`Content`.`content_id` = `ContentPage`.`id`) WHERE `ContentPage`.`id` = 158 AND `ContentPage`.`aetc_id` = 3 LIMIT 1111
12SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'ContentPage' AND `Attachment`.`foreign_key` = (158)001
13SELECT `ContentPagesGroup`.`id`, `ContentPagesGroup`.`content_page_id`, `ContentPagesGroup`.`group_id`, `ContentPagesGroup`.`created`, `ContentPagesGroup`.`updated` FROM `cakedb`.`content_pages_groups` AS `ContentPagesGroup` WHERE `ContentPagesGroup`.`content_page_id` = (158)000
14SELECT `ContentPagesEditor`.`id`, `ContentPagesEditor`.`content_page_id`, `ContentPagesEditor`.`user_id`, `ContentPagesEditor`.`user_type_id`, `ContentPagesEditor`.`created`, `ContentPagesEditor`.`updated` FROM `cakedb`.`content_pages_users` AS `ContentPagesEditor` WHERE `ContentPagesEditor`.`user_type_id` = 3 AND `ContentPagesEditor`.`content_page_id` = (158)000
15SELECT `ContentPagesUser`.`id`, `ContentPagesUser`.`content_page_id`, `ContentPagesUser`.`user_id`, `ContentPagesUser`.`user_type_id`, `ContentPagesUser`.`created`, `ContentPagesUser`.`updated` FROM `cakedb`.`content_pages_users` AS `ContentPagesUser` WHERE `ContentPagesUser`.`content_page_id` = (158)000
16SELECT `ContentPagesViewer`.`id`, `ContentPagesViewer`.`content_page_id`, `ContentPagesViewer`.`user_id`, `ContentPagesViewer`.`user_type_id`, `ContentPagesViewer`.`created`, `ContentPagesViewer`.`updated` FROM `cakedb`.`content_pages_users` AS `ContentPagesViewer` WHERE `ContentPagesViewer`.`user_type_id` = 2 AND `ContentPagesViewer`.`content_page_id` = (158)000
17SELECT `Group`.`id`, `Group`.`name`, `Group`.`user_id`, `Group`.`created`, `Group`.`updated`, `Group`.`created_by`, `Group`.`updated_by`, `Group`.`description`, `ContentPagesGroup`.`id`, `ContentPagesGroup`.`content_page_id`, `ContentPagesGroup`.`group_id`, `ContentPagesGroup`.`created`, `ContentPagesGroup`.`updated` FROM `cakedb`.`groups` AS `Group` JOIN `cakedb`.`content_pages_groups` AS `ContentPagesGroup` ON (`ContentPagesGroup`.`content_page_id` = 158 AND `ContentPagesGroup`.`group_id` = `Group`.`id`) 001
18SELECT `ContentPagesUser`.`id`, `ContentPagesUser`.`content_page_id`, `ContentPagesUser`.`user_id`, `ContentPagesUser`.`user_type_id`, `ContentPagesUser`.`created`, `ContentPagesUser`.`updated`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`credentials`, `User`.`organization`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`dob`, `User`.`uniqueidnumber`, `User`.`active`, `User`.`created`, `User`.`role`, `User`.`taap_access`, `User`.`email_list_bak`, `User`.`site`, `User`.`last_login`, `User`.`attempt_time`, `User`.`attempt_try`, `User`.`speaker`, `User`.`ftcc_id`, `User`.`pif_id`, `User`.`email_list`, `User`.`deleted`, `User`.`deleted_flag`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `ContentPage`.`id`, `ContentPage`.`user_id`, `ContentPage`.`title`, `ContentPage`.`subtitle`, `ContentPage`.`body`, `ContentPage`.`slug`, `ContentPage`.`keywords`, `ContentPage`.`sidebar_flag`, `ContentPage`.`sidebar`, `ContentPage`.`content_status_id`, `ContentPage`.`published`, `ContentPage`.`created`, `ContentPage`.`updated`, `ContentPage`.`group_id`, `ContentPage`.`public`, `ContentPage`.`featured`, `ContentPage`.`content_type_id`, `ContentPage`.`news_id`, `ContentPage`.`site_id`, `ContentPage`.`aetc_id`, `UserType`.`id`, `UserType`.`name` FROM `cakedb`.`content_pages_users` AS `ContentPagesUser` LEFT JOIN `cakedb`.`users` AS `User` ON (`ContentPagesUser`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`content_pages` AS `ContentPage` ON (`ContentPagesUser`.`content_page_id` = `ContentPage`.`id`) LEFT JOIN `cakedb`.`user_types` AS `UserType` ON (`ContentPagesUser`.`user_type_id` = `UserType`.`id`) WHERE `ContentPagesUser`.`content_page_id` = 158 AND `ContentPagesUser`.`user_id` IS NULL001
19SELECT `ContentPagesUser`.`id`, `ContentPagesUser`.`content_page_id`, `ContentPagesUser`.`user_id`, `ContentPagesUser`.`user_type_id`, `ContentPagesUser`.`created`, `ContentPagesUser`.`updated`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`credentials`, `User`.`organization`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`dob`, `User`.`uniqueidnumber`, `User`.`active`, `User`.`created`, `User`.`role`, `User`.`taap_access`, `User`.`email_list_bak`, `User`.`site`, `User`.`last_login`, `User`.`attempt_time`, `User`.`attempt_try`, `User`.`speaker`, `User`.`ftcc_id`, `User`.`pif_id`, `User`.`email_list`, `User`.`deleted`, `User`.`deleted_flag`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `ContentPage`.`id`, `ContentPage`.`user_id`, `ContentPage`.`title`, `ContentPage`.`subtitle`, `ContentPage`.`body`, `ContentPage`.`slug`, `ContentPage`.`keywords`, `ContentPage`.`sidebar_flag`, `ContentPage`.`sidebar`, `ContentPage`.`content_status_id`, `ContentPage`.`published`, `ContentPage`.`created`, `ContentPage`.`updated`, `ContentPage`.`group_id`, `ContentPage`.`public`, `ContentPage`.`featured`, `ContentPage`.`content_type_id`, `ContentPage`.`news_id`, `ContentPage`.`site_id`, `ContentPage`.`aetc_id`, `UserType`.`id`, `UserType`.`name` FROM `cakedb`.`content_pages_users` AS `ContentPagesUser` LEFT JOIN `cakedb`.`users` AS `User` ON (`ContentPagesUser`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`content_pages` AS `ContentPage` ON (`ContentPagesUser`.`content_page_id` = `ContentPage`.`id`) LEFT JOIN `cakedb`.`user_types` AS `UserType` ON (`ContentPagesUser`.`user_type_id` = `UserType`.`id`) WHERE `ContentPagesUser`.`content_page_id` = 158 AND `ContentPagesUser`.`user_id` IS NULL001