select as item_id, mcc_items.item_desc as item_desc, as item_channel, mcc_items.item_title as item_title, mcc_items.date_begin as date_begin, mcc_items.date_begin as date_end, mcc_items.date_updated as date_updated, mcc_items_channelspermanent.permalink as permalink, mcc_items.item_html as item_html, mcc_items_channels.order_id as order_id, mcc_channels.center_url as returnlinkpage, as active, mcc_items.item_sub_title as item_sub_title, mcc_items.item_media as item_media, mcc_items.metatitle as metatitle, mcc_items.metadescription as metadesc, mcc_items.metakeywords as metakeywords from mcc_items inner join mcc_items_channels on ( left join mcc_channels on ( left join mcc_items_channelspermanent on ( and left join properties on ( WHERE 1=1 AND in (986) and mcc_items_channelspermanent.permalink='press/terranea-resort-leverages-klout-to-launch-innovative-marketing-campaign' and (( ) group by order by mcc_items_channels.order_id , mcc_items.date_begin desc, mcc_items.item_titletest