SELECT *
FROM CustomerFeatured, Customer, Services, Servers
WHERE CustomerFeatured.CustomerID = Customer.CustomerID
AND CustomerFeatured.ServiceID = Services.ServiceID
AND Services.Server = Servers.id
AND Services.Name = 'lebanon1'
results: lebanon1 Array
(
[0] => 31
[id] => 106
[1] => 2634
[CustomerID] => 2634
[2] => 16933
[ServiceID] => 16933
[3] => http://www.wkrn.com
[URL] => http://www.wkrn.com
[4] => https://www.google.com/maps/place/WKRN-TV/@36.1429781,-86.7481505,17z/data=!3m1!4b1!4m5!3m4!1s0x8864660356ca5acb:0x8714bf851d02f628!8m2!3d36.1429781!4d-86.7459565
[MapURL] => https://www.google.com/maps/place/WKRN-TV/@36.1429781,-86.7481505,17z/data=!3m1!4b1!4m5!3m4!1s0x8864660356ca5acb:0x8714bf851d02f628!8m2!3d36.1429781!4d-86.7459565
[5] => 36.142838
[latitude] => 36.142838
[6] => -86.748344
[longitude] => -86.748344
[7] => 1
[isWebCam] => 1
[8] => 1
[isBGcam] => 1
[9] => 1
[isNightCam] => 1
[10] => WKRN.com Traffic Cam
[title] => WKRN.com Traffic Cam
[11] => WKRN TV in Nashville, TN moved all of their live traffic webcams to Brownrice from another, more expensive provider.
[long_desc] => WKRN TV in Nashville, TN moved all of their live traffic webcams to Brownrice from another, more expensive provider.
[12] => 2634
[13] => 1
[companies_id] => 1
[14] =>
[account_number] =>
[15] => wkrn.com
[CustomerName] => wkrn.com
[16] =>
[full_name] =>
[17] =>
[Company] =>
[18] =>
[AddressLine1] =>
[19] =>
[AddressLine2] =>
[20] => Nashville
[City] => Nashville
[21] => TN
[State] => TN
[22] =>
[Zip] =>
[23] =>
[Country] =>
[24] => 0
[WorkNumber] => 0
[25] =>
[FaxNumber] =>
[26] => 0
[HomeNumber] => 0
[27] => 0
[MobilNumber] => 0
[28] =>
[username] =>
[29] =>
[password] =>
[30] =>
[password_dev] =>
[31] => checked
[Status] => checked
[32] => 0
[MFARequired] => 0
[33] =>
[Jwebbpurchase] =>
[34] => 0.00
[Xynergypurchase] => 0.00
[35] => 1
[support_status_id] => 1
[36] => quarterly
[billing_interval] => quarterly
[37] =>
[pending_interval] =>
[38] => 8314
[automatic_billing_credit_card_id] => 8314
[39] => 2018-11-15
[StartDate] => 2022-11-07
[40] => 0000-00-00
[EndDate] => 0000-00-00
[41] => 2025-01-02
[LastBillDate] => 2025-01-02
[42] => 0
[NotifyOnPayment] => 0
[43] => 0
[ReferrerID] => 0
[44] =>
[hear_about_us] =>
[45] =>
[Registrar] =>
[46] =>
[Notes] =>
[47] => oban
[CreatedBy] => cleger
[48] => oban
[ModifiedBy] => oban
[49] => 2025-01-02 10:45:09
[LastUpdated] => 2025-01-17 21:40:14
[50] => cus_GnNhWAqa5ey5eJ
[stripe_customer_id] => cus_GnNhWAqa5ey5eJ
[51] => 1
[stripe_autopay] => 1
[52] => 0
[is_ach] => 0
[53] => 1
[is_taxable] => 1
[54] =>
[special_status] =>
[55] => 16933
[56] => lebanon1
[Name] => lebanon1
[57] =>
[parent_service_id] =>
[58] => 2634
[59] => 1
[quantity] => 1
[60] => 139
[Type] => 139
[61] => 106
[Server] => 106
[62] => Online
[streamstatus] => Online
[63] => 1
[streamviewers] => 1
[64] =>
[ostemplate] =>
[65] =>
[os_release] =>
[66] =>
[vpsstatus] =>
[67] => 0.00
[vps_loadave] => 0.00
[68] => 0
[vps_cpus] => 0
[69] => 0
[vps_cpuunits] => 0
[70] => 0.00
[vps_disk] => 0.00
[71] => 0
[vps_ram] => 0
[72] => 1
[vps_keep_snapshots_num_days] => 1
[73] =>
[vps_uuid] =>
[74] => 0
[notune] => 0
[75] => 0
[autoscale] => 0
[76] =>
[phpversion] =>
[77] =>
[mysqlversion] =>
[78] =>
[ctid] =>
[79] => 0
[cust_serverid] => 0
[80] => 0
[cacti_graphid] => 0
[81] => 0
[libre_graphid] => 0
[82] => 2022-11-07
[83] => 0000-00-00
[84] => 0000-00-00
[LastChargeDate] => 0000-00-00
[85] => 0
[has_image] => 0
[86] => 0
[ignore_ip] => 0
[87] => 0000-00-00
[web_left_date] => 0000-00-00
[88] => 0000-00-00
[web_verified_date] => 0000-00-00
[89] => 0000-00-00
[mail_verified_date] => 0000-00-00
[90] => 0000-00-00
[mail_left_date] => 0000-00-00
[91] => 0000-00-00
[service_end] => 0000-00-00
[92] => 0
[delreasonid] => 0
[93] =>
[change_notes] =>
[94] => cleger
[95] => 2025-01-17 21:40:14
[96] => 0
[is_imported] => 0
[97] =>
[cancel_note] =>
[98] => 0000-00-00
[cancel_date] => 0000-00-00
[99] => 106
[100] => live4.brownrice.com
[servername] => live4.brownrice.com
[101] => 0
[UID] => 0
[102] => 0c:c4:7a:7d:e0:3a
[MAC] => 0c:c4:7a:7d:e0:3a
[103] => 0
[is_default] => 0
[104] => 172.97.100.17
[virt_ip] => 172.97.100.17
[105] => 0.0.0.0
[lan_ip] => 0.0.0.0
[106] => 0.0.0.0
[bmc_ip] => 0.0.0.0
[107] => live4 streaming server in Taos
[description] => live4 streaming server in Taos
[108] =>
[public_description] =>
[109] => 1
[hosting_machine] => 1
[110] => 0
[service_id] => 0
[111] => 0
[virtualserver_host] => 0
[112] => 0
[is_privatevz] => 0
[113] => 1
[isWowza] => 1
[114] => https://5ddd47d64e730.streamlock.net:444
[streamURL] => https://5ddd47d64e730.streamlock.net:444
[115] => 0
[auto_create] => 0
[116] => 0
[include_in_newsite_form] => 0
[117] => 0
[default_hosting_server] => 0
[118] => 0
[default_vps_server] => 0
[119] => 0
[isSSD] => 0
[120] => 0
[ovzversion] => 0
[121] => 0
[decommissioned] => 0
)
WKRN.com Traffic Cam
Nashville, TN
http://www.wkrn.com
WKRN TV in Nashville, TN moved all of their live traffic webcams to Brownrice from another, more expensive provider.