insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("aquaneat-12-16", "aquaneat", 'LED Full Spectrum (12-16")', 750, 15, 0, 0, "LED", "22x 6500K white, 4x blue, 2x pink, 2x green", '', 12, 16, "aquaneat-12.jpg", "https://www.amazon.com/gp/product/B07G91RKC7/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("aquaneat-18-24", "aquaneat", 'LED Full Spectrum (18-24")', 0, 21, 0, 0, "LED", "30x 6500K white, 6x blue, 3x pink, 3x green", '', 18, 24, "aquaneat-12.jpg", "https://www.amazon.com/gp/product/B07T9Y7LQ4/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("aquaneat-30-38", "aquaneat", 'LED Full Spectrum (30-38")', 1800, 36, 0, 0,"LED", "52x 6500K white, 10x blue, 5x pink, 5x green", '', 30, 38, "aquaneat-12.jpg", "https://www.amazon.com/gp/product/B07G91L6FV/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("aquaneat-48", "aquaneat", 'LED Blue/White (48")', 0, 16, 0, 0, "LED", "Blue + White", '', 48, 48, "aquaneat-12.jpg", "" );


insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("beamswork-30", "beamswork", '30" DA80 DA FSPEC', 4800, 45, 15, 3, "LED", "Full spectrum (80 LED, 0.5w ea)", 'DA 80 FSPEC - 80x 5730 LEDS (51x 10000K, 16x 460nm Blue, 7x 660nm Red, 6x Green).', 30, 30, "beamswork.jpg", "https://www.amazon.com/gp/product/B0CZBN7QMN/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("beamswork-36", "beamswork", '36" DA90 DA FSPEC', 5000, 47, 15, 4, "LED", "Full spectrum (100 LED, 0.5w ea)", 'DA 90 FSPEC - 100x 5730 LEDS (51x 10000K, 16x 460nm Blue, 7x 660nm Red, 6x Green).', 36, 36, "beamswork.jpg", "https://www.amazon.com/gp/product/B0CZBGHG1Y/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("beamswork-48", "beamswork", '48" DA120 DA SPEC', 5200, 50, 15, 4, "LED", "Full spectrum (120 LED, 0.5w ea)", 'DA 120 FSPEC - 120x 5730 LEDS (86x 10000K, 16x 460nm Blue, 9x 660nm Red, 9x Green).', 48, 48, "beamswork.jpg", "https://www.amazon.com/gp/product/B0CZBSL88Q/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("beamswork-72", "beamswork", 'DA FSPEC LED Aquarium Light Pent Freshwater (180cm - 72")', 8000, 66, 0, 0, "LED", "102x 10000K, 32x Actinic 460nm, 22x Red 620nm, 26x Green 520nm", 'DA 180 FSPEC - 200x 5730 LEDS (132x 10000K, 32x 460nm Blue, 18x 660nm Red, 18x Green).', 72, 72, "beamswork.jpg", "https://www.amazon.com/gp/product/B0CZBJ6WZC/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1" );


insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("fishkeeper-37-43", "fishkeeper", '37-43"', 0, 29, 0, 0, "LED", "Full Spectrum", '', 37, 43, "fishkeeper-48.jpg", "https://www.amazon.com/dp/B0FBWSDYP9?ref=ppx_yo2ov_dt_b_fed_asin_title&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("fishkeeper-48", "fishkeeper", '48"', 0, 55, 0, 0, "LED", "Full Spectrum", '', 48, 48, "fishkeeper-48.jpg", "https://www.amazon.com/gp/product/B0BK8DDH4X/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1" );


-- insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
--     ("barrina-48", "barrina", '48"', 0, 72, 0, 0, "LED", "Full Spectrum", '', 48, 48, "barrina-48.jpg", "https://www.amazon.com/dp/B0C2GWCJS5?ref_=ppx_hzsearch_conn_dt_b_fed_asin_title_1" );


insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("asoko-led-strip-12w", "asoko", '3x12"', 0, 12, 0, 0, "LED", "Cold White", '', 12, 36, "asoko.jpg", "https://www.amazon.com/dp/B09H7LN269?ref_=ppx_hzsearch_conn_dt_b_fed_asin_title_2&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("asoko-led-strip-18w", "asoko", '5x12"', 0, 18, 0, 0, "LED", "Cold White", '', 12, 60, "asoko.jpg", "https://www.amazon.com/dp/B09H7LN269?ref_=ppx_hzsearch_conn_dt_b_fed_asin_title_2&th=1" );

insert into lights (lightID, manufacturerID, model, lumens, watts, volts, amps, type, config, details, minWidth, maxWidth, image, link) values
    ("asoko-led-strip-27w", "asoko", '6x12"', 0, 27, 0, 0, "LED", "Cold White", '', 12, 72, "asoko.jpg", "https://www.amazon.com/dp/B09H7LN269?ref_=ppx_hzsearch_conn_dt_b_fed_asin_title_2&th=1" );
