New user? Sign up here |
In-Brief: June 7th, 2018

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.

Pre-Exposure Prophylaxis (PrEP)

FDA Approves Truvada PrEP for Adolescents

The U.S. Food and Drug Administration (FDA) has approved changes to the indications for the fixed-dose combination pill Truvada (emtricitabine and tenofovir disoproxil fumarate) that now allow Truvada to be used as pre-exposure prophylaxis (PrEP) for adolescents weighing at least 35 kg (about 77 pounds) who are at risk for HIV infection. Truvada was first approved for HIV PrEP in at-risk adults in 2012.  According to drug-maker Gilead, FDA’s decision to allow the use of Truvada-based PrEP in adolescents is based on the findings of study ATN113, which examined the use of Truvada in HIV-negative adolescents 15 to 17 years old. 

“Study ATN113 has demonstrated that Truvada for PrEP is a well-tolerated prevention option for adolescents who are vulnerable to HIV,” noted study lead investigator Sybil Hosek of the Cook County Health and Hospital System's Stroger Hospital in Chicago. “In addition to traditional risk-reduction strategies, healthcare providers and community advocates are now equipped with another tool to help address the incidence of HIV in younger at-risk populations.” CDC surveillance data indicate that adolescents and young adults 13 to 24 years old comprised 21% of all new HIV infections in the U.S. during 2016, and that 81% of those infections were among young men who have sex with men.

“We must make use of all available options when considering HIV prevention strategies, and we welcome the development that Truvada for PrEP is now available for younger people who are at risk of HIV,” said Matthew Rose of the advocacy organization NMAC. “We will continue to build awareness and understanding of the role of Truvada for PrEP as part of a comprehensive HIV prevention plan for all who may benefit from it, particularly among communities disproportionately impacted by the disease, including young Black and Latino men in the United States.”

PrEP Use and Access in the U.S. Military

HIV infection is a substantial health concern for U.S. military service members stationed throughout the world. Each year, about 350 new HIV infections are diagnosed among military service members, and the majority of those infections acquired within the United States. HIV infections in the U.S. military mirror those in the U.S. civilian population, with the highest rates of new diagnoses among men and Blacks or African Americans. Blacks are disproportionally affected, and most new diagnoses occur among MSM. To examine the use of PrEP among military service members, researchers from the Walter Reed National Military Medical Center and elsewhere examined military health system and service records and surveyed military health care providers to assess their HIV PrEP knowledge and attitudes.

Among 769 service members prescribed PrEP during the period from February 1, 2014 through June 10, 2016, 87% were MSM.  In addition, 60% of those receiving PrEP obtained prescriptions from an infectious disease provider, 19% were Black men, and 42% were more than 28 years old. Nearly half (49%) of surveyed military health care providers self-rated their PrEP knowledge as poor, and only 29% reported ever having prescribed PrEP.

“Despite the universal access to care afforded to service members by the military health care system, there is a recognized need to improve and expand access to PrEP for those patients at highest risk for HIV infection. Currently, the availability of PrEP services is heterogeneous, based on the individual patient’s geographic location,” the report authors note. “New DoD [Department of Defense] policy is being developed to address identified gaps through initiatives to improve health care provider education and so ensure universal access to PrEP at the primary care level, and to standardize pharmacy and laboratory service delivery at all military treatment facilities.”

Treatment Guidelines for HIV and Opportunistic Infections (OIs)

Recent Updates to U.S. Guidelines for Testing HIV and OIs

In recent weeks, the U.S. Department of Health and Human Services (HHS) has published several updates to its guidelines for the treatment of HIV and opportunistic infections. A brief summary of changes to the guidelines, together with links to more detailed information, are provided below:

Guidelines for the Use of Antiretroviral Agents in Pediatric HIV Infection – updates include changes in: the recommended frequency of viral load testing; when to start antiretroviral therapy (ART); and the drugs recommended for ART in children.

Guidelines for the Prevention and Treatment of Opportunistic Infections in HIV-Infected Adults and Adolescents – updates include changes in the management of human papillomavirus disease (HPV) and human herpesvirus-8 (also known as Kaposi sarcoma-associated herpesvirus). The Guideline’s Table 2, summarizing treatment for opportunistic illnesses, has also been updated to reflect recommended changes in the management of OIs.

Recommended Caution Regarding the Use of Dolutegravir by Women and Girls - The HHS Antiretroviral Guidelines Panels have issued recommendations cautioning about the potential risks of using the integrase inhibitor dolutegravir by women and girls who are pregnant or of child-bearing potential.  A recent study found some cases of neural tube defects among women who started a dolutegravir-based ART regimen prior to pregnancy and who were still receiving it at the time of conception.

The U.S. and Global HIV Epidemic

Continued Progress in Reducing HIV Infections and Improving Health Outcomes in the U.SThe U.S. has continued to make progress in reducing new HIV infections, improving health outcomes among people living with HIV, and reducing some HIV-related disparities, according to the 2017 National HIV/AIDS Strategy (NHAS) Progress Report. The report was produced by HHS’s NHAS Federal Interagency Workgroup, which is responsible for coordinating implementation and monitoring of the Strategy across the federal government.An important component of the NHAS is a series of 17 indicators that are used to measure U.S. progress in meeting the plan’s objectives. The NHAS workgroup was able to gather and present information on 16 of the indicators in the report. According to the report, the U.S. has met or exceeded the annual targets in nine categories and made significant progress toward meeting another two of those targets. Examples of recent progress include:
  • The number of new HIV diagnoses decreased by nearly 5% from 41,985 in 2011 to 39,876 in 2015.
  • The percentage of persons living with diagnosed HIV who were virally suppressed increased from 46% in 2010 to 58% in 2014.
  • The number of adults prescribed PrEP increased by more than 300% from 7,972 in 2014 to 33,273 in 2015.
“Unfortunately, the report also shows that progress has not been equal across all populations and regions,” according to a brief summary of the report on HIV.gov. “There continue to be disparities in HIV risk and diagnoses for gay and bisexual men, stable housing among people living with HIV, and HIV diagnoses in the Southern U.S.”  15-Year Highlights from PEPFARLast month marked the 15th anniversary of the enactment of the U.S. President’s Emergency Plan for AIDS Relief (PEPFAR).  At that time, only 50,000 people in Africa were receiving life-saving antiretroviral treatment (ART) for HIV infection, and death rates among persons living with HIV there were high and rising.  Now PEPFAR supports more than 14 million men, women, and children on ART – more than twice the number 4.5 years ago. In addition, PEPFAR:
  • has enabled more than 2.2 million babies to be born HIV-free to HIV-positive mothers;
  • assists more than 6.4 million orphans, vulnerable children, and their caregivers affected by HIV/AIDS; and
  • has provided voluntary medical male circumcision to more than 15.2 million men and boys to prevent HIV transmission.
The latest PEPFAR data show at least a 25-40% decline in new HIV diagnoses among adolescent girls and young women in nearly two-thirds of the highest-HIV-burden communities that are implementing PEPFAR’s DREAMS (Determined, Resilient, Empowered, AIDS-free, Mentored, and Safe) public-private partnership across 10 African countries. “We have the historic opportunity – for the first time ever – to control a pandemic without a vaccine or a cure, laying the groundwork for eventually eliminating HIV,” notes Ambassador Deborah Birx, the U.S. Global AIDS Coordinator and Special Representative for Global Health. “Across Africa and in many other parts of the world, death and despair have been overwhelmingly replaced with hope and life.”

HIV Resources: Tools, Reports, and Fact Sheets

New and Updated Materials from CDC and AIDSinfo

Diagnoses of HIV Infection Among Adolescents and Young Adults in the United States and 6 Dependent Areas 2011–2016 (CDC) – This 45-page surveillance report provides detailed data on new HIV and AIDS diagnoses and HIV and AIDS prevalence in the United States. Breakdowns are provided by age, race/ethnicity, gender, transmission category, and region.

2016 CDC Funded HIV Testing Report: United States, Puerto Rico, and U.S. Virgin Islands, 2016 (CDC) – This 83-page report includes HIV test event-level data from 61 CDC-funded health department jurisdictions and 102 directly funded community-based organizations. Of the 3.0 million CDC-funded HIV test events conducted in 2016, 2.3 million were conducted in health care and correctional facilities and about 700,000 were conducted in non-health care facilities. Breakdowns of testing events are provided by age, race/ethnicity, gender, target population groups, and regions.

HIV Among Asians (CDC) – This fact sheet provides information on new HIV diagnoses, prevalence, and prevention challenges for Asian Americans, as well as steps that CDC is taking to address HIV among Asian Americans.

False-Positive HIV Results (CDC) – This fact sheet describes what false-positive results are, their causes, and additional tests that can be performed to distinguish true and false positives.

AIDSinfo has also recently released the following updated fact sheets on HIV prevention, with corresponding Spanish-language versions available on its infoSIDA site:

"HIV Matters" Podcast Series from UNC

The University of North Carolina (UNC) Department of Medicine has recently produced a six-part “HIV Matters” series as part of its Chair’s Corner with Dr. Ron Falk podcast.  The HIV Matters audio podcasts, which are available on the Soundcloud platform, feature 20- to 30-minute interviews with prominent HIV researchers and cover the following topics:

  • preventing HIV with PrEP;
  • getting care for HIV;
  • HIV treatment;
  • living a long life with HIV;
  • HIV-related challenges facing women and minorities; and 
  • participating in HIV cure research.

Flipchart on Transitioning Adolescents from Pediatric to Adult HIV Care

As part of its TREAT Asia initiative, amfAR has developed tools to help providers manage the transition of adolescents from pediatric to adult HIV clinics.  Among these tools is the 34-slide illustrated flipchart Transferring Care, which providers can use to guide their discussions with young patients transitioning to adult care.  This resource includes information on the following topics:

  • differences between pediatric and adult HIV clinics;
  • when to make the transition in care;
  • what to expect at an adult HIV clinic; and
  • general information about HIV treatment and prevention.

The flipchart is currently available for download in English, Bahasa Indonesia, Khmer, Thai, and Vietnamese. A Malay version is expected to be released in September 2018.

 

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

(production) 20 queries took 27 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 `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id`, `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` FROM `cakedb`.`menu_links` AS `MenuLink` LEFT JOIN `cakedb`.`links` AS `Link` ON (`MenuLink`.`link_id` = `Link`.`id`) WHERE `MenuLink`.`aetc_id` = 3 ORDER BY `lft` ASC42421
11SELECT `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
12SELECT `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` = 132 AND `ContentPage`.`aetc_id` = 3 LIMIT 1111
13SELECT `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` = (132)001
14SELECT `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` = (132)000
15SELECT `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` = (132)000
16SELECT `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` = (132)000
17SELECT `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` = (132)000
18SELECT `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` = 132 AND `ContentPagesGroup`.`group_id` = `Group`.`id`) 001
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` = 132 AND `ContentPagesUser`.`user_id` IS NULL001
20SELECT `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` = 132 AND `ContentPagesUser`.`user_id` IS NULL001