set @tankID = 'entryway-top-left';
set @tankGroupID = 'entryway';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=entryway-top-left&AquListBoxTank=Choose&AquTankLength=30&AquTankDepth=12&AquTankHeight=12&AquListBoxFilter=User+Defined&AquTextFilterRate=35++++&AquListBoxFilter2=User+Defined&AquTextFilterRate2=50++++&AquFilterString=celebes&AquListBoxChooser=Celebes+Halfbeak+%28Nomorhamphus+liemi%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=4&FormSubmit=%3C+Remove&AquListBoxSelected=20+x+White+Cloud+Mountain+Minnow+%28Tanichthys+albonubes%29&AlreadySelected=200912111346%3A1%3A%3A%2C200909300097%3A1%3A%3A%2C200912141925%3A1%3A%3A%2C200909300241%3A20%3A%3A%2C200912011169%3A5%3A%3A&FilterMode=Display+all+species&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=2&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple';


insert into tanks (tankID, tankSizeID, sortOrder, url, photo, label, tankGroupID, isReady, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (
        @tankID,
        '20-long-aqueon',
        10,
        'top-left',
        null,
        'Top Left',
        @tankGroupID,
        1,
        0,
        'thievel-min-max',
        null,
        178,
        49,
        106,
        73.4,
        75.2,
        7,
        7.5,
        8,
        12,
        @aqAdvisor
    );

/* lighting */
insert into tankLights (tankID, lightID, intensity) values (@tankID, 'aquaneat-30-38', 100);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-55', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'aquaneat-corner-double-sponge', 2);

/* pumps */
insert into airPumpGroupTanks (airPumpGroupID, tankID, sponge) values ('entryway-pump1', @tankID, 'main');

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'platinum-halfbeak', 5, 3, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'paradise-gourami', 1, 1, 15);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bloodfin-tetra', 10, 0, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'white-cloud-mountain-minnow', 12, 12, 30);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'white-cloud-mountain-minnow', 'golden', 3, 3, 30);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'orange-venezuelan-corydoras', 4, 4, 45);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'hillstream-loach', 1, 1, 50);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'clown-pleco', 1, 1, 60);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'otocinclus', 1, 1, 60);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'red-spotted', 1, 1, 70);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'zebra', 1, 1, 70);

/* feeding */

/* plants */

/* photos */
