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 = 'nrcmississippi'
results: nrcmississippi
Array
(
    [0] => 36
    [id] => 106
    [1] => 5449
    [CustomerID] => 5449
    [2] => 12813
    [ServiceID] => 12813
    [3] => https://www.rivermuseum.com/webcams
    [URL] => https://www.rivermuseum.com/webcams
    [4] => https://www.google.com/maps/place/National+Mississippi+River+Museum+%26+Aquarium/@42.4968909,-90.6635667,17z/data=!3m1!4b1!4m5!3m4!1s0x87e32b96f3a63363:0x68e161b6c4dcbb4d!8m2!3d42.496887!4d-90.661378
    [MapURL] => https://www.google.com/maps/place/National+Mississippi+River+Museum+%26+Aquarium/@42.4968909,-90.6635667,17z/data=!3m1!4b1!4m5!3m4!1s0x87e32b96f3a63363:0x68e161b6c4dcbb4d!8m2!3d42.496887!4d-90.661378
    [5] => 42.496891
    [latitude] => 42.496891
    [6] => -90.663567
    [longitude] => -90.663567
    [7] => 1
    [isWebCam] => 1
    [8] => 1
    [isBGcam] => 1
    [9] => 0
    [isNightCam] => 0
    [10] => Mississippi River Webcam
    [title] => Mississippi River Webcam
    [11] => Enjoy looking out from the Port of Dubuque, Iowa, at the Ice Harbor, flood wall, Julien Dubuque Bridge, and the Mighty Mississippi. This webcam is located at the top of the River Museum's National River Center.
    [long_desc] => Enjoy looking out from the Port of Dubuque, Iowa, at the Ice Harbor, flood wall, Julien Dubuque Bridge, and the Mighty Mississippi. This webcam is located at the top of the River Museum's National River Center.
    [12] => 5449
    [13] => 1
    [companies_id] => 1
    [14] => 
    [account_number] => 
    [15] => rivermuseum.com
    [CustomerName] => rivermuseum.com
    [16] => 
    [full_name] => 
    [17] => rivermuseum.com
    [Company] => rivermuseum.com
    [18] => 
    [AddressLine1] => 
    [19] => 
    [AddressLine2] => 
    [20] => Debuque
    [City] => Debuque
    [21] => Iowa
    [State] => Iowa
    [22] => 52001
    [Zip] => 52001
    [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] => 2020-04-03
    [StartDate] => 2020-04-03
    [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] => Free streaming trial
    [Notes] => Free streaming trial
    [47] => nkappen
    [CreatedBy] => nkappen
    [48] => 
    [ModifiedBy] => 
    [49] => 2025-01-02 10:48:49
    [LastUpdated] => 2025-01-19 14:52:14
    [50] => cus_HjnmQdtSgvRVtW
    [stripe_customer_id] => cus_HjnmQdtSgvRVtW
    [51] => 1
    [stripe_autopay] => 1
    [52] => 0
    [is_ach] => 0
    [53] => 1
    [is_taxable] => 1
    [54] => 
    [special_status] => 
    [55] => 12813
    [56] => nrcmississippi
    [Name] => nrcmississippi
    [57] => 
    [parent_service_id] => 
    [58] => 5449
    [59] => 1
    [quantity] => 1
    [60] => 35
    [Type] => 35
    [61] => 106
    [Server] => 106
    [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] => 2020-04-03
    [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] => nkappen
    [95] => 2025-01-19 14:52: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
)

Mississippi River Webcam

Debuque, Iowa
https://www.rivermuseum.com/webcams

Enjoy looking out from the Port of Dubuque, Iowa, at the Ice Harbor, flood wall, Julien Dubuque Bridge, and the Mighty Mississippi. This webcam is located at the top of the River Museum's National River Center.

Get Started