SELECT *
FROM CustomerFeatured, Customer, Services, Servers
WHERE CustomerFeatured.CustomerID = Customer.CustomerID
AND CustomerFeatured.ServiceID = Services.ServiceID
AND Services.Server = Servers.id
AND Services.Name = 'sugarbeach1'
results: sugarbeach1 Array
(
[0] => 1
[id] => 106
[1] => 1561
[CustomerID] => 1561
[2] => 3889
[ServiceID] => 3889
[3] => http://sugarbeachwebcam.com
[URL] => http://sugarbeachwebcam.com
[4] => https://www.google.com/maps/place/Sugar+Beach+Resort/@20.8134035,-156.4646363,3502a,20y,180h,40.91t/data=!3m1!1e3!4m5!3m4!1s0x7954d1a5eddbe52f:0xe2e0bf2eebaaa558!8m2!3d20.7853583!4d-156.4672957
[MapURL] => https://www.google.com/maps/place/Sugar+Beach+Resort/@20.8134035,-156.4646363,3502a,20y,180h,40.91t/data=!3m1!1e3!4m5!3m4!1s0x7954d1a5eddbe52f:0xe2e0bf2eebaaa558!8m2!3d20.7853583!4d-156.4672957
[5] => 20.785358
[latitude] => 20.785358
[6] => -156.607376
[longitude] => -156.607376
[7] => 1
[isWebCam] => 1
[8] => 1
[isBGcam] => 1
[9] => 0
[isNightCam] => 0
[10] => The Sugar Beach Web Cam
[title] => The Sugar Beach Web Cam
[11] => "We were directed to Brownrice by another WebCam owner. We are happy with the choice. Less expensive than a lot of other WebCam hosts and they have always taken care of any concern quickly and pleasantly."
CapnJohn
Webmaster, Sugarbeach Web Cam
[long_desc] => "We were directed to Brownrice by another WebCam owner. We are happy with the choice. Less expensive than a lot of other WebCam hosts and they have always taken care of any concern quickly and pleasantly."
CapnJohn
Webmaster, Sugarbeach Web Cam
[12] => 1561
[13] => 1
[companies_id] => 1
[14] =>
[account_number] =>
[15] => sugarbeachresortmaui.com
[CustomerName] => sugarbeachresortmaui.com
[16] =>
[full_name] =>
[17] => Sugar Beach Resort
[Company] => Sugar Beach Resort
[18] => 700 Kapiuolani Blvd. #700
[AddressLine1] => 700 Kapiuolani Blvd. #700
[19] =>
[AddressLine2] =>
[20] => Honolulu
[City] => Honolulu
[21] => HI
[State] => HI
[22] => 96813
[Zip] => 96813
[23] => US
[Country] => US
[24] => 18088797765
[WorkNumber] => 18088797765
[25] =>
[FaxNumber] =>
[26] => 0
[HomeNumber] => 0
[27] => 18082508066
[MobilNumber] => 18082508066
[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] => 0
[automatic_billing_credit_card_id] => 0
[39] => 2014-02-20
[StartDate] => 2014-02-20
[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] => oban
[48] => oban
[ModifiedBy] => oban
[49] => 2025-01-02 10:34:50
[LastUpdated] => 2025-01-17 21:54:17
[50] =>
[stripe_customer_id] =>
[51] => 0
[stripe_autopay] => 0
[52] => 0
[is_ach] => 0
[53] => 1
[is_taxable] => 1
[54] =>
[special_status] =>
[55] => 3889
[56] => sugarbeach1
[Name] => sugarbeach1
[57] =>
[parent_service_id] =>
[58] => 1561
[59] => 1
[quantity] => 1
[60] => 35
[Type] => 35
[61] => 106
[Server] => 106
[62] => Online
[streamstatus] => Online
[63] => 8
[streamviewers] => 8
[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] => 0
[phpversion] => 0
[77] => 0
[mysqlversion] => 0
[78] =>
[ctid] =>
[79] => 0
[cust_serverid] => 0
[80] => 0
[cacti_graphid] => 0
[81] => 0
[libre_graphid] => 0
[82] => 2014-02-20
[83] => 0000-00-00
[84] => 2016-07-01
[LastChargeDate] => 2016-07-01
[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] => oban
[95] => 2025-01-17 21:54:17
[96] => 0
[is_imported] => 0
[97] => Check for payment
[cancel_note] => Check for payment
[98] => 2024-08-28
[cancel_date] => 2024-08-28
[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
)
The Sugar Beach Web Cam
Honolulu, HI
http://sugarbeachwebcam.com
"We were directed to Brownrice by another WebCam owner. We are happy with the choice. Less expensive than a lot of other WebCam hosts and they have always taken care of any concern quickly and pleasantly."
CapnJohn
Webmaster, Sugarbeach Web Cam