Summery

DBVars.php Summery Transactions Table Old Short

53 On Table $2085.00 in Stock...Click for usage Notes

... To add a transaction, type "(#)-Name(recorded price)-From-To-(this price)-(notes)"
... The shortcuts are "W B I D P"
... To add a new product type "Name-a-a-Price (group)"
... To start timing a sculpture type "start"
... Multiple Transactions can be seperated by an *
... Typing just "($) Name(Price)" becomes Sale from Display at full price
... Description Words Can be used instead. They Are typed without spaces each character is checked

Summery Of Day

...

....Sale....

....Stock....

....Made....

....Other....

....Rate....

08/01/2026 12:27 .
Today I Earned $0.00 Total I produced $0.00 worth of sculptures, in 0:00 min, $0.00 of sales were custom orders, It Takes 0.0 Minutes to replace those sold
Produced $0.00 since last sale, Mallory production is $ Click for Day info

Pitch Location: ....Key Drawn:....Weather:
Pat? (0=N 1=Y):.... Boat Left minutes before Sunset :
Comments:

hello

Click to Hide/Show Last Transactions

Make these, $848 is Needed. You can earn $131 per hour TMI Make Time(x2)= 10:13 +5 unknown usefull inventory: $81.92/$3,042.00 Sort by $/Min not profit Min. Profit $ My Pay/Min $ Number of Items to Stock 40 satisfy $/min and $/(10 sales) 18 have unknown Production Times Make enough For Sales # Bring Enough For Sales # Accuracy #	Put These on display. currently 53 On Table Fetch 0 Items $170.48 in proffit is being missed: Name List NawNamesWithDoublePalms, FishingPoleRg, PalmGold, ChickenOne29, Drums29, PigFlyCopper29, MarlinPropeller, Manetee, HorseOne, PineappleBrass, PalmTarnishedBrass, CatWithBall29, SailboatPropeller, DragonFlyOne, PelicanCopper, PineappleCopper, DragonCopper34, FlamingoOne, SunFaceG,	Current Display. (53) On Display, Avg P:$5.23 Total P:$193.53	Retire These.
1) NawNamesWithDoublePalms TMI at $95.00 will take about 46.33 minutes Current price earns $2.05/Min Price should be at least $66.25 You have 0 of the 0.05 Profitablitiy is $24.42 Based on (79) sales No Preffered Product Make 1 * making the above will take 46 minutess *	1) $6.45 TurtleBrass19 TMI profit per 10 sales $6.45 There are 1 in Inventory	1) $8.53/D AirplanePropeller39 $39 TMI profit per 10 sales $8.53 There are 1 in Stock and 1 Displayed Current OS number: 7.00 Current Profit per 10 sales is $55.71 AirplanePropeller49 earns $9.90 at $49.00 St=0 AirplaneRealisticpropellor earns $8.81 at $49.00 St=0 AirplanePropeller39 earns $8.53 at $39.00 St=1	1)$4.29 CatPortrait TMI profit per 10 sales $4.29 Based on 37 Sales There are 2 on Display Average time on display is: 82 Current OS number: 34.00 CatPortrait earns $4.29 at $35.00 St=2
2) StoneSculpture TMI at $29.00 Make Time is unknown You have 0 of the 0.14 Profitablitiy is $19.97 Based on (30) sales No Preffered Product Make 1	Any Items Amove This line are Worth More Than At Least One Disply Item ___________________	2) $8.53/D BoatWingsSunset $39 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 65.00 Current Profit per 10 sales is $6.00 BoatWingsSunset earns $0.00 at $39.00 St=1	2)$4.38 PugPortrait TMI profit per 10 sales $4.38 Based on 10 Sales There are 1 on Display Average time on display is: 80 Current OS number: 21.00 DogPortrait earns $15.10 at $35.00 St=12 BulldogPortrait earns $10.61 at $35.00 St=1 FrenchiePortrait earns $7.24 at $35.00 St=0 LabradorPortrait earns $5.15 at $35.00 St=0 BoxerPortrait earns $4.91 at $35.00 St=0 PugPortrait earns $4.38 at $35.00 St=1 GermanShepherdPortrait earns $3.62 at $35.00 St=0 ShihtzuPortrait49 earns $0.78 at $49.00 St=0 AustralianCattleDogPortrait earns $0.00 at $35.00 St=0 ChihuahuaPortrait earns $0.00 at $35.00 St=0 CockapooPortrait earns $0.00 at $35.00 St=0 ColliePortrait earns $0.00 at $35.00 St=0 CorgiPortrait earns $0.00 at $35.00 St=0 DachshundPortrait earns $0.00 at $35.00 St=0 DogFuzzyFace earns $0.00 at $49.00 St=0 JackRusselPortrait earns $0.00 at $35.00 St=0 KingCharlesPortrait earns $0.00 at $35.00 St=0 PitbullPortrait earns $0.00 at $35.00 St=0 PomeranianPortrait earns $0.00 at $35.00 St=0 ShihtzuPortrait35 earns $0.00 at $35.00 St=0 WestiePortrait earns $0.00 at $35.00 St=0 YorkiePortrait earns $0.00 at $35.00 St=0
3) ChickenCopper39 TMI at $39.00 will take about 15.00 minutes Current price earns $2.60/Min Price should be at least $21.45 You have 0 of the 0.08 Profitablitiy is $16.57 Based on (77) sales No Preffered Product Make 1 * making the above will take 61 minutes * * making the above will take 61 minutess * Images link		3) $10.61/D BulldogPortrait $35 TMI profit per 10 sales $10.61 There are 1 in Stock and 1 Displayed Current OS number: 20.00 Current Profit per 10 sales is $17.50 DogPortrait earns $15.10 at $35.00 St=12 BulldogPortrait earns $10.61 at $35.00 St=1 FrenchiePortrait earns $7.24 at $35.00 St=0 LabradorPortrait earns $5.15 at $35.00 St=0 BoxerPortrait earns $4.91 at $35.00 St=0 PugPortrait earns $4.38 at $35.00 St=1 GermanShepherdPortrait earns $3.62 at $35.00 St=0 ShihtzuPortrait49 earns $0.78 at $49.00 St=0 AustralianCattleDogPortrait earns $0.00 at $35.00 St=0 ChihuahuaPortrait earns $0.00 at $35.00 St=0 CockapooPortrait earns $0.00 at $35.00 St=0 ColliePortrait earns $0.00 at $35.00 St=0 CorgiPortrait earns $0.00 at $35.00 St=0 DachshundPortrait earns $0.00 at $35.00 St=0 DogFuzzyFace earns $0.00 at $49.00 St=0 JackRusselPortrait earns $0.00 at $35.00 St=0 KingCharlesPortrait earns $0.00 at $35.00 St=0 PitbullPortrait earns $0.00 at $35.00 St=0 PomeranianPortrait earns $0.00 at $35.00 St=0 ShihtzuPortrait35 earns $0.00 at $35.00 St=0 WestiePortrait earns $0.00 at $35.00 St=0 YorkiePortrait earns $0.00 at $35.00 St=0	3)$7.69 LoveFourHandsCopper TMI profit per 10 sales $7.69 Based on 53 Sales There are 1 on Display Average time on display is: 38 Current OS number: 82.00 LoveFourHandsCopper earns $7.69 at $29.00 St=1 LoveFourHandsGold earns $4.60 at $29.00 St=0 LoveFourHandsRose earns $4.29 at $29.00 St=0 LoveFourHandsGroup earns $0.00 at $1.00 St=0
4) FlowerCounterSpin TMI at $49.00 Make Time is unknown You have 0 of the 0.06 Profitablitiy is $14.00 Based on (2) sales No Preffered Product Make 1		4) $10.61/D CatLargeWalking $29 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 32.00 Current Profit per 10 sales is $9.06 CatLargeWalking earns $0.00 at $29.00 St=1	4)$7.76 OwlOne TMI profit per 10 sales $7.76 Based on 66 Sales There are 1 on Display Average time on display is: 37 Current OS number: 76.00 OwlOne earns $7.76 at $29.00 St=1 OwlWings earns $0.00 at $29.00 St=0
5) TurtleFancy TMI at $29.00 will take about 11.00 minutes Current price earns $2.64/Min Price should be at least $15.73 You have 0 of the 0.09 Profitablitiy is $13.57 Based on (46) sales Make 1 * making the above will take 61 minutess *		5) $4.29/D CatPortrait $35 TMI profit per 10 sales $4.29 There are 2 in Stock and 2 Displayed Current OS number: 34.00 Current Profit per 10 sales is $10.29 CatPortrait earns $4.29 at $35.00 St=2	5)$8.28 ILoveYouMomFour TMI profit per 10 sales $8.28 Based on 72 Sales There are 1 on Display Average time on display is: 35 Current OS number: 16.00 ILoveYouMomFour earns $8.28 at $29.00 St=1 ILoveYouMomTrippleLevels earns $6.15 at $29.00 St=0 LoveMomGroup earns $0.00 at $1.00 St=0
6) FishingPoleRg TMI at $29.00 will take about 15.33 minutes Current price earns $1.89/Min Price should be at least $21.92 You have 0 of the 0.08 Profitablitiy is $11.71 Based on (48) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		6) $4.29/D ChickenWood $59 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 57.00 Current Profit per 10 sales is $10.35 ChickenWood earns $0.00 at $59.00 St=1	6)$8.53 AirplanePropeller39 TMI profit per 10 sales $8.53 Based on 12 Sales There are 1 on Display Average time on display is: 46 Current OS number: 7.00 AirplanePropeller49 earns $9.90 at $49.00 St=0 AirplaneRealisticpropellor earns $8.81 at $49.00 St=0 AirplanePropeller39 earns $8.53 at $39.00 St=1
7) PalmGold TMI at $29.00 will take about 13.67 minutes Current price earns $2.12/Min Price should be at least $19.55 You have 0 of the 0.07 Profitablitiy is $10.70 Based on (28) sales No Preffered Product Make 1 * making the above will take 61 minutess *		7) $4.29/D DachshundEarrings $24 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 20.00 Current Profit per 10 sales is $12.00 DachshundEarrings earns $0.00 at $24.00 St=1	7)$9.85 PalmCopper TMI profit per 10 sales $9.85 Based on 68 Sales There are 1 on Display Average time on display is: 29 Current OS number: 11.00
8) WeatherCock TMI at $49.00 Make Time is unknown You have 0 of the 0.04 Profitablitiy is $9.66 Based on (8) sales No Preffered Product Make 1		8) $15.93/D DachshundNotHappyOne $29 TMI profit per 10 sales $15.93 There are 1 in Stock and 1 Displayed Current OS number: 10.00 Current Profit per 10 sales is $29.00 DachshundNotHappyOne earns $15.93 at $29.00 St=1 DachshundWalking earns $13.18 at $29.00 St=0 DachshundPlay earns $12.17 at $29.00 St=0 DachHappy earns $11.28 at $29.00 St=0 DachshundGroup earns $0.00 at $1.00 St=0 DachshundSad earns $0.00 at $29.00 St=0	8)$10.61 BulldogPortrait TMI profit per 10 sales $10.61 Based on 11 Sales There are 1 on Display Average time on display is: 33 Current OS number: 20.00 DogPortrait earns $15.10 at $35.00 St=12 BulldogPortrait earns $10.61 at $35.00 St=1 FrenchiePortrait earns $7.24 at $35.00 St=0 LabradorPortrait earns $5.15 at $35.00 St=0 BoxerPortrait earns $4.91 at $35.00 St=0 PugPortrait earns $4.38 at $35.00 St=1 GermanShepherdPortrait earns $3.62 at $35.00 St=0 ShihtzuPortrait49 earns $0.78 at $49.00 St=0 AustralianCattleDogPortrait earns $0.00 at $35.00 St=0 ChihuahuaPortrait earns $0.00 at $35.00 St=0 CockapooPortrait earns $0.00 at $35.00 St=0 ColliePortrait earns $0.00 at $35.00 St=0 CorgiPortrait earns $0.00 at $35.00 St=0 DachshundPortrait earns $0.00 at $35.00 St=0 DogFuzzyFace earns $0.00 at $49.00 St=0 JackRusselPortrait earns $0.00 at $35.00 St=0 KingCharlesPortrait earns $0.00 at $35.00 St=0 PitbullPortrait earns $0.00 at $35.00 St=0 PomeranianPortrait earns $0.00 at $35.00 St=0 ShihtzuPortrait35 earns $0.00 at $35.00 St=0 WestiePortrait earns $0.00 at $35.00 St=0 YorkiePortrait earns $0.00 at $35.00 St=0
9) SunsetSailboatPalmtreeOne TMI at $29.00 Make Time is unknown You have 0 of the 0.07 Profitablitiy is $9.50 Based on (15) sales No Preffered Product Make 1		9) $15.10/D DogPortrait $35 TMI profit per 10 sales $15.10 There are 12 in Stock and 12 Displayed Current OS number: 46.00 Current Profit per 10 sales is $7.61 DogPortrait earns $15.10 at $35.00 St=12 BulldogPortrait earns $10.61 at $35.00 St=1 FrenchiePortrait earns $7.24 at $35.00 St=0 LabradorPortrait earns $5.15 at $35.00 St=0 BoxerPortrait earns $4.91 at $35.00 St=0 PugPortrait earns $4.38 at $35.00 St=1 GermanShepherdPortrait earns $3.62 at $35.00 St=0 ShihtzuPortrait49 earns $0.78 at $49.00 St=0 AustralianCattleDogPortrait earns $0.00 at $35.00 St=0 ChihuahuaPortrait earns $0.00 at $35.00 St=0 CockapooPortrait earns $0.00 at $35.00 St=0 ColliePortrait earns $0.00 at $35.00 St=0 CorgiPortrait earns $0.00 at $35.00 St=0 DachshundPortrait earns $0.00 at $35.00 St=0 DogFuzzyFace earns $0.00 at $49.00 St=0 JackRusselPortrait earns $0.00 at $35.00 St=0 KingCharlesPortrait earns $0.00 at $35.00 St=0 PitbullPortrait earns $0.00 at $35.00 St=0 PomeranianPortrait earns $0.00 at $35.00 St=0 ShihtzuPortrait35 earns $0.00 at $35.00 St=0 WestiePortrait earns $0.00 at $35.00 St=0 YorkiePortrait earns $0.00 at $35.00 St=0	9)$10.69 GufFenderGuitarThree TMI profit per 10 sales $10.69 Based on 64 Sales There are 1 on Display Average time on display is: 32 Current OS number: 16.00 GuitarFenderBrassBody earns $12.14 at $34.00 St=0 GufFenderGuitarThree earns $10.69 at $34.00 St=1 GoldFenderGuitarRetired earns $4.88 at $34.00 St=0 ElectricGuitar earns $0.00 at $1.00 St=0
10) PigFlyCopper29 TMI at $29.00 will take about 13.33 minutes Current price earns $2.18/Min Price should be at least $19.06 You have 0 of the 0.06 Profitablitiy is $8.42 Based on (22) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		10) $6.57/D FlowerVase $19 TMI profit per 10 sales $6.57 There are 1 in Stock and 1 Displayed Current OS number: 81.00 Current Profit per 10 sales is $2.35 FlowerVase earns $6.57 at $19.00 St=1 FlowerBounce earns $3.65 at $19.00 St=0	10)$12.53 MermaidPropeller49 TMI profit per 10 sales $12.53 Based on 67 Sales There are 1 on Display Average time on display is: 39 Current OS number: 7.00 MermaidPropeller49 earns $12.53 at $49.00 St=1
11) MarlinPropeller TMI at $49.00 will take about 18.00 minutes Current price earns $2.72/Min Price should be at least $25.74 You have 0 of the 0.03 Profitablitiy is $8.38 Based on (40) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		11) $10.27/D GuaCopper35Acoustic $35 TMI profit per 10 sales $10.27 There are 1 in Stock and 1 Displayed Current OS number: 38.00 Current Profit per 10 sales is $9.21 GuaCopper35Acoustic earns $10.27 at $35.00 St=1 GuaGoldAcousticGuitar earns $2.44 at $34.00 St=0 AcousticGuitarGroup earns $0.00 at $1.00 St=0	11)$15.10 DogPortrait TMI profit per 10 sales $15.10 Based on 249 Sales There are 12 on Display Average time on display is: 23 Current OS number: 46.00 DogPortrait earns $15.10 at $35.00 St=12 BulldogPortrait earns $10.61 at $35.00 St=1 FrenchiePortrait earns $7.24 at $35.00 St=0 LabradorPortrait earns $5.15 at $35.00 St=0 BoxerPortrait earns $4.91 at $35.00 St=0 PugPortrait earns $4.38 at $35.00 St=1 GermanShepherdPortrait earns $3.62 at $35.00 St=0 ShihtzuPortrait49 earns $0.78 at $49.00 St=0 AustralianCattleDogPortrait earns $0.00 at $35.00 St=0 ChihuahuaPortrait earns $0.00 at $35.00 St=0 CockapooPortrait earns $0.00 at $35.00 St=0 ColliePortrait earns $0.00 at $35.00 St=0 CorgiPortrait earns $0.00 at $35.00 St=0 DachshundPortrait earns $0.00 at $35.00 St=0 DogFuzzyFace earns $0.00 at $49.00 St=0 JackRusselPortrait earns $0.00 at $35.00 St=0 KingCharlesPortrait earns $0.00 at $35.00 St=0 PitbullPortrait earns $0.00 at $35.00 St=0 PomeranianPortrait earns $0.00 at $35.00 St=0 ShihtzuPortrait35 earns $0.00 at $35.00 St=0 WestiePortrait earns $0.00 at $35.00 St=0 YorkiePortrait earns $0.00 at $35.00 St=0
12) Manetee TMI at $29.00 Make Time is unknown You have 0 of the 0.06 Profitablitiy is $8.22 Based on (11) sales No Preffered Product Make 1 Images link		12) $10.69/D GufFenderGuitarThree $34 TMI profit per 10 sales $10.69 There are 1 in Stock and 1 Displayed Current OS number: 16.00 Current Profit per 10 sales is $21.25 GuitarFenderBrassBody earns $12.14 at $34.00 St=0 GufFenderGuitarThree earns $10.69 at $34.00 St=1 GoldFenderGuitarRetired earns $4.88 at $34.00 St=0 ElectricGuitar earns $0.00 at $1.00 St=0	12)$15.93 DachshundNotHappyOne TMI profit per 10 sales $15.93 Based on 134 Sales There are 1 on Display Average time on display is: 18 Current OS number: 10.00 DachshundNotHappyOne earns $15.93 at $29.00 St=1 DachHappy earns $11.28 at $29.00 St=0 DachshundGroup earns $0.00 at $1.00 St=0 DachshundPlay earns $0.00 at $29.00 St=0 DachshundSad earns $0.00 at $29.00 St=0 DachshundWalking earns $0.00 at $29.00 St=0
13) HorseOne TMI at $29.00 will take about 16.67 minutes Current price earns $1.74/Min Price should be at least $23.84 You have 0 of the 0.05 Profitablitiy is $7.70 Based on (41) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		13) $10.69/D HeartEaringsCopper $24 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 20.00 Current Profit per 10 sales is $12.00	13)$16.16 ILoveYouMore TMI profit per 10 sales $16.16 Based on 102 Sales There are 1 on Display Average time on display is: 18 Current OS number: 36.00 ILoveYouMore earns $16.16 at $29.00 St=1 ILoveYouMoreTrippleLevel earns $12.16 at $29.00 St=0 ILoveYouMoreCopper earns $10.27 at $29.00 St=0 ILoveYouMoreGroup earns $0.00 at $1.00 St=0 LoveYouMoreTricolor earns $0.00 at $29.00 St=0
14) PineappleBrass TMI at $29.00 will take about 12.50 minutes Current price earns $2.32/Min Price should be at least $17.88 You have 0 of the 0.05 Profitablitiy is $7.50 Based on (63) sales No Preffered Product Make 1 * making the above will take 61 minutess *		14) $10.69/D HumanPortrait $29 TMI Test Market Item There are 5 in Stock and 5 Displayed Current OS number: 47.00 Current Profit per 10 sales is $6.17 HumanPortrait earns $0.00 at $29.00 St=5
15) DragonFrontFacingDetailed TMI at $39.00 will take about 20.00 minutes Current price earns $1.95/Min Price should be at least $28.60 You have 0 of the 0.04 Profitablitiy is $7.43 Based on (7) sales No Preffered Product Make 1 * making the above will take 61 minutess *		15) $8.28/D ILoveYouMomFour $29 TMI profit per 10 sales $8.28 There are 1 in Stock and 1 Displayed Current OS number: 16.00 Current Profit per 10 sales is $18.13 ILoveYouMomFour earns $8.28 at $29.00 St=1 ILoveYouMomTrippleLevels earns $6.15 at $29.00 St=0 LoveMomGroup earns $0.00 at $1.00 St=0
16) CatWithBall29 TMI at $29.00 will take about 6.00 minutes Current price earns $4.83/Min Price should be at least $8.58 You have 0 of the 0.05 Profitablitiy is $7.36 Based on (80) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		16) $16.16/D ILoveYouMore $29 TMI profit per 10 sales $16.16 There are 1 in Stock and 1 Displayed Current OS number: 36.00 Current Profit per 10 sales is $8.06 ILoveYouMore earns $16.16 at $29.00 St=1 ILoveYouMoreTrippleLevel earns $12.16 at $29.00 St=0 ILoveYouMoreCopper earns $10.27 at $29.00 St=0 ILoveYouMoreGroup earns $0.00 at $1.00 St=0 LoveYouMoreTricolor earns $0.00 at $29.00 St=0
17) SailboatPropeller TMI at $49.00 will take about 25.20 minutes Current price earns $1.94/Min Price should be at least $36.04 You have 0 of the 0.03 Profitablitiy is $7.35 Based on (24) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		17) $20.95/D KwFancyPalm49 $49 TMI profit per 10 sales $20.95 There are 1 in Stock and 1 Displayed Current OS number: 19.00 Current Profit per 10 sales is $25.79 KwFancyPalm39 earns $21.95 at $39.00 St=0 KwFancyPalm49 earns $20.95 at $49.00 St=1 KwPalmCopper earns $13.96 at $29.00 St=0 KwPalmBronze earns $4.96 at $29.00 St=0 KeyWestPalmTree earns $0.00 at $1.00 St=0 KwPalm49 earns $0.00 at $49.00 St=0
18) FloridaMap TMI at $29.00 will take about 16.00 minutes Current price earns $1.81/Min Price should be at least $22.88 You have 0 of the 0.05 Profitablitiy is $7.18 Based on (16) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		18) $7.69/D LoveFourHandsCopper $29 TMI profit per 10 sales $7.69 There are 1 in Stock and 1 Displayed Current OS number: 82.00 Current Profit per 10 sales is $3.54 LoveFourHandsCopper earns $7.69 at $29.00 St=1 LoveFourHandsGold earns $4.60 at $29.00 St=0 LoveFourHandsRose earns $4.29 at $29.00 St=0 LoveFourHandsGroup earns $0.00 at $1.00 St=0
19) PelicanCopper TMI at $29.00 will take about 13.00 minutes Current price earns $2.23/Min Price should be at least $18.59 You have 0 of the 0.05 Profitablitiy is $7.10 Based on (55) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		19) $7.69/D LoveSignLanguageCopper19 $19 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 10.00 Current Profit per 10 sales is $19.00 LoveGoldHandSign earns $8.29 at $29.00 St=0 LoveSignLanguageBrass earns $7.16 at $29.00 St=0 LoveSignLanguageCopper29 earns $5.59 at $29.00 St=0 SignLanguageLoveCopper24 earns $5.44 at $24.00 St=0 LoveSignGroup earns $0.00 at $1.00 St=0 LoveSignLanguageCopper19 earns $0.00 at $19.00 St=1
20) PineappleCopper TMI at $29.00 will take about 12.00 minutes Current price earns $2.42/Min Price should be at least $17.16 You have 0 of the 0.05 Profitablitiy is $7.06 Based on (36) sales Make 1 * making the above will take 61 minutess *		20) $12.53/D MermaidPropeller49 $49 TMI profit per 10 sales $12.53 There are 1 in Stock and 1 Displayed Current OS number: 7.00 Current Profit per 10 sales is $70.00 MermaidPropeller49 earns $12.53 at $49.00 St=1
21) FlamingoOne TMI at $29.00 will take about 13.00 minutes Current price earns $2.23/Min Price should be at least $18.59 You have 0 of the 0.05 Profitablitiy is $6.78 Based on (63) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		21) $10.65/D MotorcycleChicken $69 TMI profit per 10 sales $10.65 There are 1 in Stock and 1 Displayed Current OS number: 82.00 Current Profit per 10 sales is $8.41 MotorcycleChicken earns $10.65 at $69.00 St=1
22) SunFaceG TMI at $34.00 will take about 21.00 minutes Current price earns $1.62/Min Price should be at least $30.03 You have 0 of the 0.04 Profitablitiy is $6.75 Based on (25) sales No Preffered Product Make 1 * making the above will take 61 minutess *		22) $10.65/D NameHeartNameThree $29 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 60.00 Current Profit per 10 sales is $4.83 NameHeartNameThree earns $0.00 at $29.00 St=1
23) DrumsCymbolsBrass39 TMI at $39.00 will take about 18.50 minutes Current price earns $2.11/Min Price should be at least $26.46 You have 0 of the 0.03 Profitablitiy is $5.71 Based on (4) sales No Preffered Product Make 1 * making the above will take 61 minutess * Images link		23) $7.76/D OwlOne $29 TMI profit per 10 sales $7.76 There are 1 in Stock and 1 Displayed Current OS number: 76.00 Current Profit per 10 sales is $3.82 OwlWings earns $10.44 at $29.00 St=0 OwlOne earns $7.76 at $29.00 St=1
		24) $9.85/D PalmCopper $29 TMI profit per 10 sales $9.85 There are 1 in Stock and 1 Displayed Current OS number: 11.00 Current Profit per 10 sales is $26.36
		25) $9.85/D PalmDoubleTreeTwin59 $59 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 11.00 Current Profit per 10 sales is $53.64 PalmDoubleTreeTwin earns $21.73 at $49.00 St=0 PalmDoubleTreeTwin59 earns $0.00 at $59.00 St=1
		26) $4.38/D PugPortrait $35 TMI profit per 10 sales $4.38 There are 1 in Stock and 1 Displayed Current OS number: 21.00 Current Profit per 10 sales is $16.67 DogPortrait earns $15.10 at $35.00 St=12 BulldogPortrait earns $10.61 at $35.00 St=1 FrenchiePortrait earns $7.24 at $35.00 St=0 LabradorPortrait earns $5.15 at $35.00 St=0 BoxerPortrait earns $4.91 at $35.00 St=0 PugPortrait earns $4.38 at $35.00 St=1 GermanShepherdPortrait earns $3.62 at $35.00 St=0 ShihtzuPortrait49 earns $0.78 at $49.00 St=0 AustralianCattleDogPortrait earns $0.00 at $35.00 St=0 ChihuahuaPortrait earns $0.00 at $35.00 St=0 CockapooPortrait earns $0.00 at $35.00 St=0 ColliePortrait earns $0.00 at $35.00 St=0 CorgiPortrait earns $0.00 at $35.00 St=0 DachshundPortrait earns $0.00 at $35.00 St=0 DogFuzzyFace earns $0.00 at $49.00 St=0 JackRusselPortrait earns $0.00 at $35.00 St=0 KingCharlesPortrait earns $0.00 at $35.00 St=0 PitbullPortrait earns $0.00 at $35.00 St=0 PomeranianPortrait earns $0.00 at $35.00 St=0 ShihtzuPortrait35 earns $0.00 at $35.00 St=0 WestiePortrait earns $0.00 at $35.00 St=0 YorkiePortrait earns $0.00 at $35.00 St=0
		27) $13.31/D ToMoonCopper $29 TMI profit per 10 sales $13.31 There are 1 in Stock and 1 Displayed Current OS number: 19.00 Current Profit per 10 sales is $15.26 ToMoon34 earns $13.92 at $34.00 St=0 ToMoonCopper earns $13.31 at $29.00 St=1 ToMoonGold earns $10.37 at $29.00 St=0
		28) $13.31/D TurtleCopper15 $15 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 10.00 Current Profit per 10 sales is $15.00 TurtleCopper19 earns $8.28 at $19.00 St=0 TurtleBounceCopper earns $3.45 at $19.00 St=0 TurtleCopper15 earns $0.00 at $15.00 St=1
		29) $13.31/D TurtleShellEarrings $24 TMI Test Market Item There are 2 in Stock and 2 Displayed Current OS number: 36.00 Current Profit per 10 sales is $6.67 TurtleShellEarrings earns $0.00 at $24.00 St=2
		30) $13.31/D TwoChairPalm $69 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 19.00 Current Profit per 10 sales is $36.32 TwoChairPalm earns $27.24 at $69.00 St=1
		31) $13.31/D WaveEarrings $24 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 41.00 Current Profit per 10 sales is $5.85 WaveEarrings earns $3.09 at $24.00 St=1
		32) $13.31/D WoodBridgeBoatPalmPedestal $124 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 264.00 Current Profit per 10 sales is $4.70 WoodBridgeBoatPalmPedestal earns $0.00 at $124.00 St=1
		33) $13.31/D WoodChairRowBoatPalm $49 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 13.00 Current Profit per 10 sales is $37.69 WoodChairRowBoatPalm earns $23.46 at $49.00 St=1
		34) $13.31/D WoodFishingPole $49 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 11.00 Current Profit per 10 sales is $44.55 WoodFishingPole earns $28.79 at $49.00 St=1 WoodFishingPoleBeer earns $0.00 at $49.00 St=0
		35) $13.31/D WoodNameHeartPalm $145 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 63.00 Current Profit per 10 sales is $23.02 WoodNameHeartPalm earns $0.00 at $145.00 St=1
		36) $13.31/D WoodPalmBoat $59 TMI Test Market Item There are 1 in Stock and 1 Displayed Current OS number: 13.00 Current Profit per 10 sales is $45.38 WoodPalmBoat earns $0.00 at $59.00 St=1

Use Description Words instead of Names

 Get var and Post var printed here from summeryArray
(
)
Array
(
)

QueryLog:

Part1ScanPostKeysTriggerMySqlUpdates, Here we begin scanning the post variable for setting top of the summery page and entering data into my sql as needed
Here we begin scanning the post variable for numbers that were submitted in numbers forms and entering data into my sql as needed
** no transaction calculations since the post variable is empty ***

**after transaction calculations
querry all items on display that have an other-sales number > 0. check the live other-sales number for each on display
OS function for item: 1349 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1349 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-21 13:50:18 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-21 13:50:18' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 34);Group Inventory = 2
Group Display Inventory = 2
OS function for item: 1352 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1352 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-06-28 19:40:19 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-06-28 19:40:19' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 82);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1357 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1357 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 20:31:38 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 20:31:38' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 10);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1358 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1358 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-02 20:22:02 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-02 20:22:02' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 76);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1360 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1360 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-19 21:14:18 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-19 21:14:18' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 36);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1363 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1363 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 19:06:15 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 19:06:15' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 11);
OS function for item: 1371 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1371 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-14 21:10:48 Added to :Customer next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-14 21:10:48' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 46);Group Inventory = 14
Group Display Inventory = 14
OS function for item: 1375 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1375 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-25 16:53:23 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-25 16:53:23' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 20);Group Inventory = 14
Group Display Inventory = 14
OS function for item: 1389 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1389 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-31 19:26:47 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-31 19:26:47' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 7);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1396 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1396 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-31 19:28:05 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-31 19:28:05' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 7);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1397 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1397 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-27 19:57:52 Added to :Public next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-27 19:57:52' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 16);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1433 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1433 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-25 14:26:12 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-25 14:26:12' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 21);Group Inventory = 14
Group Display Inventory = 14
OS function for item: 1442 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1442 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-27 20:55:55 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-27 20:55:55' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 16);Group Inventory = 1
Group Display Inventory = 1

**after (1) retire these

*********************Begin CreateArray_StockThese***********************

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 38.8986 Target Sales is 2
stdDev is 1.582623509045 NormSinv is 0 Required Sculptures is 0.051415732185734
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 22.5446 Target Sales is 2
stdDev is 2.058859371144 NormSinv is 0 Required Sculptures is 0.088713039929739
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 17.9484 Target Sales is 2
stdDev is 2.2937105541413 NormSinv is 0 Required Sculptures is 0.11143054534109
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 18.2079 Target Sales is 2
stdDev is 2.2782641550652 NormSinv is 0 Required Sculptures is 0.10984243103268
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 23.1808 Target Sales is 2
stdDev is 2.0317028180649 NormSinv is 0 Required Sculptures is 0.086278299282165
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 20.7692 Target Sales is 2
stdDev is 2.1407935080213 NormSinv is 0 Required Sculptures is 0.096296438957687
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39.0962 Target Sales is 2
stdDev is 1.5787242548339 NormSinv is 0 Required Sculptures is 0.051155866810585
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 23.8462 Target Sales is 2
stdDev is 2.0044157429432 NormSinv is 0 Required Sculptures is 0.083870805411344
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 28 Target Sales is 2
stdDev is 1.8557687223952 NormSinv is 0 Required Sculptures is 0.071428571428571
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 24.7692 Target Sales is 2
stdDev is 1.9683181745388 NormSinv is 0 Required Sculptures is 0.080745441919804
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 25.7143 Target Sales is 2
stdDev is 1.933300889291 NormSinv is 0 Required Sculptures is 0.077777734567925
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.0909 Target Sales is 2
stdDev is 1.8854763831401 NormSinv is 0 Required Sculptures is 0.073825528129372
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 31.8039 Target Sales is 2
stdDev is 1.7451086579611 NormSinv is 0 Required Sculptures is 0.062885369404381
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 33 Target Sales is 2
stdDev is 1.7141982574219 NormSinv is 0 Required Sculptures is 0.060606060606061
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.3889 Target Sales is 2
stdDev is 1.8755819878187 NormSinv is 0 Required Sculptures is 0.073022282749581
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.7692 Target Sales is 2
stdDev is 1.8631779156437 NormSinv is 0 Required Sculptures is 0.072022240467856
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.9565 Target Sales is 2
stdDev is 1.8571584232477 NormSinv is 0 Required Sculptures is 0.071539713483448
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 28.25 Target Sales is 2
stdDev is 1.8478418599842 NormSinv is 0 Required Sculptures is 0.070796460176991
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29 Target Sales is 2
stdDev is 1.8246560765963 NormSinv is 0 Required Sculptures is 0.068965517241379
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29 Target Sales is 2
stdDev is 1.8246560765963 NormSinv is 0 Required Sculptures is 0.068965517241379
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 49.5 Target Sales is 2
stdDev is 1.4069079067863 NormSinv is 0 Required Sculptures is 0.04040404040404
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29.4468 Target Sales is 2
stdDev is 1.8112508530961 NormSinv is 0 Required Sculptures is 0.067919094774305
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 30.1562 Target Sales is 2
stdDev is 1.7905598638703 NormSinv is 0 Required Sculptures is 0.066321353486182
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 55.6 Target Sales is 2
stdDev is 1.3289894389864 NormSinv is 0 Required Sculptures is 0.035971223021583
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 33.4286 Target Sales is 2
stdDev is 1.7035148011179 NormSinv is 0 Required Sculptures is 0.059829008693155
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 45.7273 Target Sales is 2
stdDev is 1.4625502024501 NormSinv is 0 Required Sculptures is 0.043737548466671
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 34.45 Target Sales is 2
stdDev is 1.6788381702086 NormSinv is 0 Required Sculptures is 0.058055152394775
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 58.4688 Target Sales is 2
stdDev is 1.2965578048166 NormSinv is 0 Required Sculptures is 0.034206277536053
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35 Target Sales is 2
stdDev is 1.6659862556701 NormSinv is 0 Required Sculptures is 0.057142857142857
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35.0192 Target Sales is 2
stdDev is 1.6655429161424 NormSinv is 0 Required Sculptures is 0.057111527390689
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 22.9595 Target Sales is 2
stdDev is 2.0410272246958 NormSinv is 0 Required Sculptures is 0.087109910930116
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35.3 Target Sales is 2
stdDev is 1.6590992027588 NormSinv is 0 Required Sculptures is 0.056657223796034
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 43.7222 Target Sales is 2
stdDev is 1.4949435642414 NormSinv is 0 Required Sculptures is 0.04574335234732
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 37.3591 Target Sales is 2
stdDev is 1.6140246270444 NormSinv is 0 Required Sculptures is 0.053534480220348
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 37.6562 Target Sales is 2
stdDev is 1.6078192674657 NormSinv is 0 Required Sculptures is 0.053112103717316
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 37.73 Target Sales is 2
stdDev is 1.6062889026771 NormSinv is 0 Required Sculptures is 0.053008216273522
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 38.6735 Target Sales is 2
stdDev is 1.5871007860276 NormSinv is 0 Required Sculptures is 0.051714998642481
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39 Target Sales is 2
stdDev is 1.5806189751203 NormSinv is 0 Required Sculptures is 0.051282051282051
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39.3818 Target Sales is 2
stdDev is 1.5731390321678 NormSinv is 0 Required Sculptures is 0.05078488032543
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 66.6522 Target Sales is 2
stdDev is 1.2156544749514 NormSinv is 0 Required Sculptures is 0.030006511412977
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39.5 Target Sales is 2
stdDev is 1.5708447653153 NormSinv is 0 Required Sculptures is 0.050632911392405
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 48.3333 Target Sales is 2
stdDev is 1.4234327177484 NormSinv is 0 Required Sculptures is 0.041379338882303
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 40.5 Target Sales is 2
stdDev is 1.551827788886 NormSinv is 0 Required Sculptures is 0.049382716049383
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 40.8182 Target Sales is 2
stdDev is 1.5459198103644 NormSinv is 0 Required Sculptures is 0.048997751003229
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 41.0476 Target Sales is 2
stdDev is 1.5417021486987 NormSinv is 0 Required Sculptures is 0.048723920521541
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 48.7778 Target Sales is 2
stdDev is 1.4170685691548 NormSinv is 0 Required Sculptures is 0.041002259224483
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 42.75 Target Sales is 2
stdDev is 1.5114442085754 NormSinv is 0 Required Sculptures is 0.046783625730994
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 50.3913 Target Sales is 2
stdDev is 1.3946642419461 NormSinv is 0 Required Sculptures is 0.039689390827385Group Inventory = 1
Group Display Inventory = 0
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29.4667 Target Sales is 2
stdDev is 1.8106606385186 NormSinv is 0 Required Sculptures is 0.067873226387753
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 47.1429 Target Sales is 2
stdDev is 1.4409076535355 NormSinv is 0 Required Sculptures is 0.042424203856784
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 51.8684 Target Sales is 2
stdDev is 1.3750585393181 NormSinv is 0 Required Sculptures is 0.03855912270284
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 61 Target Sales is 2
stdDev is 1.2698306053139 NormSinv is 0 Required Sculptures is 0.032786885245902
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 34.5 Target Sales is 2
stdDev is 1.6776575221435 NormSinv is 0 Required Sculptures is 0.057971014492754
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 44.1429 Target Sales is 2
stdDev is 1.4879687355374 NormSinv is 0 Required Sculptures is 0.045307399377929
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 55.75 Target Sales is 2
stdDev is 1.3272330571254 NormSinv is 0 Required Sculptures is 0.035874439461883
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 68 Target Sales is 2
stdDev is 1.2037283488048 NormSinv is 0 Required Sculptures is 0.029411764705882
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 58.5 Target Sales is 2
stdDev is 1.2962180246242 NormSinv is 0 Required Sculptures is 0.034188034188034
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 99.25 Target Sales is 2
stdDev is 0.99870164239794 NormSinv is 0 Required Sculptures is 0.020151133501259
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 71.3333 Target Sales is 2
stdDev is 1.1756774320387 NormSinv is 0 Required Sculptures is 0.028037396279157
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 59.3 Target Sales is 2
stdDev is 1.2875958967164 NormSinv is 0 Required Sculptures is 0.033726812816189
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 69.6923 Target Sales is 2
stdDev is 1.1892392423002 NormSinv is 0 Required Sculptures is 0.028697574911432
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 71.75 Target Sales is 2
stdDev is 1.1723068878927 NormSinv is 0 Required Sculptures is 0.02787456445993
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 60.1667 Target Sales is 2
stdDev is 1.2784462733649 NormSinv is 0 Required Sculptures is 0.033240978813862
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 60.32 Target Sales is 2
stdDev is 1.2768481110059 NormSinv is 0 Required Sculptures is 0.03315649867374
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.6857 Target Sales is 2
stdDev is 1.8658803500705 NormSinv is 0 Required Sculptures is 0.072239459359886
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 63 Target Sales is 2
stdDev is 1.2498425196844 NormSinv is 0 Required Sculptures is 0.031746031746032
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 80 Target Sales is 2
stdDev is 1.1110243021644 NormSinv is 0 Required Sculptures is 0.025
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 81.5 Target Sales is 2
stdDev is 1.1008808861918 NormSinv is 0 Required Sculptures is 0.024539877300613
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 67.6667 Target Sales is 2
stdDev is 1.2066449007442 NormSinv is 0 Required Sculptures is 0.029556635686386
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 68.125 Target Sales is 2
stdDev is 1.2026399712421 NormSinv is 0 Required Sculptures is 0.029357798165138
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 69.9091 Target Sales is 2
stdDev is 1.1874205965559 NormSinv is 0 Required Sculptures is 0.028608578854541
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 47 Target Sales is 2
stdDev is 1.4430489325798 NormSinv is 0 Required Sculptures is 0.042553191489362
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 72 Target Sales is 2
stdDev is 1.1702985796078 NormSinv is 0 Required Sculptures is 0.027777777777778
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 72.8571 Target Sales is 2
stdDev is 1.1634908236486 NormSinv is 0 Required Sculptures is 0.027450996539802
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 74.7778 Target Sales is 2
stdDev is 1.1486564788927 NormSinv is 0 Required Sculptures is 0.026745905870459
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 79 Target Sales is 2
stdDev is 1.1179444134592 NormSinv is 0 Required Sculptures is 0.025316455696203
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 93.5 Target Sales is 2
stdDev is 1.0286301637257 NormSinv is 0 Required Sculptures is 0.021390374331551
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 96.6 Target Sales is 2
stdDev is 1.0121661748721 NormSinv is 0 Required Sculptures is 0.020703933747412
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 55 Target Sales is 2
stdDev is 1.3360853142454 NormSinv is 0 Required Sculptures is 0.036363636363636
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 142.5 Target Sales is 2
stdDev is 0.83476331602599 NormSinv is 0 Required Sculptures is 0.014035087719298
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 162.4 Target Sales is 2
stdDev is 0.78228632823435 NormSinv is 0 Required Sculptures is 0.012315270935961
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 133.5 Target Sales is 2
stdDev is 0.86223703619635 NormSinv is 0 Required Sculptures is 0.01498127340824
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 116 Target Sales is 2
stdDev is 0.92446597368652 NormSinv is 0 Required Sculptures is 0.017241379310345
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 139.5 Target Sales is 2
stdDev is 0.84362740472687 NormSinv is 0 Required Sculptures is 0.014336917562724
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 120.6 Target Sales is 2
stdDev is 0.90681413694808 NormSinv is 0 Required Sculptures is 0.016583747927032
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 123.3 Target Sales is 2
stdDev is 0.89691265537384 NormSinv is 0 Required Sculptures is 0.016220600162206
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 215 Target Sales is 2
stdDev is 0.68040645759664 NormSinv is 0 Required Sculptures is 0.0093023255813953
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 83.4 Target Sales is 2
stdDev is 1.0884226108307 NormSinv is 0 Required Sculptures is 0.023980815347722
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 110.25 Target Sales is 2
stdDev is 0.94805192564022 NormSinv is 0 Required Sculptures is 0.018140589569161
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 137 Target Sales is 2
stdDev is 0.85123385326209 NormSinv is 0 Required Sculptures is 0.014598540145985
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 137.333 Target Sales is 2
stdDev is 0.85020878579918 NormSinv is 0 Required Sculptures is 0.014563142143549
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 115.5 Target Sales is 2
stdDev is 0.92644738350791 NormSinv is 0 Required Sculptures is 0.017316017316017
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 146 Target Sales is 2
stdDev is 0.82476675197207 NormSinv is 0 Required Sculptures is 0.013698630136986
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 151.667 Target Sales is 2
stdDev is 0.8093157160848 NormSinv is 0 Required Sculptures is 0.01318678420487
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 126 Target Sales is 2
stdDev is 0.88732856249992 NormSinv is 0 Required Sculptures is 0.015873015873016
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 164 Target Sales is 2
stdDev is 0.77848447163437 NormSinv is 0 Required Sculptures is 0.01219512195122
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 247 Target Sales is 2
stdDev is 0.63499543082422 NormSinv is 0 Required Sculptures is 0.0080971659919028
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 248 Target Sales is 2
stdDev is 0.63371909860894 NormSinv is 0 Required Sculptures is 0.0080645161290323
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 314 Target Sales is 2
stdDev is 0.56343331251446 NormSinv is 0 Required Sculptures is 0.0063694267515924
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 631 Target Sales is 2
stdDev is 0.39777814256771 NormSinv is 0 Required Sculptures is 0.0031695721077655
function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 1000 Target Sales is 2
stdDev is 0.31606961258558 NormSinv is 0 Required Sculptures is 0.002
SELECT Sum(On_Display) FROM Inventory Where On_Display >= 1

**after (2) stock these

**************begin Make these create array function ************************
UPDATE CustomTransactions SET DateOnly = DATE(Done) WHERE DateOnly = NULL

this is the query for "make these" in summery
SELECT Name , Other_Sales , Price , ((On_Display+Inventory+Backup)*(Other_Sales)) , ( (Price-MaterialCost) * ( IF ( 1 < (( ( IF ( Other_Sales <> 0 , 2 / Other_Sales , 0) ) )-(Inventory+On_Display+Backup)) ,1 ,( ( IF ( Other_Sales <> 0 , 2 / Other_Sales , 0) ) - (Inventory+On_Display+Backup)) ) ) ) , (Inventory+Backup+On_Display) , ( (Price-MaterialCost) / Make_Time ) , ( (Price-MaterialCost) * (( ( IF ( Other_Sales <> 0 , 2 / Other_Sales , 0) ) ) - (Inventory+Backup+On_Display)) ) , MaxStock , Total_Sales , GroupID , Make_Time , MaterialCost , (Inventory+On_Display) , Out_Of_Blue , ID , Link FROM Inventory WHERE ( MaxStock IS NULL or MaxStock > 0) AND ( (Price-MaterialCost)*10 / Other_Sales) > 5 AND ((((Price-MaterialCost)/Make_Time) > 1.43) OR (Make_Time = 0)) ORDER BY ( (Price-MaterialCost) * (( ( IF ( Other_Sales <> 0 , 2 / Other_Sales , 0) ) ) - (Inventory+Backup+On_Display)) ) DESC
create array make-these query for preffered product for this group

NawNamesWithDoublePalms (1354)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 38.8986 Target Sales is 2
stdDev is 1.582623509045 NormSinv is 0 Required Sculptures is 0.051415732185734Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.051415732185734 you have 0 in stock
Number needed to be prepared is 1*95 MaxStock is Inventory is 0 Total Sales Are 80

create array make-these query for preffered product for this group

KwFancyPalm39 (1408)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 17.7692 Target Sales is 2
stdDev is 2.3045614701087 NormSinv is 0 Required Sculptures is 0.11255430745335Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.11255430745335 you have 1 in stock

create array make-these query for preffered product for this group

PalmDoubleTreeTwin (1381)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 22.5446 Target Sales is 2
stdDev is 2.058859371144 NormSinv is 0 Required Sculptures is 0.088713039929739Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.088713039929739 you have 1 in stock

create array make-these query for preffered product for this group

StoneSculpture (1612)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 14.52 Target Sales is 2
stdDev is 2.5323383348279 NormSinv is 0 Required Sculptures is 0.13774104683196Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.13774104683196 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 30

create array make-these query for preffered product for this group

ChickenCopper39 (1423)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 23.5312 Target Sales is 2
stdDev is 2.0171959439818 NormSinv is 0 Required Sculptures is 0.084993540490923Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.084993540490923 you have 0 in stock
Number needed to be prepared is 1*39 MaxStock is Inventory is 0 Total Sales Are 77

create array make-these query for preffered product for this group

FlowerCounterSpin (1592)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35 Target Sales is 2
stdDev is 1.6659862556701 NormSinv is 0 Required Sculptures is 0.057142857142857Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.057142857142857 you have 0 in stock
Number needed to be prepared is 1*49 MaxStock is Inventory is 0 Total Sales Are 3

create array make-these query for preffered product for this group

KwPalmCopper (1408)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 20.7692 Target Sales is 2
stdDev is 2.1407935080213 NormSinv is 0 Required Sculptures is 0.096296438957687Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.096296438957687 you have 1 in stock

create array make-these query for preffered product for this group

ToMoon34 (1344)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 24.4231 Target Sales is 2
stdDev is 1.9816246621626 NormSinv is 0 Required Sculptures is 0.081889686403446Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.081889686403446 you have 1 in stock

TurtleFancy ()

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 21.3659 Target Sales is 2
stdDev is 2.1121784731605 NormSinv is 0 Required Sculptures is 0.093607102906969The Limit of Stock is 0.093607102906969 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 46

create array make-these query for preffered product for this group

DachshundWalking (1399)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 22 Target Sales is 2
stdDev is 2.0829889522527 NormSinv is 0 Required Sculptures is 0.090909090909091Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.090909090909091 you have 1 in stock

create array make-these query for preffered product for this group

PalmTreeChickens49 (1616)
Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0 you have 0 in stock

create array make-these query for preffered product for this group

PalmTreeChickens49 (1616)
Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0 you have 0 in stock

create array make-these query for preffered product for this group

PalmTreeChickens49 (1616)
Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0 you have 0 in stock

create array make-these query for preffered product for this group

ILoveYouMoreTrippleLevel (1382)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 23.8462 Target Sales is 2
stdDev is 2.0044157429432 NormSinv is 0 Required Sculptures is 0.083870805411344Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.083870805411344 you have 1 in stock

create array make-these query for preffered product for this group

GuitarFenderBrassBody (1403)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 28 Target Sales is 2
stdDev is 1.8557687223952 NormSinv is 0 Required Sculptures is 0.071428571428571Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.071428571428571 you have 1 in stock

create array make-these query for preffered product for this group

FishingPoleRg (1417)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 24.7692 Target Sales is 2
stdDev is 1.9683181745388 NormSinv is 0 Required Sculptures is 0.080745441919804Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.080745441919804 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 48

create array make-these query for preffered product for this group

DachHappy (1399)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 25.7143 Target Sales is 2
stdDev is 1.933300889291 NormSinv is 0 Required Sculptures is 0.077777734567925Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.077777734567925 you have 1 in stock

create array make-these query for preffered product for this group

PalmGold (1343)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.0909 Target Sales is 2
stdDev is 1.8854763831401 NormSinv is 0 Required Sculptures is 0.073825528129372Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.073825528129372 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 29

create array make-these query for preffered product for this group

ChickenOne29 (1423)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.3889 Target Sales is 2
stdDev is 1.8755819878187 NormSinv is 0 Required Sculptures is 0.073022282749581Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.073022282749581 you have 0 in stock

create array make-these query for preffered product for this group

OwlWings (1358)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.7692 Target Sales is 2
stdDev is 1.8631779156437 NormSinv is 0 Required Sculptures is 0.072022240467856Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.072022240467856 you have 1 in stock

create array make-these query for preffered product for this group

ToMoonGold (1344)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 27.9565 Target Sales is 2
stdDev is 1.8571584232477 NormSinv is 0 Required Sculptures is 0.071539713483448Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.071539713483448 you have 1 in stock

create array make-these query for preffered product for this group

ILoveYouMoreCopper (1382)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 28.25 Target Sales is 2
stdDev is 1.8478418599842 NormSinv is 0 Required Sculptures is 0.070796460176991Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.070796460176991 you have 1 in stock

create array make-these query for preffered product for this group

FishingPoleBass (1417)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29 Target Sales is 2
stdDev is 1.8246560765963 NormSinv is 0 Required Sculptures is 0.068965517241379Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.068965517241379 you have 0 in stock

create array make-these query for preffered product for this group

FishingPoleCopper (1417)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29 Target Sales is 2
stdDev is 1.8246560765963 NormSinv is 0 Required Sculptures is 0.068965517241379Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.068965517241379 you have 0 in stock

create array make-these query for preffered product for this group

AirplanePropeller49 (1396)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 49.5 Target Sales is 2
stdDev is 1.4069079067863 NormSinv is 0 Required Sculptures is 0.04040404040404Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.04040404040404 you have 1 in stock

create array make-these query for preffered product for this group

WeatherCock (1622)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 50.75 Target Sales is 2
stdDev is 1.3898262048932 NormSinv is 0 Required Sculptures is 0.039408866995074Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.039408866995074 you have 0 in stock
Number needed to be prepared is 1*49 MaxStock is Inventory is 0 Total Sales Are 8

create array make-these query for preffered product for this group

PalmBrass (1343)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 30.1562 Target Sales is 2
stdDev is 1.7905598638703 NormSinv is 0 Required Sculptures is 0.066321353486182Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.066321353486182 you have 0 in stock

create array make-these query for preffered product for this group

SunsetSailboatPalmtreeOne (1615)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 30.5385 Target Sales is 2
stdDev is 1.7796988399098 NormSinv is 0 Required Sculptures is 0.065491101396598Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.065491101396598 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 16

create array make-these query for preffered product for this group

AirplaneRealisticpropellor (1396)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 55.6 Target Sales is 2
stdDev is 1.3289894389864 NormSinv is 0 Required Sculptures is 0.035971223021583Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.035971223021583 you have 1 in stock

create array make-these query for preffered product for this group

PigFlyCopper29 (1514)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 34.45 Target Sales is 2
stdDev is 1.6788381702086 NormSinv is 0 Required Sculptures is 0.058055152394775Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.058055152394775 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 24

create array make-these query for preffered product for this group

MarlinPropeller (1385)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 58.4688 Target Sales is 2
stdDev is 1.2965578048166 NormSinv is 0 Required Sculptures is 0.034206277536053Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.034206277536053 you have 0 in stock
Number needed to be prepared is 1*49 MaxStock is Inventory is 0 Total Sales Are 40

create array make-these query for preffered product for this group

LoveGoldHandSign (1414)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35 Target Sales is 2
stdDev is 1.6659862556701 NormSinv is 0 Required Sculptures is 0.057142857142857Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.057142857142857 you have 1 in stock

create array make-these query for preffered product for this group

TurtleCopper19 (1361)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 22.9595 Target Sales is 2
stdDev is 2.0410272246958 NormSinv is 0 Required Sculptures is 0.087109910930116Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.087109910930116 you have 1 in stock

create array make-these query for preffered product for this group

Manetee (1458)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35.3 Target Sales is 2
stdDev is 1.6590992027588 NormSinv is 0 Required Sculptures is 0.056657223796034Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.056657223796034 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 13

create array make-these query for preffered product for this group

PigFlyCopper34 (1514)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 43.7222 Target Sales is 2
stdDev is 1.4949435642414 NormSinv is 0 Required Sculptures is 0.04574335234732Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.04574335234732 you have 0 in stock

create array make-these query for preffered product for this group

HorseOne (1410)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 37.6562 Target Sales is 2
stdDev is 1.6078192674657 NormSinv is 0 Required Sculptures is 0.053112103717316Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.053112103717316 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 41

create array make-these query for preffered product for this group

PineappleBrass (1379)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 38.6735 Target Sales is 2
stdDev is 1.5871007860276 NormSinv is 0 Required Sculptures is 0.051714998642481Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.051714998642481 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 65

PalmTarnishedBrass ()

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39 Target Sales is 2
stdDev is 1.5806189751203 NormSinv is 0 Required Sculptures is 0.051282051282051The Limit of Stock is 0 you have 0 in stock

create array make-these query for preffered product for this group

DragonFrontFacingDetailed (1446)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 52.5 Target Sales is 2
stdDev is 1.366923818515 NormSinv is 0 Required Sculptures is 0.038095238095238Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.038095238095238 you have 0 in stock
Number needed to be prepared is 1*39 MaxStock is Inventory is 0 Total Sales Are 7

create array make-these query for preffered product for this group

CatWithBall29 (1425)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39.3818 Target Sales is 2
stdDev is 1.5731390321678 NormSinv is 0 Required Sculptures is 0.05078488032543Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.05078488032543 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 81

create array make-these query for preffered product for this group

SailboatPropeller (1549)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 66.6522 Target Sales is 2
stdDev is 1.2156544749514 NormSinv is 0 Required Sculptures is 0.030006511412977Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.030006511412977 you have 0 in stock
Number needed to be prepared is 1*49 MaxStock is Inventory is 0 Total Sales Are 24

create array make-these query for preffered product for this group

FrenchiePortrait (1371)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 48.3333 Target Sales is 2
stdDev is 1.4234327177484 NormSinv is 0 Required Sculptures is 0.041379338882303Group Inventory = 14
Group Display Inventory = 14 The Limit of Stock is 0.041379338882303 you have 14 in stock

create array make-these query for preffered product for this group

FloridaMap (1613)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 40.4 Target Sales is 2
stdDev is 1.5536984976708 NormSinv is 0 Required Sculptures is 0.04950495049505Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.04950495049505 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 16

create array make-these query for preffered product for this group

LoveSignLanguageBrass (1414)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 40.5 Target Sales is 2
stdDev is 1.551827788886 NormSinv is 0 Required Sculptures is 0.049382716049383Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.049382716049383 you have 1 in stock

create array make-these query for preffered product for this group

PelicanCopper (1388)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 40.8182 Target Sales is 2
stdDev is 1.5459198103644 NormSinv is 0 Required Sculptures is 0.048997751003229Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.048997751003229 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 57

PineappleCopper ()

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 41.0476 Target Sales is 2
stdDev is 1.5417021486987 NormSinv is 0 Required Sculptures is 0.048723920521541The Limit of Stock is 0.048723920521541 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 37

create array make-these query for preffered product for this group

DragonCopper34 (1446)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 48.7778 Target Sales is 2
stdDev is 1.4170685691548 NormSinv is 0 Required Sculptures is 0.041002259224483Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.041002259224483 you have 0 in stock

create array make-these query for preffered product for this group

FlamingoOne (1347)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 42.75 Target Sales is 2
stdDev is 1.5114442085754 NormSinv is 0 Required Sculptures is 0.046783625730994Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.046783625730994 you have 0 in stock
Number needed to be prepared is 1*29 MaxStock is Inventory is 0 Total Sales Are 64

create array make-these query for preffered product for this group

SunFaceG (1383)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 50.3913 Target Sales is 2
stdDev is 1.3946642419461 NormSinv is 0 Required Sculptures is 0.039689390827385Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.039689390827385 you have 0 in stock
Number needed to be prepared is 1*34 MaxStock is Inventory is 0 Total Sales Are 26

create array make-these query for preffered product for this group

ILoveYouMomTrippleLevels (1495)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 47.1429 Target Sales is 2
stdDev is 1.4409076535355 NormSinv is 0 Required Sculptures is 0.042424203856784Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.042424203856784 you have 1 in stock

create array make-these query for preffered product for this group

CatLargeCrouched (1425)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 50 Target Sales is 2
stdDev is 1.4 NormSinv is 0 Required Sculptures is 0.04Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.04 you have 0 in stock

create array make-these query for preffered product for this group

DrumsCymbolsBrass39 (1472)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 68.25 Target Sales is 2
stdDev is 1.2015545396965 NormSinv is 0 Required Sculptures is 0.029304029304029Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.029304029304029 you have 0 in stock
Number needed to be prepared is 1*39 MaxStock is Inventory is 0 Total Sales Are 4

create array make-these query for preffered product for this group

LoveSignLanguageCopper29 (1414)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 51.8684 Target Sales is 2
stdDev is 1.3750585393181 NormSinv is 0 Required Sculptures is 0.03855912270284Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.03855912270284 you have 1 in stock

create array make-these query for preffered product for this group

TurtleBounceBrass (1364)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 34.5 Target Sales is 2
stdDev is 1.6776575221435 NormSinv is 0 Required Sculptures is 0.057971014492754Group Inventory = 1
Group Display Inventory = 0 The Limit of Stock is 0.057971014492754 you have 1 in stock

create array make-these query for preffered product for this group

SignLanguageLoveCopper24 (1414)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 44.1429 Target Sales is 2
stdDev is 1.4879687355374 NormSinv is 0 Required Sculptures is 0.045307399377929Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.045307399377929 you have 1 in stock

create array make-these query for preffered product for this group

UnicornStars (1366)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 73 Target Sales is 2
stdDev is 1.1623673115395 NormSinv is 0 Required Sculptures is 0.027397260273973Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.027397260273973 you have 0 in stock

create array make-these query for preffered product for this group

FishingPoleGold (1417)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 55.75 Target Sales is 2
stdDev is 1.3272330571254 NormSinv is 0 Required Sculptures is 0.035874439461883Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.035874439461883 you have 0 in stock

create array make-these query for preffered product for this group

CatWithBall24 (1425)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 46.5 Target Sales is 2
stdDev is 1.450616942283 NormSinv is 0 Required Sculptures is 0.043010752688172Group Inventory = 0
Group Display Inventory = 0 The Limit of Stock is 0.043010752688172 you have 0 in stock

create array make-these query for preffered product for this group

LabradorPortrait (1371)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 68 Target Sales is 2
stdDev is 1.2037283488048 NormSinv is 0 Required Sculptures is 0.029411764705882Group Inventory = 14
Group Display Inventory = 14 The Limit of Stock is 0.029411764705882 you have 14 in stock

create array make-these query for preffered product for this group

FlowerVase (1593)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 28.9412 Target Sales is 2
stdDev is 1.8264424503367 NormSinv is 0 Required Sculptures is 0.069105634873468Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.069105634873468 you have 1 in stock

create array make-these query for preffered product for this group

TurtleBrass19 (1364)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29.4667 Target Sales is 2
stdDev is 1.8106606385186 NormSinv is 0 Required Sculptures is 0.067873226387753Group Inventory = 1
Group Display Inventory = 0 The Limit of Stock is 0.067873226387753 you have 1 in stock

create array make-these query for preffered product for this group

ILoveYouMore (1382)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 17.9484 Target Sales is 2
stdDev is 2.2937105541413 NormSinv is 0 Required Sculptures is 0.11143054534109Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.11143054534109 you have 1 in stock

create array make-these query for preffered product for this group

DachshundNotHappyOne (1399)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 18.2079 Target Sales is 2
stdDev is 2.2782641550652 NormSinv is 0 Required Sculptures is 0.10984243103268Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.10984243103268 you have 1 in stock

create array make-these query for preffered product for this group

ToMoonCopper (1344)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 21.7895 Target Sales is 2
stdDev is 2.0925447653382 NormSinv is 0 Required Sculptures is 0.091787328759265Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.091787328759265 you have 1 in stock

PalmCopper ()

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 29.4468 Target Sales is 2
stdDev is 1.8112508530961 NormSinv is 0 Required Sculptures is 0.067919094774305The Limit of Stock is 0.067919094774305 you have 1 in stock

create array make-these query for preffered product for this group

ILoveYouMomFour (1495)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 35.0192 Target Sales is 2
stdDev is 1.6655429161424 NormSinv is 0 Required Sculptures is 0.057111527390689Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.057111527390689 you have 1 in stock

create array make-these query for preffered product for this group

OwlOne (1358)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 37.3591 Target Sales is 2
stdDev is 1.6140246270444 NormSinv is 0 Required Sculptures is 0.053534480220348Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.053534480220348 you have 1 in stock

create array make-these query for preffered product for this group

LoveFourHandsCopper (1466)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 37.73 Target Sales is 2
stdDev is 1.6062889026771 NormSinv is 0 Required Sculptures is 0.053008216273522Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.053008216273522 you have 1 in stock

create array make-these query for preffered product for this group

GufFenderGuitarThree (1403)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 31.8039 Target Sales is 2
stdDev is 1.7451086579611 NormSinv is 0 Required Sculptures is 0.062885369404381Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.062885369404381 you have 1 in stock

create array make-these query for preffered product for this group

BulldogPortrait (1371)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 33 Target Sales is 2
stdDev is 1.7141982574219 NormSinv is 0 Required Sculptures is 0.060606060606061Group Inventory = 14
Group Display Inventory = 14 The Limit of Stock is 0.060606060606061 you have 14 in stock

create array make-these query for preffered product for this group

GuaCopper35Acoustic (1404)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 34.08 Target Sales is 2
stdDev is 1.6876530333977 NormSinv is 0 Required Sculptures is 0.05868544600939Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.05868544600939 you have 1 in stock

create array make-these query for preffered product for this group

AirplanePropeller39 (1396)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 45.7273 Target Sales is 2
stdDev is 1.4625502024501 NormSinv is 0 Required Sculptures is 0.043737548466671Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.043737548466671 you have 1 in stock

create array make-these query for preffered product for this group

KwFancyPalm49 (1408)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 23.3889 Target Sales is 2
stdDev is 2.023049835453 NormSinv is 0 Required Sculptures is 0.085510648213469Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.085510648213469 you have 1 in stock

create array make-these query for preffered product for this group

MermaidPropeller49 (1389)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 39.0962 Target Sales is 2
stdDev is 1.5787242548339 NormSinv is 0 Required Sculptures is 0.051155866810585Group Inventory = 1
Group Display Inventory = 1 The Limit of Stock is 0.051155866810585 you have 1 in stock

create array make-these query for preffered product for this group

DogPortrait (1371)

function HowManyDoIneed
This is the Statistics Calculation for stock, accuarcy is 0.5 OS is 23.1808 Target Sales is 2
stdDev is 2.0317028180649 NormSinv is 0 Required Sculptures is 0.086278299282165Group Inventory = 14
Group Display Inventory = 14 The Limit of Stock is 0.086278299282165 you have 14 in stock

**after (3) make these
OS function for item: 1396 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1396 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-31 19:28:05 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-31 19:28:05' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 7);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1668 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1668 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-06 18:55:36 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-06 18:55:36' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 65);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1375 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1375 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-25 16:53:23 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-25 16:53:23' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 20);Group Inventory = 14
Group Display Inventory = 14
OS function for item: 1678 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1678 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-21 19:38:28 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-21 19:38:28' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 32);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1349 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1349 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-21 13:50:18 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-21 13:50:18' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 34);Group Inventory = 2
Group Display Inventory = 2
OS function for item: 1667 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1667 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-12 19:14:12 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-12 19:14:12' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 57);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1680 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1680 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-25 17:25:48 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-25 17:25:48' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 20);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1357 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1357 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 20:31:38 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 20:31:38' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 10);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1371 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1371 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-14 21:10:48 Added to :Customer next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-14 21:10:48' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 46);Group Inventory = 14
Group Display Inventory = 14
OS function for item: 1593 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1593 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-06-29 19:53:29 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-06-29 19:53:29' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 81);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1599 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1599 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-19 18:57:04 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-19 18:57:04' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 38);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1397 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1397 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-27 19:57:52 Added to :Public next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-27 19:57:52' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 16);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1633 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1633 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-25 16:32:13 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-25 16:32:13' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 20);
OS function for item: 1670 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1670 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-14 21:00:59 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-14 21:00:59' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 47);Group Inventory = 5
Group Display Inventory = 5
OS function for item: 1442 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1442 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-27 20:55:55 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-27 20:55:55' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 16);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1360 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1360 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-19 21:14:18 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-19 21:14:18' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 36);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1575 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1575 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-26 21:18:58 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-26 21:18:58' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 19);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1352 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1352 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-06-28 19:40:19 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-06-28 19:40:19' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 82);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1685 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1685 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 20:32:00 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 20:32:00' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 10);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1389 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1389 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-31 19:26:47 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-31 19:26:47' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 7);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1624 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1624 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-06-28 19:40:14 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-06-28 19:40:14' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 82);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1394 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1394 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-09 18:58:39 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-09 18:58:39' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 60);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1358 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1358 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-02 20:22:02 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-02 20:22:02' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 76);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1363 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1363 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 19:06:15 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 19:06:15' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 11);
OS function for item: 1684 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1684 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 19:36:52 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 19:36:52' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 11);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1433 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1433 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-25 14:26:12 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-25 14:26:12' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 21);Group Inventory = 14
Group Display Inventory = 14
OS function for item: 1564 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1564 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-26 21:21:54 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-26 21:21:54' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 19);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1683 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1683 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 20:31:37 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 20:31:37' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 10);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1676 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1676 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-19 21:19:17 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-19 21:19:17' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 36);Group Inventory = 2
Group Display Inventory = 2
OS function for item: 1634 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1634 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-26 21:20:25 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-26 21:20:25' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 19);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1638 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1638 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-17 22:30:46 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-17 22:30:46' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 41);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1662 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1662 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-02-23 21:25:07 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-02-23 21:25:07' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 264);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1654 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1654 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-28 20:00:38 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-28 20:00:38' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 13);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1659 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1659 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-30 14:14:54 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-30 14:14:54' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 11);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1671 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1671 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-07 19:07:24 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-07 19:07:24' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 63);Group Inventory = 1
Group Display Inventory = 1
OS function for item: 1665 look up list of transactions that are either putting on display or a sale. SELECT Date_n_Time,Added_To FROM transactions WHERE Product_ID = 1665 AND Added_To IN ("On_Display","Customer","Public") AND Voided <> 1 ORDER BY Date_n_Time desc LIMIT 1 transaction time :2026-07-28 20:00:38 Added to :On_Display next we querry how many sales of all kinds since then
SELECT COUNT(ID), SUM(Price) FROM `transactions` WHERE ( Date_n_Time > '2026-07-28 20:00:38' AND ((Added_To ="Customer") OR (Added_To ="Public")) AND Voided <> 1)
(other sales: 13);Group Inventory = 1
Group Display Inventory = 1

**after (4) display list
SELECT Sum(On_Display) FROM Inventory Where On_Display >= 1
SELECT Sum(On_Display*Price),Sum(Inventory*Price),Sum(Backup*Price) FROM Inventory
UPDATE EventOrDay SET TotalEarnings = 0 WHERE Date = '2026-08-01' LIMIT 1

UPDATE EventOrDay SET CustomSales = 0 WHERE Date = '2026-08-01' LIMIT 1

Update CustomTransactions SET DateOnly = DATE(Done) WHERE Done IS NOT NULL AND DateOnly IS NULL

UPDATE EventOrDay SET Productivity = 0 WHERE Date = '2026-08-01' LIMIT 1

SELECT PitchLocation From EventOrDay WHERE Date = '2026-08-01' AND Venue = 'Sunset' LIMIT 1
the data on file for PitchLocation2026-08-01Sunset is the posted Data is

SELECT KeyDrawn From EventOrDay WHERE Date = '2026-08-01' AND Venue = 'Sunset' LIMIT 1
the data on file for KeyDrawn2026-08-01Sunset is the posted Data is

SELECT Weather From EventOrDay WHERE Date = '2026-08-01' AND Venue = 'Sunset' LIMIT 1
the data on file for Weather2026-08-01Sunset is the posted Data is

SELECT Patrick From EventOrDay WHERE Date = '2026-08-01' AND Venue = 'Sunset' LIMIT 1
the data on file for Patrick2026-08-01Sunset is the posted Data is

SELECT BoatLeft From EventOrDay WHERE Date = '2026-08-01' AND Venue = 'Sunset' LIMIT 1
the data on file for BoatLeft2026-08-01Sunset is the posted Data is

SELECT Comments From EventOrDay WHERE Date = '2026-08-01' AND Venue = 'Sunset' LIMIT 1
the data on file for Comments2026-08-01Sunset is the posted Data is
****************************************Start Transaction History**********************************

function Print_And_Edit_Last_Transactions2 ($ProductNameForTransactions, $ListTransactionBeforeThisDate ,$ListTransactionFromThisVenue, $NumberOfTransactionsToPrint, $Summery)
function Print_And_Edit_Last_Transactions2 (, ,, 7, 0)
#of Transaction to print is 7

Select Transaction To print:SELECT transactions.ID ,transactions.Product_ID ,transactions.Date_n_Time ,transactions.Number ,transactions.Added_To ,transactions.Removed_From ,transactions.Other_Sales ,transactions.Voided ,transactions.Product_Name ,transactions.On_Display ,transactions.Make_Time ,transactions.Price ,transactions.Comments ,Inventory.Price ,transactions.Venue ,Inventory.Other_Sales ,Inventory.Make_Time ,TIMESTAMPDIFF(Minute,transactions.Date_n_Time,CustomTransactions.Done) FROM transactions LEFT JOIN Inventory ON transactions.Product_ID = Inventory.ID LEFT JOIN `CustomTransactions` ON CustomTransactions.TransactionID = transactions.ID WHERE Voided <> 1 ORDER BY Date_n_Time DESC LIMIT 7

Update Undo? Void?	1) 1 SunsetEarrings(s) moved from On_Display too Public there were "other sales", average is 72, were displayed, at on Priced at $ each Venue

Update Undo? Void?	2) 1 CatWithBall29(s) moved from On_Display too Public there were "other sales", average is 39, were displayed, at on Priced at $ each Venue

Update Undo? Void?	3) 1 PineappleBrass(s) moved from On_Display too Public there were "other sales", average is 39, were displayed, at on Priced at $ each Venue

Update Undo? Void?	4) 1 WoodHammockPalms59(s) moved from On_Display too Public there were "other sales", average is 15, were displayed, at on Priced at $ each Venue

Update Undo? Void?	5) 1 TurtleBrass19(s) moved from On_Display too Public there were "other sales", average is 29, were displayed, at on Priced at $ each Venue

Update Undo? Void?	6) 1 FlamingoOne(s) moved from On_Display too Public there were "other sales", average is 43, were displayed, at on Priced at $ each Venue

Update Undo? Void?	7) 1 AirplanePropeller39(s) moved from Inventory too On_Display at on Venue