set @tankID = 'tv-top-left';
set @tankGroupID = 'tv';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=&AquListBoxTank=Choose&AquTankLength=24&AquTankDepth=12&AquTankHeight=16&AquListBoxFilter=User+Defined&AquTextFilterRate=50++++++++&AquFilterString=Kuhli&AquListBoxChooser=Black+Kuhli+%28Pangio+oblonga%29&AquTextBoxQuantity=1&FormSubmit=Add+%3E&AquTextBoxRemoveQuantity=&AlreadySelected=201002091347%3A16%3A%3A%2C200909300215%3A3%3A%3A%2C200909300153%3A1%3A%3A%2C200909300048%3A1%3A%3A%2C200912072116%3A5%3A%3A&FilterMode=Display+all+species&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=1&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-tall-aqueon', 10, 'top-left', null, 'Top Left', @tankGroupID, 1, 0, null, null, 150, 30, 100, 77, 78.8, 6.5, 7, 5, 15, @aqAdvisor);

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

/* filtration */
-- insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-35', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'dvhey-50-gallon-sponge', 1);

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

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'sparkling-gourami', 3, 2, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'emerald-dwarf-rasbora', 16, 0, 20);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'cockatoo-apisto', 1, 0, 25);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'pygmy-corydoras', 6, 6, 30);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'kuhli-loach-black', 6, 0, 30);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder, isTemporary) values (@tankID, 'pygmy-corydoras', 10, 9, 30, 1);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bristlenose-pleco', 1, 0, 4);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'otocinclus', 1, 1, 40);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-mystery', 'brown', 1, 1, 99);

/* feeding */

/* plants */

/* photos */
