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