Created
May 23, 2016 14:35
-
-
Save phpprousa/26f157e5b585bbada443fa590d071adb to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [test_query] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => SWP_Query | |
| [s] => medicaid | |
| [engine] => default | |
| [posts_per_page] => 10 | |
| [load_posts] => 1 | |
| [fields] => all | |
| [nopaging] => | |
| [page] => 1 | |
| [post_type] => Array | |
| ( | |
| [0] => post | |
| [1] => page | |
| [2] => attachment | |
| ) | |
| [post__in] => Array | |
| ( | |
| ) | |
| [post__not_in] => Array | |
| ( | |
| ) | |
| [tax_query] => Array | |
| ( | |
| [0] => Array | |
| ( | |
| [relation] => AND | |
| [0] => Array | |
| ( | |
| [taxonomy] => category | |
| [field] => id | |
| [terms] => 189 | |
| ) | |
| [1] => Array | |
| ( | |
| [relation] => OR | |
| [0] => Array | |
| ( | |
| [taxonomy] => category | |
| [field] => id | |
| [terms] => 189 | |
| ) | |
| [1] => Array | |
| ( | |
| [taxonomy] => category | |
| [field] => id | |
| [terms] => 190 | |
| ) | |
| ) | |
| ) | |
| ) | |
| [meta_query] => Array | |
| ( | |
| ) | |
| [date_query] => Array | |
| ( | |
| ) | |
| [posts] => Array | |
| ( | |
| [0] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 36569 | |
| [post_author] => 112 | |
| [post_date] => 2016-05-19 15:22:00 | |
| [post_date_gmt] => 2016-05-19 19:22:00 | |
| [post_content] => | |
| [post_title] => GA Renews Temporary Medicaid Rate Increases; Looks at Medicaid Expansion | |
| [post_excerpt] => Modern Healthcare reported on May 18, 2016, that Georgia lawmakers are renewing temporary Medicaid payment increases for primary care doctors and are looking at expanding Medicaid to help balance the state's budget and address a growing population. Georgia Senate Health and Human Services committee chairwoman, Renee Unterman, believes there could be enough support in the Senate to pass a conservative expansion model, replicating the Arkansas private option expansion, which requires some beneficiaries to pay up to 2 percent of their income in premiums. About 400,00 people would be eligible for expansion. The Chamber of Commerce is expected to present expansion ideas when it reconvenes in January 2017. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => ga-renews-temporary-medicaid-rate-increases-looks-medicaid-expansion | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-05-19 15:22:00 | |
| [post_modified_gmt] => 2016-05-19 19:22:00 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=36569 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [1] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 33083 | |
| [post_author] => 992 | |
| [post_date] => 2016-04-26 17:27:37 | |
| [post_date_gmt] => 2016-04-26 21:27:37 | |
| [post_content] => | |
| [post_title] => OH Medicaid Fraud Control Unit Leads Nation in Convictions | |
| [post_excerpt] => The Sentinel Tribune reported on March 31, 2016, that Ohio's Medicaid Fraud Control Unit had the highest number of convictions of all fraud control units in the nation in fiscal year 2015. The unit is responsible for investigating and prosecuting health care providers that have committed fraud in the state's Medicaid program and protects individuals with disabilities and mental illness from abuse in long term care facilities. 160 individuals were convicted after investigations last year. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => 33083 | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-04-26 17:27:37 | |
| [post_modified_gmt] => 2016-04-26 21:27:37 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=33083 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [2] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 32547 | |
| [post_author] => 992 | |
| [post_date] => 2016-04-18 12:56:59 | |
| [post_date_gmt] => 2016-04-18 16:56:59 | |
| [post_content] => | |
| [post_title] => CT Governor Proposes 10 Percent Reduction in Pediatric Medicaid Dental Rates | |
| [post_excerpt] => The Connecticut Mirror reported on April 18, 2016, that Governor Dannel Malloy has proposed reducing children's Medicaid dental reimbursement rates by 10 percent. The Connecticut State Dental Association and other stakeholders oppose the cut, saying that reduced rates could negatively impact access to services. Representatives of Connecticut Department of Social Services note that the state's reimbursement rates are already higher than surrounding states. Between 2005 and 2013, the percentage of Medicaid children who visited a dentist in Connecticut more than doubled from 31.9 percent to 64.3 percent. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => 32547 | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-04-18 12:56:59 | |
| [post_modified_gmt] => 2016-04-18 16:56:59 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=32547 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [3] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 32084 | |
| [post_author] => 112 | |
| [post_date] => 2016-04-12 13:40:54 | |
| [post_date_gmt] => 2016-04-12 17:40:54 | |
| [post_content] => | |
| [post_title] => OH Governor Calls for Speeding Up a Personal Income Tax Cut; Underspending in Medicaid May Create FY 2016 Year End Balance between $400 - $500 Million | |
| [post_excerpt] => Gongwer Ohio is reporting on information from Ohio’s Office of Budget and Management that tax receipts are tracking to estimates, and personal income tax intake is better than expected for March, helping push year-to-date tax receipts just above projections for the first eight months of FY 2016, to almost $16 billion. The commercial activity tax and the financial intuitions tax also came in above projections, according to the Office of Budget and Management. Ohio officials expect the FY 2016 year-end balance will be between $400 million and $500 million, due mostly, if not entirely, to the underspending in Medicaid. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => oh-governor-calls-for-speeding-up-a-personal-income-tax-cut-underspending-in-medicaid-may-create-fy-2016-year-end-balance-between-400-and-500-million | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-04-12 16:17:56 | |
| [post_modified_gmt] => 2016-04-12 20:17:56 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=32084 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [4] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 31149 | |
| [post_author] => 992 | |
| [post_date] => 2016-04-05 12:59:39 | |
| [post_date_gmt] => 2016-04-05 16:59:39 | |
| [post_content] => Download NowGA_RFP_Protest_Hearing_Announcement_Apr-16.pdf | |
| [post_title] => GA to Hold Medicaid Managed Care Plan Protest Hearing May 4, 2016 | |
| [post_excerpt] => Georgia Governor Nathan Deal announced on April 4, 2016, that the state Department of Administrative Services will hold a hearing on May 4, 2016, related to health plan protests of the state's recent Medicaid managed care awards. In September 2015, Georgia announced it would award four health plans contracts to serve the state’s 1.3 million Georgia Families members. The three incumbent plans were among the winners: Anthem/Amerigroup, Centene/Peach State, and WellCare. The fourth winner, CareSource, is a new entrant to the Georgia Medicaid market. AmeriHealth Caritas, AmeriChoice (United), and Humana submitted protests in response. | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => ga-department-of-administrative-services-to-hold-plan-protest-hearing-may-4-2016 | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-04-05 12:59:39 | |
| [post_modified_gmt] => 2016-04-05 16:59:39 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=31149 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [5] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 31214 | |
| [post_author] => 112 | |
| [post_date] => 2016-04-05 12:20:30 | |
| [post_date_gmt] => 2016-04-05 16:20:30 | |
| [post_content] => | |
| [post_title] => AR Legislators Propose Medicaid Managed Care Alternative, $1 Billion in Medicaid Budget Savings | |
| [post_excerpt] => ArkansasMatters.com reported on April 4, 2016, that a bi-partisan group of legislators released a proposal for DiamondCare, an alternative to Governor Asa Hutchinson’s Medicaid managed care plan. DiamondCare would utilize Administrative Services Organizations (ASOs) instead of capitated managed care organizations (MCOs), and would reduce the state's Medicaid budget by an estimated $1.057 billion over the next five years. DiamondCare would utilize the existing network of Medicaid providers and include funding to reduce the waiting list for individuals with developmental disabilities. Read More. Governor Hutchinson’s formal call for a special legislative session on Medicaid includes a plan to hire managed care companies to provide care for the individuals with developmental disabilities and individuals with severe mental illness, as well as a bill to make changes in the state's private option expanded Medicaid program through an initiative called Arkansas Works. Legislators are calling on the Governor to drop the managed care proposal from the special session. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => legislators-release-proposal-to-reduce-ar-medicaid-budget-by-1-billion-over-five-years-hutchinson-will-not-include-in-special-session | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-04-05 12:38:03 | |
| [post_modified_gmt] => 2016-04-05 16:38:03 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=31214 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [6] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 30086 | |
| [post_author] => 47 | |
| [post_date] => 2016-03-30 17:45:14 | |
| [post_date_gmt] => 2016-03-30 21:45:14 | |
| [post_content] => | |
| [post_title] => OK Medicaid Agency Cutting Reimbursement by 25% for Many Medicaid Providers Starting July 1 | |
| [post_excerpt] => On March 29, 2016, KOCO.com reported that the Oklahoma Medicaid agency announced that it is cutting reimbursement rates to over 46,000 Medicaid providers by 25 percent at the start of the upcoming fiscal year, which begins July 1. The cuts are a result of declining state revenue collections and a $1.3 billion gap in next year’s state budget. The cuts are expected to affect contracts with 46,129 providers including hospitals, physicians, pharmacies, durable medical equipment providers and nursing facilities. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => 30086 | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-03-30 17:45:14 | |
| [post_modified_gmt] => 2016-03-30 21:45:14 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=30086 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [7] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 29628 | |
| [post_author] => 112 | |
| [post_date] => 2016-03-28 11:35:39 | |
| [post_date_gmt] => 2016-03-28 15:35:39 | |
| [post_content] => | |
| [post_title] => KS Announces Program to Help Nursing Homes with Medicaid Eligibility Processing Delays | |
| [post_excerpt] => Kansas Health Institute reported on March 25, 2016 that the Kansas Department of Health and Environment and the Kansas Department for Aging and Disability Services announced that they will allow some nursing facilities to petition for half-payments for some residents whose Medicaid applications or renewals are still processing. The state’s plan allows facilities to apply for advanced payments only for residents whose applications have been pending for 60 days or more, with priority to smaller facilities versus large, corporate-owned facilities. The processing delays began in July with a computer system switch and administrative changes in January. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => ks-announces-program-to-help-nursing-homes-with-medicaid-eligibility-processing-delays | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-03-30 17:39:55 | |
| [post_modified_gmt] => 2016-03-30 21:39:55 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=29628 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [8] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 36578 | |
| [post_author] => 112 | |
| [post_date] => 2016-05-19 15:19:51 | |
| [post_date_gmt] => 2016-05-19 19:19:51 | |
| [post_content] => | |
| [post_title] => Medicaid Plans Outperform in ACA Exchanges | |
| [post_excerpt] => CQ Healthbeat reported on May 18, 2016, that Medicaid plans are outperforming the the broader insurance industry on the Exchanges. Specifically, Centene and Molina both profited from their respective Exchange lines of business in 2015 and are considering expanding their market presence. The article notes that these plans generally have lower premiums, smaller networks, and lower provider reimbursement rates. Meanwhile, other insurers continue to struggle to adjust to the Exchange market, with United having announced it will pull out of many Exchange states. | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => medicaid-plans-outperform-health-exchanges | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-05-19 15:19:51 | |
| [post_modified_gmt] => 2016-05-19 19:19:51 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=36578 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| [9] => __PHP_Incomplete_Class Object | |
| ( | |
| [__PHP_Incomplete_Class_Name] => WP_Post | |
| [ID] => 35990 | |
| [post_author] => 112 | |
| [post_date] => 2016-05-13 12:52:08 | |
| [post_date_gmt] => 2016-05-13 16:52:08 | |
| [post_content] => Download NowUrban_Institute_Robert_Wood_Medicaid_CHIP_Children_Enrollment_Study_May-16.pdf | |
| [post_title] => Urban Institute Study Finds Health Coverage for Medicaid/CHIP Eligible Children Continues to Improve | |
| [post_excerpt] => Kaiser Health News reported on May 13, 2016, that according to a study by the Urban Institute with the support of the Robert Wood Johnson Foundation, health coverage for low income children is improving. In 2014, over 90 percent of children eligible for Medicaid/CHIP were enrolled. In the first year of the Affordable Cart Act's full implementation, the number of uninsured children dropped from 5.4 million to 4.5 million. Of the 4.5 million, nearly two-thirds were eligible for Medicaid or CHIP. In 2013, 88.7 percent of eligible children were enrolled, compared to 81.7 percent in 2008. In 2014, the largest coverage gains occurred in states that expanded Medicaid. However, progress has been slower for some groups, including adolescents between age 13 and 18 and Hispanic children in families without a parent who speaks English. Read More | |
| [post_status] => publish | |
| [comment_status] => closed | |
| [ping_status] => closed | |
| [post_password] => | |
| [post_name] => urban-institute-study-finds-health-coverage-medicaidchip-eligible-children-continues-improve | |
| [to_ping] => | |
| [pinged] => | |
| [post_modified] => 2016-05-13 12:52:08 | |
| [post_modified_gmt] => 2016-05-13 16:52:08 | |
| [post_content_filtered] => | |
| [post_parent] => 0 | |
| [guid] => https://hmais.healthmanagement.com/?p=35990 | |
| [menu_order] => 0 | |
| [post_type] => post | |
| [post_mime_type] => | |
| [comment_count] => 0 | |
| [filter] => raw | |
| ) | |
| ) | |
| [posts_weights] => Array | |
| ( | |
| [36569] => Array | |
| ( | |
| [post_id] => 36569 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [33083] => Array | |
| ( | |
| [post_id] => 33083 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [32547] => Array | |
| ( | |
| [post_id] => 32547 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [32084] => Array | |
| ( | |
| [post_id] => 32084 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [31149] => Array | |
| ( | |
| [post_id] => 31149 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [31214] => Array | |
| ( | |
| [post_id] => 31214 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [30086] => Array | |
| ( | |
| [post_id] => 30086 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [29628] => Array | |
| ( | |
| [post_id] => 29628 | |
| [weight] => 10 | |
| [post_types] => Array | |
| ( | |
| [post] => 10 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [36578] => Array | |
| ( | |
| [post_id] => 36578 | |
| [weight] => 9 | |
| [post_types] => Array | |
| ( | |
| [post] => 9 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| [35990] => Array | |
| ( | |
| [post_id] => 35990 | |
| [weight] => 9 | |
| [post_types] => Array | |
| ( | |
| [post] => 9 | |
| [page] => 0 | |
| [attachment] => 0 | |
| ) | |
| ) | |
| ) | |
| [post_count] => 10 | |
| [found_posts] => 141 | |
| [max_num_pages] => 15 | |
| [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID AS post_id, COALESCE(term1.`postweight`,0) AS `finalpostweight`, COALESCE(term1.`pageweight`,0) AS `finalpageweight`, COALESCE(term1.`attachmentweight`,0) AS `finalattachmentweight`, COALESCE(term1.`postweight`,0) + COALESCE(term1.`pageweight`,0) + COALESCE(term1.`attachmentweight`,0) AS finalweight FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN ( SELECT wp_posts.ID AS post_id , COALESCE(`postweight`,0) AS `postweight` , COALESCE(`pageweight`,0) AS `pageweight` , COALESCE(`attachmentweight`,0) AS `attachmentweight` , COALESCE(`postweight`,0) + COALESCE(`pageweight`,0) + COALESCE(`attachmentweight`,0) AS weight FROM wp_posts LEFT JOIN ( SELECT wp_posts.ID AS post_id, ( SUM( wp_swp_index.title ) * 5 ) + ( SUM( wp_swp_index.slug ) * 0 ) + ( SUM( wp_swp_index.content ) * 0 ) + ( SUM( wp_swp_index.comment ) * 0 ) + ( SUM( wp_swp_index.excerpt ) * 0 ) + 0 + 0 + COALESCE(taxweight0,0) AS `postweight` FROM wp_swp_terms LEFT JOIN wp_swp_index ON wp_swp_terms.id = wp_swp_index.term LEFT JOIN wp_posts ON wp_swp_index.post_id = wp_posts.ID LEFT JOIN ( SELECT wp_swp_tax.post_id, ( SUM( wp_swp_tax.count ) * 4 ) AS taxweight0 FROM wp_swp_terms LEFT JOIN wp_swp_tax ON wp_swp_terms.id = wp_swp_tax.term LEFT JOIN wp_posts ON wp_swp_tax.post_id = wp_posts.ID WHERE wp_swp_terms.term IN ('medicaid') AND wp_posts.post_status IN ( 'publish' ) AND wp_posts.post_type = 'post' AND wp_swp_tax.taxonomy IN ('category','post_tag') GROUP BY wp_swp_tax.post_id ) taxweights0 USING(post_id) WHERE wp_swp_terms.term IN ('medicaid') AND wp_posts.post_status IN ( 'publish' ) AND wp_posts.post_type = 'post' GROUP BY wp_posts.ID) AS `postweights` ON `postweights`.post_id = wp_posts.ID LEFT JOIN ( SELECT wp_posts.ID AS post_id, ( SUM( wp_swp_index.title ) * 4 ) + ( SUM( wp_swp_index.slug ) * 0 ) + ( SUM( wp_swp_index.content ) * 0 ) + ( SUM( wp_swp_index.comment ) * 0 ) + ( SUM( wp_swp_index.excerpt ) * 0 ) + 0 + 0 + COALESCE(taxweight0,0) AS `pageweight` FROM wp_swp_terms LEFT JOIN wp_swp_index ON wp_swp_terms.id = wp_swp_index.term LEFT JOIN wp_posts ON wp_swp_index.post_id = wp_posts.ID LEFT JOIN ( SELECT wp_swp_tax.post_id, ( SUM( wp_swp_tax.count ) * 3 ) AS taxweight0 FROM wp_swp_terms LEFT JOIN wp_swp_tax ON wp_swp_terms.id = wp_swp_tax.term LEFT JOIN wp_posts ON wp_swp_tax.post_id = wp_posts.ID WHERE wp_swp_terms.term IN ('medicaid') AND wp_posts.post_status IN ( 'publish' ) AND wp_posts.post_type = 'page' AND wp_swp_tax.taxonomy IN ('category','post_tag') GROUP BY wp_swp_tax.post_id ) taxweights0 USING(post_id) WHERE wp_swp_terms.term IN ('medicaid') AND wp_posts.post_status IN ( 'publish' ) AND wp_posts.post_type = 'page' GROUP BY wp_posts.ID) AS `pageweights` ON `pageweights`.post_id = wp_posts.ID LEFT JOIN ( SELECT wp_posts.ID AS post_id, ( SUM( wp_swp_index.title ) * 3 ) + ( SUM( wp_swp_index.slug ) * 0 ) + ( SUM( wp_swp_index.content ) * 0 ) + ( SUM( wp_swp_index.comment ) * 0 ) + ( SUM( wp_swp_index.excerpt ) * 0 ) + 0 + COALESCE(cfweight0,0) + 0 AS `attachmentweight` FROM wp_swp_terms LEFT JOIN wp_swp_index ON wp_swp_terms.id = wp_swp_index.term LEFT JOIN wp_posts ON wp_swp_index.post_id = wp_posts.ID LEFT JOIN ( SELECT wp_posts.ID as post_id, ( SUM( wp_swp_cf.count ) * 0 ) AS cfweight0 FROM wp_swp_terms LEFT JOIN wp_swp_cf ON wp_swp_terms.id = wp_swp_cf.term LEFT JOIN wp_posts ON wp_swp_cf.post_id = wp_posts.ID WHERE wp_swp_terms.term IN ('medicaid') AND wp_posts.post_status IN ( 'inherit' ) AND wp_posts.post_type = 'attachment' AND wp_swp_cf.metakey IN ('searchwp_content','searchwp_pdf_metadata') GROUP BY post_id ) cfweights0 USING(post_id) WHERE wp_swp_terms.term IN ('medicaid') AND wp_posts.post_status IN ( 'inherit' ) AND wp_posts.post_type = 'attachment' GROUP BY wp_posts.ID) AS `attachmentweights` ON `attachmentweights`.post_id = wp_posts.ID LEFT JOIN wp_swp_index ON wp_swp_index.post_id = wp_posts.ID LEFT JOIN wp_swp_terms ON wp_swp_terms.id = wp_swp_index.term WHERE COALESCE(`postweight`,0) + COALESCE(`pageweight`,0) + COALESCE(`attachmentweight`,0) > 0 AND ( ( wp_swp_terms.term IN ('medicaid') OR wp_swp_terms.stem IN ('medicaid') ) ) AND ( ( wp_posts.post_status IN ('publish') AND wp_posts.post_type IN ('post','page') ) OR wp_posts.post_type = 'attachment' ) GROUP BY post_id ) AS term1 ON term1.post_id = wp_posts.ID WHERE COALESCE(term1.`postweight`,0) + COALESCE(term1.`pageweight`,0) + COALESCE(term1.`attachmentweight`,0) > 0 AND ( ( wp_posts.post_status IN ('publish') AND wp_posts.post_type IN ('post','page') ) OR wp_posts.post_type = 'attachment' ) AND ( ( wp_term_relationships.term_taxonomy_id IN (189) AND ( tt1.term_taxonomy_id IN (189) OR tt1.term_taxonomy_id IN (190) ) ) ) AND wp_posts.ID IN (term1.post_id) GROUP BY wp_posts.ID ORDER BY finalweight DESC, post_date DESC LIMIT 0, 10 | |
| ) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment