Array
(
[0] => 9sm8
)
SELECT *,l.url as go_url,
i.instance_id as instance,
i.item_id as item,
i.account_id as account,
c.url as item_url
FROM link_instance i
INNER JOIN link l ON i.link_id = l.link_id
INNER JOIN account a ON i.account_id = a.account_id
LEFT JOIN content_item c ON i.item_id = c.item_id
WHERE i.link_instance_id = 456992
Array
(
[0] => 456992
[link_instance_id] => 456992
[1] => 131660
[link_id] => 131660
[2] => 1213
[account_id] => 1213
[3] => 203537
[instance_id] => 203537
[4] => 202755
[item_id] => 202755
[5] => 5580
[network_id] => 5580
[6] => 2015-03-04 11:30:25
[date_enter] => 2015-03-01 18:37:52
[7] =>
[utm_source] =>
[8] =>
[utm_medium] =>
[9] =>
[utm_term] =>
[10] =>
[utm_content] =>
[11] =>
[utm_campaign] =>
[12] =>
[url_fields] =>
[13] => 131660
[14] => http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html
[url] => http://stuf.in/b9rf3
[15] => 1213
[16] => 203537
[17] => 0
[parent_id] => 0
[18] => 202755
[19] =>
[key] =>
[20] => 2015-03-01 18:37:52
[21] => 0
[redirect_mode] => 0
[22] =>
[fb_obj_id] =>
[23] => 1213
[24] => Steve Trobiani
[account_name] => Steve Trobiani
[25] => StevenT
[account_label] => StevenT
[26] =>
[account_external_id] =>
[27] => StevenT
[username] => StevenT
[28] => Aleweb2013
[password] => Aleweb2013
[29] =>
[temp_password] =>
[30] => 1213@contentmx.com
[email] => 1213@contentmx.com
[31] => 1
[email_confirmed] => 1
[32] =>
[change_email_request] =>
[33] => 2013-07-12 20:44:57
[created] => 2013-07-12 20:44:57
[34] => America/New_York
[timezone] => America/New_York
[35] => en_US
[locale] => en_US
[36] => 0
[group_id] => 0
[37] => 0
[request_id] => 0
[38] => 1
[agree_to_license] => 1
[39] => 2013-07-13 02:05:12
[date_agree_to_license] => 2013-07-13 02:05:12
[40] => 0
[use_tag_filter] => 0
[41] => 33ceb07bf4eeb3da587e268d663aba1a
[account_token] => 33ceb07bf4eeb3da587e268d663aba1a
[42] => 0
[inherit_settings_from] => 0
[43] =>
[account_domain] =>
[44] => 1
[use_link_tracking] => 1
[45] => 1
[status_id] => 1
[46] => 0
[bill_status_id] => 0
[47] => 0
[profile_id] => 0
[48] =>
[exacttarget_user_id] =>
[49] =>
[exacttarget_refresh_token] =>
[50] =>
[exacttarget_legacy_token] =>
[51] =>
[exacttarget_json] =>
[52] => 0
[auto_post] => 0
[53] => 0000-00-00 00:00:00
[auto_post_lastrun] => 0000-00-00 00:00:00
[54] => 0000-00-00 00:00:00
[network_reconnect_reminder] => 0000-00-00 00:00:00
[55] => 0000-00-00 00:00:00
[network_content_collector] => 0000-00-00 00:00:00
[56] => 0000-00-00 00:00:00
[weekly_social_activity_report] => 0000-00-00 00:00:00
[57] => 0
[demo] => 0
[58] => 0000-00-00 00:00:00
[external_id_valid_date] => 0000-00-00 00:00:00
[59] => 0
[ecosystem_id] => 0
[60] => 0
[imported_account_id] => 0
[61] =>
[lead_score_calc] =>
[62] => 0
[is_notification_email_to_send] => 0
[63] => 0000-00-00 00:00:00
[notification_email_next_send_dtm] => 0000-00-00 00:00:00
[64] => 0000-00-00 00:00:00
[notification_email_last_send_dtm] => 0000-00-00 00:00:00
[65] => 0
[notification_last_send_id] => 0
[66] => 0
[partner_score] => 0
[67] =>
[partner_score_details] =>
[68] => 202755
[69] => 0
[content_id] => 0
[70] => 1213
[71] => 2
[type_id] => 2
[72] => Doctors are challenged to provide under #obamacare. http://stuf.in/b9rf3
[short_label] => Doctors are challenged to provide under #obamacare. http://stuf.in/b9rf3
[73] => Doctors are challenged to provide under #obamacare.
[short_label_original] => Doctors are challenged to provide under #obamacare.
[74] => Obamacare is creating a whole new set of challenges for doctors and their patients!
[long_status] => Obamacare is creating a whole new set of challenges for doctors and their patients!
[75] => 1
[use_long_status] => 1
[76] => South Florida doctors face new challenges in Obamacare system
[item_title] => South Florida doctors face new challenges in Obamacare system
[77] => Consumer misinformation, unreliable payments, added paperwork and increased patient loads are some of the challenges facing doctors who accept Obamacare health insurance plans.
[short_info] => Consumer misinformation, unreliable payments, added paperwork and increased patient loads are some of the challenges facing doctors who accept Obamacare health insurance plans.
[78] =>
[long_info] =>
[79] => http://stuf.in/b9rf3
[80] => http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html
[url_original] => http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html
[81] =>
[content_data] =>
[82] => 0
[media_id] => 0
[83] =>
[item_keywords] =>
[84] => 0000-00-00 00:00:00
[item_date] => 0000-00-00 00:00:00
[85] => 0
[parent_item_id] => 0
[86] => 0
[next_item_id] => 0
[87] => 0
[prev_item_id] => 0
[88] => 100
[rank] => 100
[89] => 1
[90] => 0
[source_id] => 0
[91] => 0
[origin_id] => 0
[92] =>
[external_id] =>
[93] => 0
[user_id] => 0
[94] =>
[reply_to_id] =>
[95] => http://www.miamiherald.com/news/local/community/miami-dade/2yx8r4/picture11337581/ALTERNATES/LANDSCAPE_1140/Talk%2023%20Bernd%20BIZ%20PAB.JPG
[thumbnail_url] => http://www.miamiherald.com/news/local/community/miami-dade/2yx8r4/picture11337581/ALTERNATES/LANDSCAPE_1140/Talk%2023%20Bernd%20BIZ%20PAB.JPG
[96] =>
[lead_generation_id] =>
[97] => 0
[unread] => 0
[98] => 0
[promotion_id] => 0
[99] => 0
[series_item_starter] => 0
[100] => 0
[is_series_starter] => 0
[101] =>
[schedule_id] =>
[102] => 0
[campaign_id] => 0
[103] =>
[publish_mode] =>
[104] => 0
[request_article_id] => 0
[105] =>
[creation_source] =>
[106] => 0
[newsletter_only] => 0
[107] => 0
[copied_from] => 0
[108] =>
[img_alt] =>
[109] =>
[attachments] =>
[110] =>
[event_id] =>
[111] =>
[disable_comments] =>
[112] =>
[properties] =>
[113] => 0
[content_group_id] => 0
[114] =>
[campaign_id_template] =>
[115] => 0
[md_item_id] => 0
[116] => http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html
[go_url] => http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html
[117] => 203537
[instance] => 203537
[118] => 202755
[item] => 202755
[119] => 1213
[account] => 1213
[120] => http://stuf.in/b9rf3
[item_url] => http://stuf.in/b9rf3
)
$row['go_url']:http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html
$row['item_url']:http://stuf.in/b9rf3
$go_url:http://www.miamiherald.com/news/local/community/miami-dade/article11337584.html-- $page_url:https://contentmx.com/k/page/page.php?u=StevenT&i=203537&li=456992