sql:
SELECT *
        FROM CustomerFeatured, Customer, Services, Servers
        WHERE CustomerFeatured.CustomerID = Customer.CustomerID
            AND CustomerFeatured.ServiceID = Services.ServiceID
            AND Services.Server = Servers.id
            AND Services.Name = 'delraybeach1'
results: delraybeach1
Array
(
    [0] => 33
    [id] => 6975
    [1] => 2664
    [CustomerID] => 2664
    [2] => 8372
    [ServiceID] => 8372
    [3] => http://www.mydelraybeach.com/
    [URL] => http://www.mydelraybeach.com/
    [4] => https://www.google.com/maps/place/Delray+Beach,+FL/@26.4560452,-80.1097264,14z/data=!3m1!4b1!4m5!3m4!1s0x88d8dffc90ec6ae3:0xc7780128536eb8b8!8m2!3d26.4614625!4d-80.0728201
    [MapURL] => https://www.google.com/maps/place/Delray+Beach,+FL/@26.4560452,-80.1097264,14z/data=!3m1!4b1!4m5!3m4!1s0x88d8dffc90ec6ae3:0xc7780128536eb8b8!8m2!3d26.4614625!4d-80.0728201
    [5] => 26.456045
    [latitude] => 26.456045
    [6] => -80.109726
    [longitude] => -80.109726
    [7] => 1
    [isWebCam] => 1
    [8] => 1
    [isBGcam] => 1
    [9] => 1
    [isNightCam] => 1
    [10] => City of Delray Beach - Beach cam
    [title] => City of Delray Beach - Beach cam
    [11] => Looking for an affordable webcam hosting provider the City of Delray Beach came to us with their camera specs and had a streaming, PTZ service up and online within minutes.
    [long_desc] => Looking for an affordable webcam hosting provider the City of Delray Beach came to us with their camera specs and had a streaming, PTZ service up and online within minutes.
    [12] => 2664
    [13] => 1
    [companies_id] => 1
    [14] => 
    [account_number] => 
    [15] => delraybeach1
    [CustomerName] => delraybeach1
    [16] => 
    [full_name] => 
    [17] => City of Delray Beach
    [Company] => City of Delray Beach
    [18] => 100 NW 1st Avenue
    [AddressLine1] => 100 NW 1st Avenue
    [19] => 
    [AddressLine2] => 
    [20] => Delray Beach
    [City] => Delray Beach
    [21] => FL
    [State] => FL
    [22] => 33444
    [Zip] => 33444
    [23] => 
    [Country] => 
    [24] => 15612437190
    [WorkNumber] => 15612437190
    [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-01-10
    [StartDate] => 2019-01-10
    [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] => tucker
    [ModifiedBy] => tucker
    [49] => 2025-01-02 10:45:26
    [LastUpdated] => 2025-01-17 21:53:53
    [50] => cus_Gi5EIhHHl9Ddlz
    [stripe_customer_id] => cus_Gi5EIhHHl9Ddlz
    [51] => 1
    [stripe_autopay] => 1
    [52] => 0
    [is_ach] => 0
    [53] => 1
    [is_taxable] => 1
    [54] => 
    [special_status] => 
    [55] => 8372
    [56] => delraybeach1
    [Name] => delraybeach1
    [57] => 
    [parent_service_id] => 
    [58] => 2664
    [59] => 1
    [quantity] => 1
    [60] => 110
    [Type] => 110
    [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] => 2019-01-10
    [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 21:53:53
    [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
)

City of Delray Beach - Beach cam

Delray Beach, FL
http://www.mydelraybeach.com/

Looking for an affordable webcam hosting provider the City of Delray Beach came to us with their camera specs and had a streaming, PTZ service up and online within minutes.

Get Started