SELECT *
FROM CustomerFeatured, Customer, Services, Servers
WHERE CustomerFeatured.CustomerID = Customer.CustomerID
AND CustomerFeatured.ServiceID = Services.ServiceID
AND Services.Server = Servers.id
AND Services.Name = 'southlighthouse'
results: southlighthouse Array
(
[0] => 38
[id] => 6975
[1] => 7641
[CustomerID] => 7641
[2] => 17416
[ServiceID] => 17416
[3] => https://www.hillsborolighthouse.org/
[URL] => https://www.hillsborolighthouse.org/
[4] => https://www.google.com/maps/place/Hillsboro+Inlet+Lighthouse/@26.2594915,-80.083565,17z
[MapURL] => https://www.google.com/maps/place/Hillsboro+Inlet+Lighthouse/@26.2594915,-80.083565,17z
[5] => 26.259491
[latitude] => 26.259491
[6] => -80.083565
[longitude] => -80.083565
[7] => 1
[isWebCam] => 1
[8] => 1
[isBGcam] => 1
[9] => 1
[isNightCam] => 1
[10] => Hillsboro Inlet Lighthouse
[title] => Hillsboro Inlet Lighthouse
[11] => The Hillsboro Inlet Lighthouse has two, incredible webcams atop their historic building - one facing north and one facing south. We love Lighthouse Cameras!
[long_desc] => The Hillsboro Inlet Lighthouse has two, incredible webcams atop their historic building - one facing north and one facing south. We love Lighthouse Cameras!
[12] => 7641
[13] => 1
[companies_id] => 1
[14] =>
[account_number] =>
[15] => Hillsboro Lighthouse Preservation Society
[CustomerName] => Hillsboro Lighthouse Preservation Society
[16] =>
[full_name] =>
[17] => Hillsboro Lighthouse Preservation Society
[Company] => Hillsboro Lighthouse Preservation Society
[18] => P.O. Box 326
[AddressLine1] => P.O. Box 326
[19] =>
[AddressLine2] =>
[20] => Pompano Beach
[City] => Pompano Beach
[21] => FL
[State] => FL
[22] =>
[Zip] =>
[23] => US
[Country] => US
[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] => 2023-03-08
[StartDate] => 2023-03-08
[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] => One camera streaming account free, per Oban
[Notes] => One camera streaming account free, per Oban
[47] => olambie
[CreatedBy] => olambie
[48] =>
[ModifiedBy] =>
[49] => 2025-01-02 10:55:56
[LastUpdated] => 2025-01-17 22:14:11
[50] => cus_ODKravV2M6Ipjw
[stripe_customer_id] => cus_ODKravV2M6Ipjw
[51] => 0
[stripe_autopay] => 0
[52] => 0
[is_ach] => 0
[53] => 1
[is_taxable] => 1
[54] =>
[special_status] =>
[55] => 17416
[56] => southlighthouse
[Name] => southlighthouse
[57] =>
[parent_service_id] =>
[58] => 7641
[59] => 1
[quantity] => 1
[60] => 72
[Type] => 72
[61] => 6975
[Server] => 6975
[62] => Online
[streamstatus] => Online
[63] => 3
[streamviewers] => 3
[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] => 2023-03-08
[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] => olambie
[95] => 2025-01-17 22:14:11
[96] => 0
[is_imported] => 0
[97] =>
[cancel_note] =>
[98] => 0000-00-00
[cancel_date] => 0000-00-00
[99] => 6975
[100] => streamer5.brownrice.com
[servername] => streamer5.brownrice.com
[101] => 0
[UID] => 0
[102] =>
[MAC] =>
[103] => 0
[is_default] => 0
[104] => 172.97.100.97
[virt_ip] => 172.97.100.97
[105] => 0.0.0.0
[lan_ip] => 0.0.0.0
[106] => 0.0.0.0
[bmc_ip] => 0.0.0.0
[107] => streamer5 streaming server in Taos
[description] => streamer5 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://streamer5.brownrice.com
[streamURL] => https://streamer5.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
)
Hillsboro Inlet Lighthouse
Pompano Beach, FL
https://www.hillsborolighthouse.org/
The Hillsboro Inlet Lighthouse has two, incredible webcams atop their historic building - one facing north and one facing south. We love Lighthouse Cameras!