set @tankID = 'long-wall-a-bottom-left-l';
set @waterType = 'f';
set @tankSizeID = '40-breeder-imagitarium-halved';
set @sortOrder = 130;
set @url = 'bottom-left-a';
set @photo = null;
set @label = 'Bottom Left (L)';
set @tankGroupID = 'long-wall-a';
set @isReady = 1;
set @isCichlidTank = 0;
set @substrateType = 'fs';
set @thermometerID = null;
set @heaterID = null;
set @filterPercent = 598;
set @waterChangePercent = 15;
set @stockPercent = 52;
set @tempLow = 73.4;
set @tempHigh = 80.6;
set @phLow = 6;
set @phHigh = 8;
set @hardnessLow = 5;
set @hardnessHigh = 20;
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=&AquListBoxTank=Choose&AquTankLength=18&AquTankDepth=18&AquTankHeight=16&AquListBoxFilter=User%20Defined&AquTextFilterRate=55&AquListBoxFilter2=User%20Defined&AquTextFilterRate2=50%20%20%20%20%20%20%20%20&AquFilterString=frog&AquListBoxChooser=African%20Clawed%20Frog%20%28Xenopus%20laevis%29&AquTextBoxQuantity=&AquTextBoxRemoveQuantity=&AlreadySelected=200911261033%3A3%3A%3A&FilterMode=Display%20all%20species&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple&&FilterQuantity=1&FormSubmit=AddFilter&';

insert into tanks (tankID, waterType, tankSizeID, sortOrder, url, photo, label, tankGroupID, isReady, substrateType, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (@tankID, @waterType, @tankSizeID, @sortOrder, @url, @photo, @label, @tankGroupID, @isReady, @substrateType, @isCichlidTank, @thermometerID, @heaterID, @filterPercent, @waterChangePercent, @stockPercent, @tempLow, @tempHigh, @phLow, @phHigh, @hardnessLow, @hardnessHigh, @aqAdvisor);

/* lighting */
insert into tankLights (tankID, lightID, intensity, shareRatio) values (@tankID, 'beamswork-48', 50, 0.25);

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

/* pumps */
insert into airPumpGroupTanks (airPumpGroupID, tankID, sponge) values ('double-rack-pump-bottom', @tankID, 'main');

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'african-clawed-frog', 2, 2, 10);

/* plants */

/* photos */
