SELECT *
FROM CustomerFeatured, Customer, Services, Servers
WHERE CustomerFeatured.CustomerID = Customer.CustomerID
AND CustomerFeatured.ServiceID = Services.ServiceID
AND Services.Server = Servers.id
AND Services.Name = 'nzsurfcam2'
results: nzsurfcam2 Array
(
[0] => 3
[id] => 2230
[1] => 2886
[CustomerID] => 2886
[2] => 9333
[ServiceID] => 9333
[3] => http://sumnersurf.nz/
[URL] => http://sumnersurf.nz/
[4] => https://www.google.com/maps/place/Sumner+Beach/@-43.5676467,172.7516942,15z/data=!4m8!1m2!2m1!1ssumner+beach+surf+cam!3m4!1s0x6d3228216314616b:0x98ec5c2d7e0e684a!8m2!3d-43.5658413!4d172.7583118
[MapURL] => https://www.google.com/maps/place/Sumner+Beach/@-43.5676467,172.7516942,15z/data=!4m8!1m2!2m1!1ssumner+beach+surf+cam!3m4!1s0x6d3228216314616b:0x98ec5c2d7e0e684a!8m2!3d-43.5658413!4d172.7583118
[5] => -43.567646
[latitude] => -43.567646
[6] => 172.751694
[longitude] => 172.751694
[7] => 1
[isWebCam] => 1
[8] => 1
[isBGcam] => 1
[9] => 1
[isNightCam] => 1
[10] => Sumner Beach Surf Cam, New Zealand
[title] => Sumner Beach Surf Cam, New Zealand
[11] => Sumner Surf Cams in New Zealand came to Brownrice after their existing host unexpectedly and dramatically raised their rates. They were concerned that we'd charge them a lot as well since they receive a quite a bit of traffic. Nope, their webcams are just $14.95 per month like everyone else's!
[long_desc] => Sumner Surf Cams in New Zealand came to Brownrice after their existing host unexpectedly and dramatically raised their rates. They were concerned that we'd charge them a lot as well since they receive a quite a bit of traffic. Nope, their webcams are just $14.95 per month like everyone else's!
[12] => 2886
[13] => 1
[companies_id] => 1
[14] =>
[account_number] =>
[15] => sumnersurf.nz
[CustomerName] => sumnersurf.nz
[16] =>
[full_name] =>
[17] =>
[Company] =>
[18] =>
[AddressLine1] =>
[19] =>
[AddressLine2] =>
[20] =>
[City] =>
[21] =>
[State] =>
[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] => 0
[automatic_billing_credit_card_id] => 0
[39] => 2019-12-16
[StartDate] => 2019-12-18
[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] => logan
[CreatedBy] => logan
[48] => oban
[ModifiedBy] => oban
[49] => 2025-01-02 10:48:09
[LastUpdated] => 2025-01-17 22:01:50
[50] => cus_GWFyEhqr2YsuBk
[stripe_customer_id] => cus_GWFyEhqr2YsuBk
[51] => 1
[stripe_autopay] => 1
[52] => 0
[is_ach] => 0
[53] => 1
[is_taxable] => 1
[54] =>
[special_status] =>
[55] => 9333
[56] => nzsurfcam2
[Name] => nzsurfcam2
[57] =>
[parent_service_id] =>
[58] => 2886
[59] => 1
[quantity] => 1
[60] => 35
[Type] => 35
[61] => 2230
[Server] => 2230
[62] => Online
[streamstatus] => Online
[63] => 0
[streamviewers] => 0
[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] => 2019-12-18
[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] => logan
[95] => 2025-01-17 22:01:50
[96] => 0
[is_imported] => 0
[97] => disable for non-payment
[cancel_note] => disable for non-payment
[98] => 2023-08-31
[cancel_date] => 2023-08-31
[99] => 2230
[100] => streamer2.brownrice.com
[servername] => streamer2.brownrice.com
[101] => 0
[UID] => 0
[102] => 0c:c4:7a:d4:5b:04
[MAC] => 0c:c4:7a:d4:5b:04
[103] => 0
[is_default] => 0
[104] => 172.97.100.202
[virt_ip] => 172.97.100.202
[105] => 0.0.0.0
[lan_ip] => 0.0.0.0
[106] => 0.0.0.0
[bmc_ip] => 0.0.0.0
[107] => streamer2 streaming server in Taos
[description] => streamer2 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] => 2
[isWowza] => 2
[114] => https://streamer2.brownrice.com
[streamURL] => https://streamer2.brownrice.com
[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
)
Sumner Beach Surf Cam, New Zealand
Sumner Surf Cams in New Zealand came to Brownrice after their existing host unexpectedly and dramatically raised their rates. They were concerned that we'd charge them a lot as well since they receive a quite a bit of traffic. Nope, their webcams are just $14.95 per month like everyone else's!