Summery
Transactions
Table
Old
Short
Show/Hide Table options Base this table on data from: too Use only data from this Venue :
dates should be formatted like : 2009-10-04 24:59:59
rewrite inventory data. Questionaire from post is active
clear inventory dataUPDATE Inventory SET
Other_Sales = NULL
,Total_Sales = 0
,Out_of_Blue=0
, Request_View_no_Sale=0
, Make_Time=0
**CALCULATIONS START **
Get id of the transaction updating in transaction calculations ln36 :
the Transaction segment '' is being processed in Function_Transaction_Calculations
Typed_Transaction2(, , , ,
, , , , )
Next is the ProcessOneTransactionValidNoteOrAddProduct function
here the functionProcessOneTransactionValidnoteOrAddProduct starts
SELECT Sum(On_Display) FROM Inventory Where On_Display >= 1
SELECT
Sum(On_Display*Price),Sum(Inventory*Price),Sum(Backup*Price) FROM Inventory
***** Table calculations start all transactions query ******
Here the Create table section is beginning the all transactions querry, the only task for all transactions is to look up make times and save them look up averge make times: SELECT Product_ID
,AVG(Make_Time)
FROM transactions WHERE Voided <> 1
AND Date_n_Time >= "2022-04-03"
AND Venue = "Sunset"
AND Product_ID IN (1,2,3,4,5,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685)
GROUP BY Product_ID
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 5
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13.67 WHERE ID = 1343
actual querry used to update make time: UPDATE Inventory SET Make_Time = 19 WHERE ID = 1344
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13.5 WHERE ID = 1345
actual querry used to update make time: UPDATE Inventory SET Make_Time = 5 WHERE ID = 1346
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1347
actual querry used to update make time: UPDATE Inventory SET Make_Time = 16.67 WHERE ID = 1348
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11 WHERE ID = 1349
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1350
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1351
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1352
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1353
actual querry used to update make time: UPDATE Inventory SET Make_Time = 46.33 WHERE ID = 1354
actual querry used to update make time: UPDATE Inventory SET Make_Time = 14 WHERE ID = 1355
actual querry used to update make time: UPDATE Inventory SET Make_Time = 24 WHERE ID = 1356
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11.4 WHERE ID = 1357
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12.67 WHERE ID = 1358
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1359
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11 WHERE ID = 1360
actual querry used to update make time: UPDATE Inventory SET Make_Time = 4.33 WHERE ID = 1361
actual querry used to update make time: UPDATE Inventory SET Make_Time = 5.5 WHERE ID = 1362
actual querry used to update make time: UPDATE Inventory SET Make_Time = 14.67 WHERE ID = 1363
actual querry used to update make time: UPDATE Inventory SET Make_Time = 4 WHERE ID = 1364
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1365
actual querry used to update make time: UPDATE Inventory SET Make_Time = 17.5 WHERE ID = 1366
actual querry used to update make time: UPDATE Inventory SET Make_Time = 10 WHERE ID = 1367
actual querry used to update make time: UPDATE Inventory SET Make_Time = 17 WHERE ID = 1368
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13.33 WHERE ID = 1369
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1370
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13.67 WHERE ID = 1371
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1372
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1373
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1374
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1375
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1376
actual querry used to update make time: UPDATE Inventory SET Make_Time = 14 WHERE ID = 1377
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1378
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11.33 WHERE ID = 1379
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1380
actual querry used to update make time: UPDATE Inventory SET Make_Time = 16 WHERE ID = 1381
actual querry used to update make time: UPDATE Inventory SET Make_Time = 21 WHERE ID = 1383
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15.33 WHERE ID = 1384
actual querry used to update make time: UPDATE Inventory SET Make_Time = 18 WHERE ID = 1385
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1386
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1387
actual querry used to update make time: UPDATE Inventory SET Make_Time = 21 WHERE ID = 1389
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11.75 WHERE ID = 1390
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1391
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1392
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1393
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1394
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15 WHERE ID = 1395
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15 WHERE ID = 1396
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13.5 WHERE ID = 1397
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1398
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1401
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12.5 WHERE ID = 1405
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1407
actual querry used to update make time: UPDATE Inventory SET Make_Time = 8.5 WHERE ID = 1409
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1411
actual querry used to update make time: UPDATE Inventory SET Make_Time = 10 WHERE ID = 1412
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1413
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1415
actual querry used to update make time: UPDATE Inventory SET Make_Time = 40.5 WHERE ID = 1416
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1418
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1419
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1420
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1421
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1422
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15 WHERE ID = 1423
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1424
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1425
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15 WHERE ID = 1429
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1430
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1432
actual querry used to update make time: UPDATE Inventory SET Make_Time = 14 WHERE ID = 1433
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1434
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1435
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1436
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1437
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1438
actual querry used to update make time: UPDATE Inventory SET Make_Time = 49 WHERE ID = 1439
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1440
actual querry used to update make time: UPDATE Inventory SET Make_Time = 9.5 WHERE ID = 1442
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1443
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1444
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1445
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1447
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1448
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1449
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1450
actual querry used to update make time: UPDATE Inventory SET Make_Time = 18 WHERE ID = 1451
actual querry used to update make time: UPDATE Inventory SET Make_Time = 30 WHERE ID = 1452
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1453
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1454
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1455
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1456
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1457
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1458
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1459
actual querry used to update make time: UPDATE Inventory SET Make_Time = 16 WHERE ID = 1460
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1461
actual querry used to update make time: UPDATE Inventory SET Make_Time = 20.67 WHERE ID = 1462
actual querry used to update make time: UPDATE Inventory SET Make_Time = 19 WHERE ID = 1463
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1464
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1465
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1467
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1468
actual querry used to update make time: UPDATE Inventory SET Make_Time = 35 WHERE ID = 1469
actual querry used to update make time: UPDATE Inventory SET Make_Time = 28 WHERE ID = 1470
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1471
actual querry used to update make time: UPDATE Inventory SET Make_Time = 27 WHERE ID = 1472
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1473
actual querry used to update make time: UPDATE Inventory SET Make_Time = 5 WHERE ID = 1474
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1475
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6 WHERE ID = 1476
actual querry used to update make time: UPDATE Inventory SET Make_Time = 22 WHERE ID = 1477
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1478
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1479
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1480
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1481
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1482
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1483
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1484
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1485
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1486
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1488
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1489
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1490
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1491
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1492
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1494
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1496
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1497
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1498
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1499
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1500
actual querry used to update make time: UPDATE Inventory SET Make_Time = 6.5 WHERE ID = 1501
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1502
actual querry used to update make time: UPDATE Inventory SET Make_Time = 13 WHERE ID = 1503
actual querry used to update make time: UPDATE Inventory SET Make_Time = 28 WHERE ID = 1504
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1505
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1506
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1507
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1508
actual querry used to update make time: UPDATE Inventory SET Make_Time = 14.67 WHERE ID = 1510
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1511
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1512
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11 WHERE ID = 1513
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1515
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1516
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1517
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1518
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1519
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1520
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1521
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1522
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1523
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1524
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1525
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1526
actual querry used to update make time: UPDATE Inventory SET Make_Time = 8 WHERE ID = 1528
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1529
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1530
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1531
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1532
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1533
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1534
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1535
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1536
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1537
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1538
actual querry used to update make time: UPDATE Inventory SET Make_Time = 26 WHERE ID = 1539
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1540
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1541
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1542
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1543
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1544
actual querry used to update make time: UPDATE Inventory SET Make_Time = 20.33 WHERE ID = 1545
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1546
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1547
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1548
actual querry used to update make time: UPDATE Inventory SET Make_Time = 25.2 WHERE ID = 1549
actual querry used to update make time: UPDATE Inventory SET Make_Time = 23 WHERE ID = 1550
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1551
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1552
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1553
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1554
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1555
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1557
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1558
actual querry used to update make time: UPDATE Inventory SET Make_Time = 666 WHERE ID = 1560
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1561
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1562
actual querry used to update make time: UPDATE Inventory SET Make_Time = 24 WHERE ID = 1563
actual querry used to update make time: UPDATE Inventory SET Make_Time = 19 WHERE ID = 1564
actual querry used to update make time: UPDATE Inventory SET Make_Time = 19 WHERE ID = 1565
actual querry used to update make time: UPDATE Inventory SET Make_Time = 24.5 WHERE ID = 1567
actual querry used to update make time: UPDATE Inventory SET Make_Time = 666 WHERE ID = 1568
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1569
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1570
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1571
actual querry used to update make time: UPDATE Inventory SET Make_Time = 666 WHERE ID = 1572
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1573
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1574
actual querry used to update make time: UPDATE Inventory SET Make_Time = 24 WHERE ID = 1575
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1576
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1577
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1578
actual querry used to update make time: UPDATE Inventory SET Make_Time = 18 WHERE ID = 1579
actual querry used to update make time: UPDATE Inventory SET Make_Time = 20 WHERE ID = 1580
actual querry used to update make time: UPDATE Inventory SET Make_Time = 10 WHERE ID = 1581
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15 WHERE ID = 1582
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1583
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1584
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1585
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1587
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1588
actual querry used to update make time: UPDATE Inventory SET Make_Time = 11 WHERE ID = 1589
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1590
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1591
actual querry used to update make time: UPDATE Inventory SET Make_Time = 22.22 WHERE ID = 1592
actual querry used to update make time: UPDATE Inventory SET Make_Time = 7 WHERE ID = 1593
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1594
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1595
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1596
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1597
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1598
actual querry used to update make time: UPDATE Inventory SET Make_Time = 12 WHERE ID = 1599
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1600
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1601
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1602
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1603
actual querry used to update make time: UPDATE Inventory SET Make_Time = 10 WHERE ID = 1604
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1605
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1606
actual querry used to update make time: UPDATE Inventory SET Make_Time = 18.5 WHERE ID = 1607
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1608
actual querry used to update make time: UPDATE Inventory SET Make_Time = 20 WHERE ID = 1609
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1610
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1611
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1612
actual querry used to update make time: UPDATE Inventory SET Make_Time = 16 WHERE ID = 1613
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1614
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1615
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1616
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1617
actual querry used to update make time: UPDATE Inventory SET Make_Time = 999 WHERE ID = 1619
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1620
actual querry used to update make time: UPDATE Inventory SET Make_Time = 666 WHERE ID = 1621
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1622
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1623
actual querry used to update make time: UPDATE Inventory SET Make_Time = 22 WHERE ID = 1624
actual querry used to update make time: UPDATE Inventory SET Make_Time = 666 WHERE ID = 1625
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1626
actual querry used to update make time: UPDATE Inventory SET Make_Time = 15 WHERE ID = 1627
actual querry used to update make time: UPDATE Inventory SET Make_Time = 7 WHERE ID = 1628
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1629
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1630
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1631
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1632
actual querry used to update make time: UPDATE Inventory SET Make_Time = 3 WHERE ID = 1633
actual querry used to update make time: UPDATE Inventory SET Make_Time = 24 WHERE ID = 1634
actual querry used to update make time: UPDATE Inventory SET Make_Time = 20 WHERE ID = 1635
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1637
actual querry used to update make time: UPDATE Inventory SET Make_Time = 7 WHERE ID = 1638
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1639
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1641
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1642
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1643
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1644
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1645
actual querry used to update make time: UPDATE Inventory SET Make_Time = 25 WHERE ID = 1646
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1647
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1648
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1649
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1650
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1651
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1652
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1653
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1654
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1655
actual querry used to update make time: UPDATE Inventory SET Make_Time = 32 WHERE ID = 1656
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1657
actual querry used to update make time: UPDATE Inventory SET Make_Time = 23.75 WHERE ID = 1658
actual querry used to update make time: UPDATE Inventory SET Make_Time = 23 WHERE ID = 1659
actual querry used to update make time: UPDATE Inventory SET Make_Time = 45 WHERE ID = 1660
actual querry used to update make time: UPDATE Inventory SET Make_Time = 25 WHERE ID = 1661
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1662
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1663
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1664
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1665
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1666
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1667
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1668
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1670
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1671
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1672
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1674
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1675
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1676
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1678
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1679
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1680
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1681
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1683
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1684
actual querry used to update make time: UPDATE Inventory SET Make_Time = 0 WHERE ID = 1685
***** Table calculations start sales transactions query ******
begin Sales Transactions Query
SELECT
transactions.Product_ID
,SUM(transactions.Number)
,SUM(IF((transactions.On_Display = 0),Number,0))
,AVG(transactions.Other_Sales)
,SUM(transactions.Number)
FROM transactions
WHERE ((Added_To = 'Customer') OR (Added_To = 'Public'))
AND Date_n_Time >= "2022-04-03"
AND Venue = "Sunset"
AND Product_ID IN (1,2,3,4,5,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685)
AND Voided <> 1
GROUP BY Product_ID
average other sales straight from database for 1 is 0
for 1 os = 0 display os = 0
The OS was calculated by the second method for id 1 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 5 is
for 5 os = display os = 0
The OS was calculated by the second method for id 5 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1343 is 27.09090909090909
for 1343 os = 27.09090909090909 display os = 0
The OS was calculated by the second method for id 1343 it's the older simple method thats not compared to whats on the table it was 27.090909090909
average other sales straight from database for 1344 is 27.956521739130434
for 1344 os = 27.956521739130434 display os = 0
The OS was calculated by the second method for id 1344 it's the older simple method thats not compared to whats on the table it was 27.95652173913
average other sales straight from database for 1345 is 20.76923076923077
for 1345 os = 20.76923076923077 display os = 0
The OS was calculated by the second method for id 1345 it's the older simple method thats not compared to whats on the table it was 20.769230769231
average other sales straight from database for 1346 is 151.66666666666666
for 1346 os = 151.66666666666666 display os = 0
The OS was calculated by the second method for id 1346 it's the older simple method thats not compared to whats on the table it was 151.66666666667
average other sales straight from database for 1347 is 42.75
for 1347 os = 42.75 display os = 0
The OS was calculated by the second method for id 1347 it's the older simple method thats not compared to whats on the table it was 42.75
average other sales straight from database for 1348 is 37.65625
for 1348 os = 37.65625 display os = 0
The OS was calculated by the second method for id 1348 it's the older simple method thats not compared to whats on the table it was 37.65625
average other sales straight from database for 1349 is 81.5
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);
for 1349 os = 81.5 display os = 34
The OS was calculated by the second method for id 1349 it's the older simple method thats not compared to whats on the table it was 81.5
average other sales straight from database for 1350 is 55.75
for 1350 os = 55.75 display os = 0
The OS was calculated by the second method for id 1350 it's the older simple method thats not compared to whats on the table it was 55.75
average other sales straight from database for 1351 is 146
for 1351 os = 146 display os = 0
The OS was calculated by the second method for id 1351 it's the older simple method thats not compared to whats on the table it was 146
average other sales straight from database for 1352 is 36.89473684210526
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);
for 1352 os = 36.89473684210526 display os = 82
The OS was calculated by the first method for id 1352 which compares it to whats on the table it was 37.730019493177
average other sales straight from database for 1353 is 247
for 1353 os = 247 display os = 0
The OS was calculated by the second method for id 1353 it's the older simple method thats not compared to whats on the table it was 247
average other sales straight from database for 1354 is 38.89855072463768
for 1354 os = 38.89855072463768 display os = 0
The OS was calculated by the second method for id 1354 it's the older simple method thats not compared to whats on the table it was 38.898550724638
average other sales straight from database for 1355 is 69.6923076923077
for 1355 os = 69.6923076923077 display os = 0
The OS was calculated by the second method for id 1355 it's the older simple method thats not compared to whats on the table it was 69.692307692308
average other sales straight from database for 1356 is 61
for 1356 os = 61 display os = 0
The OS was calculated by the second method for id 1356 it's the older simple method thats not compared to whats on the table it was 61
average other sales straight from database for 1357 is 18.207920792079207
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);
for 1357 os = 18.207920792079207 display os = 10
The OS was calculated by the second method for id 1357 it's the older simple method thats not compared to whats on the table it was 18.207920792079
average other sales straight from database for 1358 is 36.77358490566038
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);
for 1358 os = 36.77358490566038 display os = 76
The OS was calculated by the first method for id 1358 which compares it to whats on the table it was 37.359053787665
average other sales straight from database for 1359 is 41.04761904761905
for 1359 os = 41.04761904761905 display os = 0
The OS was calculated by the second method for id 1359 it's the older simple method thats not compared to whats on the table it was 41.047619047619
average other sales straight from database for 1360 is 17.771428571428572
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);
for 1360 os = 17.771428571428572 display os = 36
The OS was calculated by the first method for id 1360 which compares it to whats on the table it was 17.948404993065
average other sales straight from database for 1361 is 22.95945945945946
for 1361 os = 22.95945945945946 display os = 0
The OS was calculated by the second method for id 1361 it's the older simple method thats not compared to whats on the table it was 22.959459459459
average other sales straight from database for 1362 is 51.86842105263158
for 1362 os = 51.86842105263158 display os = 0
The OS was calculated by the second method for id 1362 it's the older simple method thats not compared to whats on the table it was 51.868421052632
average other sales straight from database for 1363 is 29.4468085106383
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);
for 1363 os = 29.4468085106383 display os = 11
The OS was calculated by the second method for id 1363 it's the older simple method thats not compared to whats on the table it was 29.446808510638
average other sales straight from database for 1364 is 83.4
for 1364 os = 83.4 display os = 0
The OS was calculated by the second method for id 1364 it's the older simple method thats not compared to whats on the table it was 83.4
average other sales straight from database for 1365 is 40.81818181818182
for 1365 os = 40.81818181818182 display os = 0
The OS was calculated by the second method for id 1365 it's the older simple method thats not compared to whats on the table it was 40.818181818182
average other sales straight from database for 1366 is 68.125
for 1366 os = 68.125 display os = 0
The OS was calculated by the second method for id 1366 it's the older simple method thats not compared to whats on the table it was 68.125
average other sales straight from database for 1367 is 72
for 1367 os = 72 display os = 0
The OS was calculated by the second method for id 1367 it's the older simple method thats not compared to whats on the table it was 72
average other sales straight from database for 1368 is 139.5
for 1368 os = 139.5 display os = 0
The OS was calculated by the second method for id 1368 it's the older simple method thats not compared to whats on the table it was 139.5
average other sales straight from database for 1369 is 34.45
for 1369 os = 34.45 display os = 0
The OS was calculated by the second method for id 1369 it's the older simple method thats not compared to whats on the table it was 34.45
average other sales straight from database for 1370 is 176.83333333333334
for 1370 os = 176.83333333333334 display os = 0
The OS was calculated by the second method for id 1370 it's the older simple method thats not compared to whats on the table it was 176.83333333333
average other sales straight from database for 1371 is 22.08108108108108
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);
for 1371 os = 22.08108108108108 display os = 46
The OS was calculated by the first method for id 1371 which compares it to whats on the table it was 23.180801491146
average other sales straight from database for 1372 is 60.166666666666664
for 1372 os = 60.166666666666664 display os = 0
The OS was calculated by the second method for id 1372 it's the older simple method thats not compared to whats on the table it was 60.166666666667
average other sales straight from database for 1373 is 0
for 1373 os = 0 display os = 0
The OS was calculated by the second method for id 1373 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1374 is 1000
for 1374 os = 1000 display os = 0
The OS was calculated by the second method for id 1374 it's the older simple method thats not compared to whats on the table it was 1000
average other sales straight from database for 1375 is 33
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);
for 1375 os = 33 display os = 20
The OS was calculated by the second method for id 1375 it's the older simple method thats not compared to whats on the table it was 33
average other sales straight from database for 1376 is 48.333333333333336
for 1376 os = 48.333333333333336 display os = 0
The OS was calculated by the second method for id 1376 it's the older simple method thats not compared to whats on the table it was 48.333333333333
average other sales straight from database for 1377 is 116
for 1377 os = 116 display os = 0
The OS was calculated by the second method for id 1377 it's the older simple method thats not compared to whats on the table it was 116
average other sales straight from database for 1378 is 74.77777777777777
for 1378 os = 74.77777777777777 display os = 0
The OS was calculated by the second method for id 1378 it's the older simple method thats not compared to whats on the table it was 74.777777777778
average other sales straight from database for 1379 is 41.22222222222222
for 1379 os = 41.22222222222222 display os = 0
The OS was calculated by the second method for id 1379 it's the older simple method thats not compared to whats on the table it was 41.222222222222
average other sales straight from database for 1380 is 28.25
for 1380 os = 28.25 display os = 0
The OS was calculated by the second method for id 1380 it's the older simple method thats not compared to whats on the table it was 28.25
average other sales straight from database for 1381 is 22.525
for 1381 os = 22.525 display os = 0
The OS was calculated by the second method for id 1381 it's the older simple method thats not compared to whats on the table it was 22.544607843137
average other sales straight from database for 1383 is 50.391304347826086
for 1383 os = 50.391304347826086 display os = 0
The OS was calculated by the second method for id 1383 it's the older simple method thats not compared to whats on the table it was 50.391304347826
average other sales straight from database for 1384 is 24.76923076923077
for 1384 os = 24.76923076923077 display os = 0
The OS was calculated by the second method for id 1384 it's the older simple method thats not compared to whats on the table it was 24.769230769231
average other sales straight from database for 1385 is 58.46875
for 1385 os = 58.46875 display os = 0
The OS was calculated by the second method for id 1385 it's the older simple method thats not compared to whats on the table it was 58.46875
average other sales straight from database for 1386 is 215
for 1386 os = 215 display os = 0
The OS was calculated by the second method for id 1386 it's the older simple method thats not compared to whats on the table it was 215
average other sales straight from database for 1387 is 137.33333333333334
for 1387 os = 137.33333333333334 display os = 0
The OS was calculated by the second method for id 1387 it's the older simple method thats not compared to whats on the table it was 137.33333333333
average other sales straight from database for 1389 is 39.09615384615385
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);
for 1389 os = 39.09615384615385 display os = 7
The OS was calculated by the second method for id 1389 it's the older simple method thats not compared to whats on the table it was 39.096153846154
average other sales straight from database for 1390 is 60.32
for 1390 os = 60.32 display os = 0
The OS was calculated by the second method for id 1390 it's the older simple method thats not compared to whats on the table it was 60.32
average other sales straight from database for 1391 is 59.3
for 1391 os = 59.3 display os = 0
The OS was calculated by the second method for id 1391 it's the older simple method thats not compared to whats on the table it was 59.3
average other sales straight from database for 1392 is 120.6
for 1392 os = 120.6 display os = 0
The OS was calculated by the second method for id 1392 it's the older simple method thats not compared to whats on the table it was 120.6
average other sales straight from database for 1393 is 36
for 1393 os = 36 display os = 0
The OS was calculated by the second method for id 1393 it's the older simple method thats not compared to whats on the table it was 36
average other sales straight from database for 1394 is
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);
for 1394 os = display os = 60
The OS was calculated by the second method for id 1394 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1395 is 49.5
for 1395 os = 49.5 display os = 0
The OS was calculated by the second method for id 1395 it's the older simple method thats not compared to whats on the table it was 49.5
average other sales straight from database for 1396 is 45.72727272727273
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);
for 1396 os = 45.72727272727273 display os = 7
The OS was calculated by the second method for id 1396 it's the older simple method thats not compared to whats on the table it was 45.727272727273
average other sales straight from database for 1397 is 31.80392156862745
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);
for 1397 os = 31.80392156862745 display os = 16
The OS was calculated by the second method for id 1397 it's the older simple method thats not compared to whats on the table it was 31.803921568627
average other sales straight from database for 1398 is 25.714285714285715
for 1398 os = 25.714285714285715 display os = 0
The OS was calculated by the second method for id 1398 it's the older simple method thats not compared to whats on the table it was 25.714285714286
average other sales straight from database for 1401 is 39
for 1401 os = 39 display os = 0
The OS was calculated by the second method for id 1401 it's the older simple method thats not compared to whats on the table it was 39
average other sales straight from database for 1405 is 38.673469387755105
for 1405 os = 38.673469387755105 display os = 0
The OS was calculated by the second method for id 1405 it's the older simple method thats not compared to whats on the table it was 38.673469387755
average other sales straight from database for 1407 is 58.5
for 1407 os = 58.5 display os = 0
The OS was calculated by the second method for id 1407 it's the older simple method thats not compared to whats on the table it was 58.5
average other sales straight from database for 1409 is 115.5
for 1409 os = 115.5 display os = 0
The OS was calculated by the second method for id 1409 it's the older simple method thats not compared to whats on the table it was 115.5
average other sales straight from database for 1411 is 54
for 1411 os = 54 display os = 0
The OS was calculated by the second method for id 1411 it's the older simple method thats not compared to whats on the table it was 54
average other sales straight from database for 1412 is 29.545454545454547
for 1412 os = 29.545454545454547 display os = 0
The OS was calculated by the second method for id 1412 it's the older simple method thats not compared to whats on the table it was 29.545454545455
average other sales straight from database for 1413 is 35
for 1413 os = 35 display os = 0
The OS was calculated by the second method for id 1413 it's the older simple method thats not compared to whats on the table it was 35
average other sales straight from database for 1415 is 137
for 1415 os = 137 display os = 0
The OS was calculated by the second method for id 1415 it's the older simple method thats not compared to whats on the table it was 137
average other sales straight from database for 1416 is
for 1416 os = display os = 0
The OS was calculated by the second method for id 1416 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1418 is
for 1418 os = display os = 0
The OS was calculated by the second method for id 1418 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1419 is
for 1419 os = display os = 0
The OS was calculated by the second method for id 1419 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1420 is
for 1420 os = display os = 0
The OS was calculated by the second method for id 1420 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1421 is
for 1421 os = display os = 0
The OS was calculated by the second method for id 1421 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1422 is
for 1422 os = display os = 0
The OS was calculated by the second method for id 1422 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1423 is 27.38888888888889
for 1423 os = 27.38888888888889 display os = 0
The OS was calculated by the second method for id 1423 it's the older simple method thats not compared to whats on the table it was 27.388888888889
average other sales straight from database for 1424 is
for 1424 os = display os = 0
The OS was calculated by the second method for id 1424 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1425 is 39.38181818181818
for 1425 os = 39.38181818181818 display os = 0
The OS was calculated by the second method for id 1425 it's the older simple method thats not compared to whats on the table it was 39.381818181818
average other sales straight from database for 1429 is 28
for 1429 os = 28 display os = 0
The OS was calculated by the second method for id 1429 it's the older simple method thats not compared to whats on the table it was 28
average other sales straight from database for 1430 is
for 1430 os = display os = 0
The OS was calculated by the second method for id 1430 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1432 is 0
for 1432 os = 0 display os = 0
The OS was calculated by the second method for id 1432 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1433 is 80
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);
for 1433 os = 80 display os = 21
The OS was calculated by the second method for id 1433 it's the older simple method thats not compared to whats on the table it was 80
average other sales straight from database for 1434 is
for 1434 os = display os = 0
The OS was calculated by the second method for id 1434 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1435 is
for 1435 os = display os = 0
The OS was calculated by the second method for id 1435 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1436 is
for 1436 os = display os = 0
The OS was calculated by the second method for id 1436 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1437 is
for 1437 os = display os = 0
The OS was calculated by the second method for id 1437 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1438 is
for 1438 os = display os = 0
The OS was calculated by the second method for id 1438 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1439 is
for 1439 os = display os = 0
The OS was calculated by the second method for id 1439 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1440 is 79
for 1440 os = 79 display os = 0
The OS was calculated by the second method for id 1440 it's the older simple method thats not compared to whats on the table it was 79
average other sales straight from database for 1442 is 35.01923076923077
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);
for 1442 os = 35.01923076923077 display os = 16
The OS was calculated by the second method for id 1442 it's the older simple method thats not compared to whats on the table it was 35.019230769231
average other sales straight from database for 1443 is
for 1443 os = display os = 0
The OS was calculated by the second method for id 1443 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1444 is 68
for 1444 os = 68 display os = 0
The OS was calculated by the second method for id 1444 it's the older simple method thats not compared to whats on the table it was 68
average other sales straight from database for 1445 is 48.77777777777778
for 1445 os = 48.77777777777778 display os = 0
The OS was calculated by the second method for id 1445 it's the older simple method thats not compared to whats on the table it was 48.777777777778
average other sales straight from database for 1447 is
for 1447 os = display os = 0
The OS was calculated by the second method for id 1447 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1448 is
for 1448 os = display os = 0
The OS was calculated by the second method for id 1448 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1449 is
for 1449 os = display os = 0
The OS was calculated by the second method for id 1449 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1450 is 27.685714285714287
for 1450 os = 27.685714285714287 display os = 0
The OS was calculated by the second method for id 1450 it's the older simple method thats not compared to whats on the table it was 27.685714285714
average other sales straight from database for 1451 is 110.25
for 1451 os = 110.25 display os = 0
The OS was calculated by the second method for id 1451 it's the older simple method thats not compared to whats on the table it was 110.25
average other sales straight from database for 1452 is
for 1452 os = display os = 0
The OS was calculated by the second method for id 1452 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1453 is
for 1453 os = display os = 0
The OS was calculated by the second method for id 1453 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1454 is
for 1454 os = display os = 0
The OS was calculated by the second method for id 1454 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1455 is
for 1455 os = display os = 0
The OS was calculated by the second method for id 1455 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1456 is
for 1456 os = display os = 0
The OS was calculated by the second method for id 1456 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1457 is 248
for 1457 os = 248 display os = 0
The OS was calculated by the second method for id 1457 it's the older simple method thats not compared to whats on the table it was 248
average other sales straight from database for 1458 is 35.3
for 1458 os = 35.3 display os = 0
The OS was calculated by the second method for id 1458 it's the older simple method thats not compared to whats on the table it was 35.3
average other sales straight from database for 1459 is 47
for 1459 os = 47 display os = 0
The OS was calculated by the second method for id 1459 it's the older simple method thats not compared to whats on the table it was 47
average other sales straight from database for 1460 is 123.3
for 1460 os = 123.3 display os = 0
The OS was calculated by the second method for id 1460 it's the older simple method thats not compared to whats on the table it was 123.3
average other sales straight from database for 1461 is 29
for 1461 os = 29 display os = 0
The OS was calculated by the second method for id 1461 it's the older simple method thats not compared to whats on the table it was 29
average other sales straight from database for 1462 is
for 1462 os = display os = 0
The OS was calculated by the second method for id 1462 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1463 is 96.6
for 1463 os = 96.6 display os = 0
The OS was calculated by the second method for id 1463 it's the older simple method thats not compared to whats on the table it was 96.6
average other sales straight from database for 1464 is 71.33333333333333
for 1464 os = 71.33333333333333 display os = 0
The OS was calculated by the second method for id 1464 it's the older simple method thats not compared to whats on the table it was 71.333333333333
average other sales straight from database for 1465 is
for 1465 os = display os = 0
The OS was calculated by the second method for id 1465 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1467 is 63
for 1467 os = 63 display os = 0
The OS was calculated by the second method for id 1467 it's the older simple method thats not compared to whats on the table it was 63
average other sales straight from database for 1468 is
for 1468 os = display os = 0
The OS was calculated by the second method for id 1468 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1469 is
for 1469 os = display os = 0
The OS was calculated by the second method for id 1469 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1470 is
for 1470 os = display os = 0
The OS was calculated by the second method for id 1470 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1471 is
for 1471 os = display os = 0
The OS was calculated by the second method for id 1471 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1472 is 133.5
for 1472 os = 133.5 display os = 0
The OS was calculated by the second method for id 1472 it's the older simple method thats not compared to whats on the table it was 133.5
average other sales straight from database for 1473 is
for 1473 os = display os = 0
The OS was calculated by the second method for id 1473 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1474 is
for 1474 os = display os = 0
The OS was calculated by the second method for id 1474 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1475 is
for 1475 os = display os = 0
The OS was calculated by the second method for id 1475 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1476 is 44.142857142857146
for 1476 os = 44.142857142857146 display os = 0
The OS was calculated by the second method for id 1476 it's the older simple method thats not compared to whats on the table it was 44.142857142857
average other sales straight from database for 1477 is
for 1477 os = display os = 0
The OS was calculated by the second method for id 1477 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1478 is 67.66666666666667
for 1478 os = 67.66666666666667 display os = 0
The OS was calculated by the second method for id 1478 it's the older simple method thats not compared to whats on the table it was 67.666666666667
average other sales straight from database for 1479 is 30.15625
for 1479 os = 30.15625 display os = 0
The OS was calculated by the second method for id 1479 it's the older simple method thats not compared to whats on the table it was 30.15625
average other sales straight from database for 1480 is
for 1480 os = display os = 0
The OS was calculated by the second method for id 1480 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1481 is
for 1481 os = display os = 0
The OS was calculated by the second method for id 1481 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1482 is 29
for 1482 os = 29 display os = 0
The OS was calculated by the second method for id 1482 it's the older simple method thats not compared to whats on the table it was 29
average other sales straight from database for 1483 is
for 1483 os = display os = 0
The OS was calculated by the second method for id 1483 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1484 is
for 1484 os = display os = 0
The OS was calculated by the second method for id 1484 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1485 is
for 1485 os = display os = 0
The OS was calculated by the second method for id 1485 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1486 is 0
for 1486 os = 0 display os = 0
The OS was calculated by the second method for id 1486 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1488 is
for 1488 os = display os = 0
The OS was calculated by the second method for id 1488 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1489 is
for 1489 os = display os = 0
The OS was calculated by the second method for id 1489 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1490 is
for 1490 os = display os = 0
The OS was calculated by the second method for id 1490 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1491 is
for 1491 os = display os = 0
The OS was calculated by the second method for id 1491 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1492 is
for 1492 os = display os = 0
The OS was calculated by the second method for id 1492 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1494 is 47.142857142857146
for 1494 os = 47.142857142857146 display os = 0
The OS was calculated by the second method for id 1494 it's the older simple method thats not compared to whats on the table it was 47.142857142857
average other sales straight from database for 1496 is
for 1496 os = display os = 0
The OS was calculated by the second method for id 1496 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1498 is
for 1498 os = display os = 0
The OS was calculated by the second method for id 1498 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1499 is 69.9090909090909
for 1499 os = 69.9090909090909 display os = 0
The OS was calculated by the second method for id 1499 it's the older simple method thats not compared to whats on the table it was 69.909090909091
average other sales straight from database for 1500 is 314
for 1500 os = 314 display os = 0
The OS was calculated by the second method for id 1500 it's the older simple method thats not compared to whats on the table it was 314
average other sales straight from database for 1501 is 29.466666666666665
for 1501 os = 29.466666666666665 display os = 0
The OS was calculated by the second method for id 1501 it's the older simple method thats not compared to whats on the table it was 29.466666666667
average other sales straight from database for 1502 is 44.25
for 1502 os = 44.25 display os = 0
The OS was calculated by the second method for id 1502 it's the older simple method thats not compared to whats on the table it was 44.25
average other sales straight from database for 1503 is 23.846153846153847
for 1503 os = 23.846153846153847 display os = 0
The OS was calculated by the second method for id 1503 it's the older simple method thats not compared to whats on the table it was 23.846153846154
average other sales straight from database for 1504 is 39.5
for 1504 os = 39.5 display os = 0
The OS was calculated by the second method for id 1504 it's the older simple method thats not compared to whats on the table it was 39.5
average other sales straight from database for 1505 is
for 1505 os = display os = 0
The OS was calculated by the second method for id 1505 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1506 is
for 1506 os = display os = 0
The OS was calculated by the second method for id 1506 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1507 is
for 1507 os = display os = 0
The OS was calculated by the second method for id 1507 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1508 is
for 1508 os = display os = 0
The OS was calculated by the second method for id 1508 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1510 is 71.75
for 1510 os = 71.75 display os = 0
The OS was calculated by the second method for id 1510 it's the older simple method thats not compared to whats on the table it was 71.75
average other sales straight from database for 1511 is
for 1511 os = display os = 0
The OS was calculated by the second method for id 1511 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1512 is
for 1512 os = display os = 0
The OS was calculated by the second method for id 1512 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1513 is 43.72222222222222
for 1513 os = 43.72222222222222 display os = 0
The OS was calculated by the second method for id 1513 it's the older simple method thats not compared to whats on the table it was 43.722222222222
average other sales straight from database for 1515 is 72.85714285714286
for 1515 os = 72.85714285714286 display os = 0
The OS was calculated by the second method for id 1515 it's the older simple method thats not compared to whats on the table it was 72.857142857143
average other sales straight from database for 1516 is
for 1516 os = display os = 0
The OS was calculated by the second method for id 1516 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1517 is
for 1517 os = display os = 0
The OS was calculated by the second method for id 1517 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1518 is
for 1518 os = display os = 0
The OS was calculated by the second method for id 1518 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1519 is
for 1519 os = display os = 0
The OS was calculated by the second method for id 1519 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1520 is 55
for 1520 os = 55 display os = 0
The OS was calculated by the second method for id 1520 it's the older simple method thats not compared to whats on the table it was 55
average other sales straight from database for 1521 is
for 1521 os = display os = 0
The OS was calculated by the second method for id 1521 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1522 is 34.5
for 1522 os = 34.5 display os = 0
The OS was calculated by the second method for id 1522 it's the older simple method thats not compared to whats on the table it was 34.5
average other sales straight from database for 1523 is
for 1523 os = display os = 0
The OS was calculated by the second method for id 1523 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1524 is
for 1524 os = display os = 0
The OS was calculated by the second method for id 1524 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1525 is
for 1525 os = display os = 0
The OS was calculated by the second method for id 1525 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1526 is 40.5
for 1526 os = 40.5 display os = 0
The OS was calculated by the second method for id 1526 it's the older simple method thats not compared to whats on the table it was 40.5
average other sales straight from database for 1529 is
for 1529 os = display os = 0
The OS was calculated by the second method for id 1529 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1530 is
for 1530 os = display os = 0
The OS was calculated by the second method for id 1530 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1531 is 55.6
for 1531 os = 55.6 display os = 0
The OS was calculated by the second method for id 1531 it's the older simple method thats not compared to whats on the table it was 55.6
average other sales straight from database for 1532 is 126
for 1532 os = 126 display os = 0
The OS was calculated by the second method for id 1532 it's the older simple method thats not compared to whats on the table it was 126
average other sales straight from database for 1533 is
for 1533 os = display os = 0
The OS was calculated by the second method for id 1533 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1534 is
for 1534 os = display os = 0
The OS was calculated by the second method for id 1534 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1535 is
for 1535 os = display os = 0
The OS was calculated by the second method for id 1535 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1537 is
for 1537 os = display os = 0
The OS was calculated by the second method for id 1537 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1538 is
for 1538 os = display os = 0
The OS was calculated by the second method for id 1538 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1540 is 93.5
for 1540 os = 93.5 display os = 0
The OS was calculated by the second method for id 1540 it's the older simple method thats not compared to whats on the table it was 93.5
average other sales straight from database for 1541 is
for 1541 os = display os = 0
The OS was calculated by the second method for id 1541 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1542 is
for 1542 os = display os = 0
The OS was calculated by the second method for id 1542 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1543 is 631
for 1543 os = 631 display os = 0
The OS was calculated by the second method for id 1543 it's the older simple method thats not compared to whats on the table it was 631
average other sales straight from database for 1544 is
for 1544 os = display os = 0
The OS was calculated by the second method for id 1544 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1545 is 33.42857142857143
for 1545 os = 33.42857142857143 display os = 0
The OS was calculated by the second method for id 1545 it's the older simple method thats not compared to whats on the table it was 33.428571428571
average other sales straight from database for 1546 is 142.5
for 1546 os = 142.5 display os = 0
The OS was calculated by the second method for id 1546 it's the older simple method thats not compared to whats on the table it was 142.5
average other sales straight from database for 1547 is 99.25
for 1547 os = 99.25 display os = 0
The OS was calculated by the second method for id 1547 it's the older simple method thats not compared to whats on the table it was 99.25
average other sales straight from database for 1548 is 164
for 1548 os = 164 display os = 0
The OS was calculated by the second method for id 1548 it's the older simple method thats not compared to whats on the table it was 164
average other sales straight from database for 1549 is 66.65217391304348
for 1549 os = 66.65217391304348 display os = 0
The OS was calculated by the second method for id 1549 it's the older simple method thats not compared to whats on the table it was 66.652173913043
average other sales straight from database for 1550 is 162.4
for 1550 os = 162.4 display os = 0
The OS was calculated by the second method for id 1550 it's the older simple method thats not compared to whats on the table it was 162.4
average other sales straight from database for 1551 is 27.76923076923077
for 1551 os = 27.76923076923077 display os = 0
The OS was calculated by the second method for id 1551 it's the older simple method thats not compared to whats on the table it was 27.769230769231
average other sales straight from database for 1552 is
for 1552 os = display os = 0
The OS was calculated by the second method for id 1552 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1553 is
for 1553 os = display os = 0
The OS was calculated by the second method for id 1553 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1554 is 23.833333333333332
for 1554 os = 23.833333333333332 display os = 0
The OS was calculated by the second method for id 1554 it's the older simple method thats not compared to whats on the table it was 23.833333333333
average other sales straight from database for 1555 is 117
for 1555 os = 117 display os = 0
The OS was calculated by the second method for id 1555 it's the older simple method thats not compared to whats on the table it was 117
average other sales straight from database for 1557 is
for 1557 os = display os = 0
The OS was calculated by the second method for id 1557 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1558 is 77
for 1558 os = 77 display os = 0
The OS was calculated by the second method for id 1558 it's the older simple method thats not compared to whats on the table it was 77
average other sales straight from database for 1560 is 54
for 1560 os = 54 display os = 0
The OS was calculated by the second method for id 1560 it's the older simple method thats not compared to whats on the table it was 54
average other sales straight from database for 1561 is 91
for 1561 os = 91 display os = 0
The OS was calculated by the second method for id 1561 it's the older simple method thats not compared to whats on the table it was 91
average other sales straight from database for 1562 is 22
for 1562 os = 22 display os = 0
The OS was calculated by the second method for id 1562 it's the older simple method thats not compared to whats on the table it was 22
average other sales straight from database for 1563 is 17.76923076923077
for 1563 os = 17.76923076923077 display os = 0
The OS was calculated by the second method for id 1563 it's the older simple method thats not compared to whats on the table it was 17.769230769231
average other sales straight from database for 1564 is 21.789473684210527
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);
for 1564 os = 21.789473684210527 display os = 19
The OS was calculated by the second method for id 1564 it's the older simple method thats not compared to whats on the table it was 21.789473684211
average other sales straight from database for 1565 is 24.423076923076923
for 1565 os = 24.423076923076923 display os = 0
The OS was calculated by the second method for id 1565 it's the older simple method thats not compared to whats on the table it was 24.423076923077
average other sales straight from database for 1567 is 73
for 1567 os = 73 display os = 0
The OS was calculated by the second method for id 1567 it's the older simple method thats not compared to whats on the table it was 73
average other sales straight from database for 1568 is 3
for 1568 os = 3 display os = 0
The OS was calculated by the second method for id 1568 it's the older simple method thats not compared to whats on the table it was 3
average other sales straight from database for 1569 is
for 1569 os = display os = 0
The OS was calculated by the second method for id 1569 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1570 is
for 1570 os = display os = 0
The OS was calculated by the second method for id 1570 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1571 is
for 1571 os = display os = 0
The OS was calculated by the second method for id 1571 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1572 is 97.5
for 1572 os = 97.5 display os = 0
The OS was calculated by the second method for id 1572 it's the older simple method thats not compared to whats on the table it was 97.5
average other sales straight from database for 1573 is 431
for 1573 os = 431 display os = 0
The OS was calculated by the second method for id 1573 it's the older simple method thats not compared to whats on the table it was 431
average other sales straight from database for 1574 is
for 1574 os = display os = 0
The OS was calculated by the second method for id 1574 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1575 is 23.38888888888889
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);
for 1575 os = 23.38888888888889 display os = 19
The OS was calculated by the second method for id 1575 it's the older simple method thats not compared to whats on the table it was 23.388888888889
average other sales straight from database for 1576 is
for 1576 os = display os = 0
The OS was calculated by the second method for id 1576 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1577 is
for 1577 os = display os = 0
The OS was calculated by the second method for id 1577 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1578 is
for 1578 os = display os = 0
The OS was calculated by the second method for id 1578 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1579 is
for 1579 os = display os = 0
The OS was calculated by the second method for id 1579 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1580 is
for 1580 os = display os = 0
The OS was calculated by the second method for id 1580 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1581 is 46.5
for 1581 os = 46.5 display os = 0
The OS was calculated by the second method for id 1581 it's the older simple method thats not compared to whats on the table it was 46.5
average other sales straight from database for 1582 is 23.53125
for 1582 os = 23.53125 display os = 0
The OS was calculated by the second method for id 1582 it's the older simple method thats not compared to whats on the table it was 23.53125
average other sales straight from database for 1583 is 78.33333333333333
for 1583 os = 78.33333333333333 display os = 0
The OS was calculated by the second method for id 1583 it's the older simple method thats not compared to whats on the table it was 78.333333333333
average other sales straight from database for 1584 is
for 1584 os = display os = 0
The OS was calculated by the second method for id 1584 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1585 is
for 1585 os = display os = 0
The OS was calculated by the second method for id 1585 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1587 is
for 1587 os = display os = 0
The OS was calculated by the second method for id 1587 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1588 is 0
for 1588 os = 0 display os = 0
The OS was calculated by the second method for id 1588 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1589 is 21.365853658536587
for 1589 os = 21.365853658536587 display os = 0
The OS was calculated by the second method for id 1589 it's the older simple method thats not compared to whats on the table it was 21.365853658537
average other sales straight from database for 1590 is 551
for 1590 os = 551 display os = 0
The OS was calculated by the second method for id 1590 it's the older simple method thats not compared to whats on the table it was 551
average other sales straight from database for 1591 is 184
for 1591 os = 184 display os = 0
The OS was calculated by the second method for id 1591 it's the older simple method thats not compared to whats on the table it was 184
average other sales straight from database for 1592 is 38.9
for 1592 os = 38.9 display os = 0
The OS was calculated by the second method for id 1592 it's the older simple method thats not compared to whats on the table it was 38.9
average other sales straight from database for 1593 is 28.058823529411764
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);
for 1593 os = 28.058823529411764 display os = 81
The OS was calculated by the first method for id 1593 which compares it to whats on the table it was 28.941176470588
average other sales straight from database for 1594 is 83.5
for 1594 os = 83.5 display os = 0
The OS was calculated by the second method for id 1594 it's the older simple method thats not compared to whats on the table it was 83.5
average other sales straight from database for 1595 is 35
for 1595 os = 35 display os = 0
The OS was calculated by the second method for id 1595 it's the older simple method thats not compared to whats on the table it was 35
average other sales straight from database for 1596 is 242
for 1596 os = 242 display os = 0
The OS was calculated by the second method for id 1596 it's the older simple method thats not compared to whats on the table it was 242
average other sales straight from database for 1597 is 50
for 1597 os = 50 display os = 0
The OS was calculated by the second method for id 1597 it's the older simple method thats not compared to whats on the table it was 50
average other sales straight from database for 1598 is 135.33333333333334
for 1598 os = 135.33333333333334 display os = 0
The OS was calculated by the second method for id 1598 it's the older simple method thats not compared to whats on the table it was 135.33333333333
average other sales straight from database for 1599 is 34
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);
for 1599 os = 34 display os = 38
The OS was calculated by the first method for id 1599 which compares it to whats on the table it was 34.08
average other sales straight from database for 1600 is 169
for 1600 os = 169 display os = 0
The OS was calculated by the second method for id 1600 it's the older simple method thats not compared to whats on the table it was 169
average other sales straight from database for 1601 is 70
for 1601 os = 70 display os = 0
The OS was calculated by the second method for id 1601 it's the older simple method thats not compared to whats on the table it was 70
average other sales straight from database for 1602 is 66
for 1602 os = 66 display os = 0
The OS was calculated by the second method for id 1602 it's the older simple method thats not compared to whats on the table it was 66
average other sales straight from database for 1603 is 52
for 1603 os = 52 display os = 0
The OS was calculated by the second method for id 1603 it's the older simple method thats not compared to whats on the table it was 52
average other sales straight from database for 1604 is
for 1604 os = display os = 0
The OS was calculated by the second method for id 1604 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1605 is 78
for 1605 os = 78 display os = 0
The OS was calculated by the second method for id 1605 it's the older simple method thats not compared to whats on the table it was 78
average other sales straight from database for 1606 is 272.5
for 1606 os = 272.5 display os = 0
The OS was calculated by the second method for id 1606 it's the older simple method thats not compared to whats on the table it was 272.5
average other sales straight from database for 1607 is 68.25
for 1607 os = 68.25 display os = 0
The OS was calculated by the second method for id 1607 it's the older simple method thats not compared to whats on the table it was 68.25
average other sales straight from database for 1608 is 91.33333333333333
for 1608 os = 91.33333333333333 display os = 0
The OS was calculated by the second method for id 1608 it's the older simple method thats not compared to whats on the table it was 91.333333333333
average other sales straight from database for 1609 is 52.5
for 1609 os = 52.5 display os = 0
The OS was calculated by the second method for id 1609 it's the older simple method thats not compared to whats on the table it was 52.5
average other sales straight from database for 1610 is
for 1610 os = display os = 0
The OS was calculated by the second method for id 1610 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1611 is 109
for 1611 os = 109 display os = 0
The OS was calculated by the second method for id 1611 it's the older simple method thats not compared to whats on the table it was 109
average other sales straight from database for 1612 is 14.52
for 1612 os = 14.52 display os = 0
The OS was calculated by the second method for id 1612 it's the older simple method thats not compared to whats on the table it was 14.52
average other sales straight from database for 1613 is 40.4
for 1613 os = 40.4 display os = 0
The OS was calculated by the second method for id 1613 it's the older simple method thats not compared to whats on the table it was 40.4
average other sales straight from database for 1614 is 77
for 1614 os = 77 display os = 0
The OS was calculated by the second method for id 1614 it's the older simple method thats not compared to whats on the table it was 77
average other sales straight from database for 1615 is 30.53846153846154
for 1615 os = 30.53846153846154 display os = 0
The OS was calculated by the second method for id 1615 it's the older simple method thats not compared to whats on the table it was 30.538461538462
average other sales straight from database for 1616 is 30.142857142857142
for 1616 os = 30.142857142857142 display os = 0
The OS was calculated by the second method for id 1616 it's the older simple method thats not compared to whats on the table it was 30.142857142857
average other sales straight from database for 1617 is
for 1617 os = display os = 0
The OS was calculated by the second method for id 1617 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1619 is 45
for 1619 os = 45 display os = 0
The OS was calculated by the second method for id 1619 it's the older simple method thats not compared to whats on the table it was 45
average other sales straight from database for 1620 is 107
for 1620 os = 107 display os = 0
The OS was calculated by the second method for id 1620 it's the older simple method thats not compared to whats on the table it was 107
average other sales straight from database for 1621 is 33.2
for 1621 os = 33.2 display os = 0
The OS was calculated by the second method for id 1621 it's the older simple method thats not compared to whats on the table it was 33.2
average other sales straight from database for 1622 is 50.75
for 1622 os = 50.75 display os = 0
The OS was calculated by the second method for id 1622 it's the older simple method thats not compared to whats on the table it was 50.75
average other sales straight from database for 1623 is
for 1623 os = display os = 0
The OS was calculated by the second method for id 1623 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1624 is 63.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);
for 1624 os = 63.1 display os = 82
The OS was calculated by the first method for id 1624 which compares it to whats on the table it was 64.818181818182
average other sales straight from database for 1625 is 11.5
for 1625 os = 11.5 display os = 0
The OS was calculated by the second method for id 1625 it's the older simple method thats not compared to whats on the table it was 11.5
average other sales straight from database for 1626 is 57.666666666666664
for 1626 os = 57.666666666666664 display os = 0
The OS was calculated by the second method for id 1626 it's the older simple method thats not compared to whats on the table it was 57.666666666667
average other sales straight from database for 1627 is 25.894736842105264
for 1627 os = 25.894736842105264 display os = 0
The OS was calculated by the second method for id 1627 it's the older simple method thats not compared to whats on the table it was 25.894736842105
average other sales straight from database for 1628 is 72.28571428571429
for 1628 os = 72.28571428571429 display os = 0
The OS was calculated by the second method for id 1628 it's the older simple method thats not compared to whats on the table it was 72.285714285714
average other sales straight from database for 1629 is 42.5
for 1629 os = 42.5 display os = 0
The OS was calculated by the second method for id 1629 it's the older simple method thats not compared to whats on the table it was 42.5
average other sales straight from database for 1630 is 65.33333333333333
for 1630 os = 65.33333333333333 display os = 0
The OS was calculated by the second method for id 1630 it's the older simple method thats not compared to whats on the table it was 65.333333333333
average other sales straight from database for 1631 is 32
for 1631 os = 32 display os = 0
The OS was calculated by the second method for id 1631 it's the older simple method thats not compared to whats on the table it was 32
average other sales straight from database for 1632 is 185
for 1632 os = 185 display os = 0
The OS was calculated by the second method for id 1632 it's the older simple method thats not compared to whats on the table it was 185
average other sales straight from database for 1633 is 31.95
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);
for 1633 os = 31.95 display os = 20
The OS was calculated by the second method for id 1633 it's the older simple method thats not compared to whats on the table it was 31.95
average other sales straight from database for 1634 is 25.333333333333332
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);
for 1634 os = 25.333333333333332 display os = 19
The OS was calculated by the second method for id 1634 it's the older simple method thats not compared to whats on the table it was 25.333333333333
average other sales straight from database for 1635 is 31.833333333333332
for 1635 os = 31.833333333333332 display os = 0
The OS was calculated by the second method for id 1635 it's the older simple method thats not compared to whats on the table it was 31.833333333333
average other sales straight from database for 1637 is 15
for 1637 os = 15 display os = 0
The OS was calculated by the second method for id 1637 it's the older simple method thats not compared to whats on the table it was 15
average other sales straight from database for 1638 is 74
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);
for 1638 os = 74 display os = 41
The OS was calculated by the second method for id 1638 it's the older simple method thats not compared to whats on the table it was 77.75
average other sales straight from database for 1639 is 44.5
for 1639 os = 44.5 display os = 0
The OS was calculated by the second method for id 1639 it's the older simple method thats not compared to whats on the table it was 44.5
average other sales straight from database for 1641 is 96
for 1641 os = 96 display os = 0
The OS was calculated by the second method for id 1641 it's the older simple method thats not compared to whats on the table it was 96
average other sales straight from database for 1642 is
for 1642 os = display os = 0
The OS was calculated by the second method for id 1642 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1643 is
for 1643 os = display os = 0
The OS was calculated by the second method for id 1643 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1644 is 31.727272727272727
for 1644 os = 31.727272727272727 display os = 0
The OS was calculated by the second method for id 1644 it's the older simple method thats not compared to whats on the table it was 31.727272727273
average other sales straight from database for 1645 is 26.6
for 1645 os = 26.6 display os = 0
The OS was calculated by the second method for id 1645 it's the older simple method thats not compared to whats on the table it was 26.6
average other sales straight from database for 1646 is 95.66666666666667
for 1646 os = 95.66666666666667 display os = 0
The OS was calculated by the second method for id 1646 it's the older simple method thats not compared to whats on the table it was 95.666666666667
average other sales straight from database for 1647 is
for 1647 os = display os = 0
The OS was calculated by the second method for id 1647 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1648 is 56
for 1648 os = 56 display os = 0
The OS was calculated by the second method for id 1648 it's the older simple method thats not compared to whats on the table it was 56
average other sales straight from database for 1649 is 21.5
for 1649 os = 21.5 display os = 0
The OS was calculated by the second method for id 1649 it's the older simple method thats not compared to whats on the table it was 21.5
average other sales straight from database for 1650 is
for 1650 os = display os = 0
The OS was calculated by the second method for id 1650 it's the older simple method thats not compared to whats on the table it was 0
average other sales straight from database for 1651 is 44.25
for 1651 os = 44.25 display os = 0
The OS was calculated by the second method for id 1651 it's the older simple method thats not compared to whats on the table it was 44.25
average other sales straight from database for 1652 is 57
for 1652 os = 57 display os = 0
The OS was calculated by the second method for id 1652 it's the older simple method thats not compared to whats on the table it was 57
average other sales straight from database for 1653 is 25.444444444444443
for 1653 os = 25.444444444444443 display os = 0
The OS was calculated by the second method for id 1653 it's the older simple method thats not compared to whats on the table it was 25.444444444444
average other sales straight from database for 1654 is 20.88888888888889
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);
for 1654 os = 20.88888888888889 display os = 13
The OS was calculated by the second method for id 1654 it's the older simple method thats not compared to whats on the table it was 20.888888888889
average other sales straight from database for 1655 is 49
for 1655 os = 49 display os = 0
The OS was calculated by the second method for id 1655 it's the older simple method thats not compared to whats on the table it was 49
average other sales straight from database for 1656 is 25.166666666666668
for 1656 os = 25.166666666666668 display os = 0
The OS was calculated by the second method for id 1656 it's the older simple method thats not compared to whats on the table it was 25.166666666667
average other sales straight from database for 1657 is 65
for 1657 os = 65 display os = 0
The OS was calculated by the second method for id 1657 it's the older simple method thats not compared to whats on the table it was 65
average other sales straight from database for 1658 is 9.96
for 1658 os = 9.96 display os = 0
The OS was calculated by the second method for id 1658 it's the older simple method thats not compared to whats on the table it was 9.96
average other sales straight from database for 1659 is 16.2
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);
for 1659 os = 16.2 display os = 11
The OS was calculated by the second method for id 1659 it's the older simple method thats not compared to whats on the table it was 17.018181818182
average other sales straight from database for 1660 is 38.6
for 1660 os = 38.6 display os = 0
The OS was calculated by the second method for id 1660 it's the older simple method thats not compared to whats on the table it was 38.6
average other sales straight from database for 1661 is 18.90909090909091
for 1661 os = 18.90909090909091 display os = 0
The OS was calculated by the second method for id 1661 it's the older simple method thats not compared to whats on the table it was 18.909090909091
average other sales straight from database for 1662 is 16
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);
for 1662 os = 16 display os = 264
The OS was calculated by the first method for id 1662 which compares it to whats on the table it was 140
average other sales straight from database for 1663 is 25.5
for 1663 os = 25.5 display os = 0
The OS was calculated by the second method for id 1663 it's the older simple method thats not compared to whats on the table it was 25.5
average other sales straight from database for 1664 is 83
for 1664 os = 83 display os = 0
The OS was calculated by the second method for id 1664 it's the older simple method thats not compared to whats on the table it was 83
average other sales straight from database for 1665 is 21.75
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);
for 1665 os = 21.75 display os = 13
The OS was calculated by the second method for id 1665 it's the older simple method thats not compared to whats on the table it was 21.75
average other sales straight from database for 1666 is 13.75
for 1666 os = 13.75 display os = 0
The OS was calculated by the second method for id 1666 it's the older simple method thats not compared to whats on the table it was 13.75
average other sales straight from database for 1667 is 12
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);
for 1667 os = 12 display os = 57
The OS was calculated by the first method for id 1667 which compares it to whats on the table it was 21
average other sales straight from database for 1668 is 4
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);
for 1668 os = 4 display os = 65
The OS was calculated by the first method for id 1668 which compares it to whats on the table it was 34.5
average other sales straight from database for 1670 is 13
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);
for 1670 os = 13 display os = 47
The OS was calculated by the first method for id 1670 which compares it to whats on the table it was 41.333333333333
average other sales straight from database for 1672 is 33
for 1672 os = 33 display os = 0
The OS was calculated by the second method for id 1672 it's the older simple method thats not compared to whats on the table it was 33
average other sales straight from database for 1674 is 35
for 1674 os = 35 display os = 0
The OS was calculated by the second method for id 1674 it's the older simple method thats not compared to whats on the table it was 35
average other sales straight from database for 1675 is 24
for 1675 os = 24 display os = 0
The OS was calculated by the second method for id 1675 it's the older simple method thats not compared to whats on the table it was 24
average other sales straight from database for 1679 is 19
for 1679 os = 19 display os = 0
The OS was calculated by the second method for id 1679 it's the older simple method thats not compared to whats on the table it was 19
average other sales straight from database for 1681 is 15
for 1681 os = 15 display os = 0
The OS was calculated by the second method for id 1681 it's the older simple method thats not compared to whats on the table it was 15
average other sales straight from database for 1683 is 3
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);
for 1683 os = 3 display os = 10
The OS was calculated by the first method for id 1683 which compares it to whats on the table it was 6.5
***** Table calculations start group transactions query ******
SELECT ID,Name
FROM Inventory
WHERE GroupID IS NOT NULL
AND ID IN (1,2,3,4,5,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685)
in The conversion function, 'Piggie12' became 'Piggie' Which is priced at 12
in The conversion function, 'RetiredTuSmallTurtle7' became 'RetiredTuSmallTurtle' Which is priced at 7
in The conversion function, 'AligatorOne20' became 'AligatorOne' Which is priced at 20
in The conversion function, 'AirplaneSimple16' became 'AirplaneSimple' Which is priced at 16
in The conversion function, 'PalmGold' became 'PalmGold' Which is priced at
in The conversion function, 'ToMoonGold' became 'ToMoonGold' Which is priced at
in The conversion function, 'KwPalmCopper' became 'KwPalmCopper' Which is priced at
in The conversion function, 'ILoveYouFourRose' became 'ILoveYouFourRose' Which is priced at
in The conversion function, 'FlamingoOne' became 'FlamingoOne' Which is priced at
in The conversion function, 'HorseOne' became 'HorseOne' Which is priced at
in The conversion function, 'CatPortrait' became 'CatPortrait' Which is priced at
in The conversion function, 'FishingPoleGold' became 'FishingPoleGold' Which is priced at
in The conversion function, 'CrabGold' became 'CrabGold' Which is priced at
in The conversion function, 'LoveFourHandsCopper' became 'LoveFourHandsCopper' Which is priced at
in The conversion function, 'HairDresser' became 'HairDresser' Which is priced at
in The conversion function, 'NawNamesWithDoublePalms' became 'NawNamesWithDoublePalms' Which is priced at
in The conversion function, 'GoldFenderGuitarRetired' became 'GoldFenderGuitarRetired' Which is priced at
in The conversion function, 'ChickenOne34' became 'ChickenOne' Which is priced at 34
in The conversion function, 'DachshundNotHappyOne' became 'DachshundNotHappyOne' Which is priced at
in The conversion function, 'OwlOne' became 'OwlOne' Which is priced at
in The conversion function, 'ILoveYouMore' became 'ILoveYouMore' Which is priced at
in The conversion function, 'TurtleCopper19' became 'TurtleCopper' Which is priced at 19
in The conversion function, 'LoveSignLanguageCopper29' became 'LoveSignLanguageCopper' Which is priced at 29
in The conversion function, 'TurtleGold' became 'TurtleGold' Which is priced at
in The conversion function, 'PelicanCopper' became 'PelicanCopper' Which is priced at
in The conversion function, 'UnicornOne' became 'UnicornOne' Which is priced at
in The conversion function, 'ElephantCopper' became 'ElephantCopper' Which is priced at
in The conversion function, 'GuaGoldAcousticGuitar' became 'GuaGoldAcousticGuitar' Which is priced at
in The conversion function, 'PigFlyCopper29' became 'PigFlyCopper' Which is priced at 29
in The conversion function, 'DogPortrait' became 'DogPortrait' Which is priced at
in The conversion function, 'DragonCopper29' became 'DragonCopper' Which is priced at 29
in The conversion function, 'BulldogPortrait' became 'BulldogPortrait' Which is priced at
in The conversion function, 'FrenchiePortrait' became 'FrenchiePortrait' Which is priced at
in The conversion function, 'TuBallanceTurtle' became 'TuBallanceTurtle' Which is priced at
in The conversion function, 'PianoCopper' became 'PianoCopper' Which is priced at
in The conversion function, 'PineappleGoldGilt' became 'PineappleGoldGilt' Which is priced at
in The conversion function, 'ILoveYouMoreCopper' became 'ILoveYouMoreCopper' Which is priced at
in The conversion function, 'PalmDoubleTreeTwin' became 'PalmDoubleTreeTwin' Which is priced at
in The conversion function, 'ILoveYouMoreGroup' became 'ILoveYouMoreGroup' Which is priced at
in The conversion function, 'SunFaceG' became 'SunFaceG' Which is priced at
in The conversion function, 'FishingPoleRg' became 'FishingPoleRg' Which is priced at
in The conversion function, 'MarlinPropeller' became 'MarlinPropeller' Which is priced at
in The conversion function, 'FishPwFishingPolePinWheel' became 'FishPwFishingPolePinWheel' Which is priced at
in The conversion function, 'PelicanRose' became 'PelicanRose' Which is priced at
in The conversion function, 'PelicanGroup' became 'PelicanGroup' Which is priced at
in The conversion function, 'MermaidPropeller49' became 'MermaidPropeller' Which is priced at 49
in The conversion function, 'BalletCopper' became 'BalletCopper' Which is priced at
in The conversion function, 'BikeOne' became 'BikeOne' Which is priced at
in The conversion function, 'HummingBirdRg' became 'HummingBirdRg' Which is priced at
in The conversion function, 'NameHeartNameThree' became 'NameHeartNameThree' Which is priced at
in The conversion function, 'AirplanePropeller49' became 'AirplanePropeller' Which is priced at 49
in The conversion function, 'AirplanePropeller39' became 'AirplanePropeller' Which is priced at 39
in The conversion function, 'GufFenderGuitarThree' became 'GufFenderGuitarThree' Which is priced at
in The conversion function, 'DachHappy' became 'DachHappy' Which is priced at
in The conversion function, 'DachshundGroup' became 'DachshundGroup' Which is priced at
in The conversion function, 'PalmTreeGroup' became 'PalmTreeGroup' Which is priced at
in The conversion function, 'FrenchHornG' became 'FrenchHornG' Which is priced at
in The conversion function, 'ElectricGuitar' became 'ElectricGuitar' Which is priced at
in The conversion function, 'AcousticGuitarGroup' became 'AcousticGuitarGroup' Which is priced at
in The conversion function, 'PineappleBrass' became 'PineappleBrass' Which is priced at
in The conversion function, 'PineappleGroup' became 'PineappleGroup' Which is priced at
in The conversion function, 'KwPalmBronze' became 'KwPalmBronze' Which is priced at
in The conversion function, 'KeyWestPalmTree' became 'KeyWestPalmTree' Which is priced at
in The conversion function, 'HorseGroup' became 'HorseGroup' Which is priced at
in The conversion function, 'BrokenItem' became 'BrokenItem' Which is priced at
in The conversion function, 'ILoveYouMoreRose' became 'ILoveYouMoreRose' Which is priced at
in The conversion function, 'LoveGoldHandSign' became 'LoveGoldHandSign' Which is priced at
in The conversion function, 'LoveSignGroup' became 'LoveSignGroup' Which is priced at
in The conversion function, 'PianoGold' became 'PianoGold' Which is priced at
in The conversion function, 'Phrase' became 'Phrase' Which is priced at
in The conversion function, 'FishingPoleGroup' became 'FishingPoleGroup' Which is priced at
in The conversion function, 'TurtleSilver' became 'TurtleSilver' Which is priced at
in The conversion function, 'CartoonCharacter' became 'CartoonCharacter' Which is priced at
in The conversion function, 'GuaCopperAcousticGuitar' became 'GuaCopperAcousticGuitar' Which is priced at
in The conversion function, 'NameWithBasketball' became 'NameWithBasketball' Which is priced at
in The conversion function, 'ButterFlySimple' became 'ButterFlySimple' Which is priced at
in The conversion function, 'ChickenOne29' became 'ChickenOne' Which is priced at 29
in The conversion function, 'Gymnast' became 'Gymnast' Which is priced at
in The conversion function, 'CatWithBall29' became 'CatWithBall' Which is priced at 29
in The conversion function, 'TestThree' became 'TestThree' Which is priced at
in The conversion function, 'TestWhatever' became 'TestWhatever' Which is priced at
in The conversion function, 'AddSomeSchtuff' became 'AddSomeSchtuff' Which is priced at
in The conversion function, 'GuitarFenderBrassBody' became 'GuitarFenderBrassBody' Which is priced at
in The conversion function, 'TestFour' became 'TestFour' Which is priced at
in The conversion function, 'AppleOne' became 'AppleOne' Which is priced at
in The conversion function, 'PugPortrait' became 'PugPortrait' Which is priced at
in The conversion function, 'DogSide' became 'DogSide' Which is priced at
in The conversion function, 'PhoropterOptometrist' became 'PhoropterOptometrist' Which is priced at
in The conversion function, 'WineGlass' became 'WineGlass' Which is priced at
in The conversion function, 'Chiropractor' became 'Chiropractor' Which is priced at
in The conversion function, 'PetPortraitNotDog' became 'PetPortraitNotDog' Which is priced at
in The conversion function, 'LogoBusiness' became 'LogoBusiness' Which is priced at
in The conversion function, 'ElephantGold' became 'ElephantGold' Which is priced at
in The conversion function, 'ElephantGroup' became 'ElephantGroup' Which is priced at
in The conversion function, 'ILoveYouMomFour' became 'ILoveYouMomFour' Which is priced at
in The conversion function, 'Otter' became 'Otter' Which is priced at
in The conversion function, 'LabradorPortrait' became 'LabradorPortrait' Which is priced at
in The conversion function, 'DragonCopper34' became 'DragonCopper' Which is priced at 34
in The conversion function, 'DragonGroup' became 'DragonGroup' Which is priced at
in The conversion function, 'Judge' became 'Judge' Which is priced at
in The conversion function, 'Microphone' became 'Microphone' Which is priced at
in The conversion function, 'ShihtzuPortrait35' became 'ShihtzuPortrait' Which is priced at 35
in The conversion function, 'NameOne' became 'NameOne' Which is priced at
in The conversion function, 'GoldFishBrassCopper' became 'GoldFishBrassCopper' Which is priced at
in The conversion function, 'ButterFlyPair' became 'ButterFlyPair' Which is priced at
in The conversion function, 'BullOne' became 'BullOne' Which is priced at
in The conversion function, 'RoseSmall' became 'RoseSmall' Which is priced at
in The conversion function, 'Cross' became 'Cross' Which is priced at
in The conversion function, 'FigureHuman' became 'FigureHuman' Which is priced at
in The conversion function, 'ElephantDarkcopper' became 'ElephantDarkcopper' Which is priced at
in The conversion function, 'Manetee' became 'Manetee' Which is priced at
in The conversion function, 'DogSketch' became 'DogSketch' Which is priced at
in The conversion function, 'LionFace' became 'LionFace' Which is priced at
in The conversion function, 'FishingPoleCopper' became 'FishingPoleCopper' Which is priced at
in The conversion function, 'PalmForName' became 'PalmForName' Which is priced at
in The conversion function, 'GermanShepherdPortrait' became 'GermanShepherdPortrait' Which is priced at
in The conversion function, 'BoxerPortrait' became 'BoxerPortrait' Which is priced at
in The conversion function, 'HippoOne' became 'HippoOne' Which is priced at
in The conversion function, 'LoveFourHandsGroup' became 'LoveFourHandsGroup' Which is priced at
in The conversion function, 'LoveFourHandsGold' became 'LoveFourHandsGold' Which is priced at
in The conversion function, 'BassFish' became 'BassFish' Which is priced at
in The conversion function, 'WestiePortrait' became 'WestiePortrait' Which is priced at
in The conversion function, 'CockapooPortrait' became 'CockapooPortrait' Which is priced at
in The conversion function, 'LobsterOne' became 'LobsterOne' Which is priced at
in The conversion function, 'DrumsOne' became 'DrumsOne' Which is priced at
in The conversion function, 'OctopusOne' became 'OctopusOne' Which is priced at
in The conversion function, 'Doodle' became 'Doodle' Which is priced at
in The conversion function, 'CowOne' became 'CowOne' Which is priced at
in The conversion function, 'SignLanguageLoveCopper24' became 'SignLanguageLoveCopper' Which is priced at 24
in The conversion function, 'FerretOne' became 'FerretOne' Which is priced at
in The conversion function, 'LoveFourHandsRose' became 'LoveFourHandsRose' Which is priced at
in The conversion function, 'PalmBrass' became 'PalmBrass' Which is priced at
in The conversion function, 'AustralianCattleDogPortrait' became 'AustralianCattleDogPortrait' Which is priced at
in The conversion function, 'ZebraOne' became 'ZebraOne' Which is priced at
in The conversion function, 'FishingPoleBass' became 'FishingPoleBass' Which is priced at
in The conversion function, 'TractorOne' became 'TractorOne' Which is priced at
in The conversion function, 'DolphinOne' became 'DolphinOne' Which is priced at
in The conversion function, 'Misc' became 'Misc' Which is priced at
in The conversion function, 'HogfishOne' became 'HogfishOne' Which is priced at
in The conversion function, 'MahiMahiFish' became 'MahiMahiFish' Which is priced at
in The conversion function, 'BassFiddle' became 'BassFiddle' Which is priced at
in The conversion function, 'RedFishTwo' became 'RedFishTwo' Which is priced at
in The conversion function, 'BostonTerrierPortrait' became 'BostonTerrierPortrait' Which is priced at
in The conversion function, 'Shark' became 'Shark' Which is priced at
in The conversion function, 'ILoveYouGroup' became 'ILoveYouGroup' Which is priced at
in The conversion function, 'ILoveYouMomTrippleLevels' became 'ILoveYouMomTrippleLevels' Which is priced at
in The conversion function, 'LoveMomGroup' became 'LoveMomGroup' Which is priced at
in The conversion function, 'SaxOne' became 'SaxOne' Which is priced at
in The conversion function, 'TurtleCopper29' became 'TurtleCopper' Which is priced at 29
in The conversion function, 'KingCharlesPortrait' became 'KingCharlesPortrait' Which is priced at
in The conversion function, 'DogSwimming' became 'DogSwimming' Which is priced at
in The conversion function, 'CameraOne' became 'CameraOne' Which is priced at
in The conversion function, 'TurtleBrass19' became 'TurtleBrass' Which is priced at 19
in The conversion function, 'PineappleRose' became 'PineappleRose' Which is priced at
in The conversion function, 'ILoveYouMoreTrippleLevel' became 'ILoveYouMoreTrippleLevel' Which is priced at
in The conversion function, 'DragonFlyOne' became 'DragonFlyOne' Which is priced at
in The conversion function, 'PenguinOne' became 'PenguinOne' Which is priced at
in The conversion function, 'GoldenDoodlePortrait' became 'GoldenDoodlePortrait' Which is priced at
in The conversion function, 'Tip' became 'Tip' Which is priced at
in The conversion function, 'GiraffeOne' became 'GiraffeOne' Which is priced at
in The conversion function, 'SoccerBallTwo' became 'SoccerBallTwo' Which is priced at
in The conversion function, 'MotorcycleOne' became 'MotorcycleOne' Which is priced at
in The conversion function, 'TrumpetOne' became 'TrumpetOne' Which is priced at
in The conversion function, 'VWBus' became 'VWBus' Which is priced at
in The conversion function, 'PigFlyCopper34' became 'PigFlyCopper' Which is priced at 34
in The conversion function, 'PigFlyGroup' became 'PigFlyGroup' Which is priced at
in The conversion function, 'PineappleBouncing' became 'PineappleBouncing' Which is priced at
in The conversion function, 'signLanguageName' became 'signLanguageName' Which is priced at
in The conversion function, 'CactusOne' became 'CactusOne' Which is priced at
in The conversion function, 'ColliePortrait' became 'ColliePortrait' Which is priced at
in The conversion function, 'ChihuahuaPortrait' became 'ChihuahuaPortrait' Which is priced at
in The conversion function, 'TurtleBounceCopper' became 'TurtleBounceCopper' Which is priced at
in The conversion function, 'Lacrosse' became 'Lacrosse' Which is priced at
in The conversion function, 'TurtleBounceBrass' became 'TurtleBounceBrass' Which is priced at
in The conversion function, 'YorkiePortrait' became 'YorkiePortrait' Which is priced at
in The conversion function, 'Budha' became 'Budha' Which is priced at
in The conversion function, 'CorgiPortrait' became 'CorgiPortrait' Which is priced at
in The conversion function, 'LoveSignLanguageBrass' became 'LoveSignLanguageBrass' Which is priced at
in The conversion function, 'DeletedItem' became 'DeletedItem' Which is priced at
in The conversion function, 'PropellerOne' became 'PropellerOne' Which is priced at
in The conversion function, 'JackRusselPortrait' became 'JackRusselPortrait' Which is priced at
in The conversion function, 'PalmRose' became 'PalmRose' Which is priced at
in The conversion function, 'AirplaneRealisticpropellor' became 'AirplaneRealisticpropellor' Which is priced at
in The conversion function, 'DogPullOnLeash' became 'DogPullOnLeash' Which is priced at
in The conversion function, 'DachshundPortrait' became 'DachshundPortrait' Which is priced at
in The conversion function, 'ScubaDiver' became 'ScubaDiver' Which is priced at
in The conversion function, 'MermaidSolidprop' became 'MermaidSolidprop' Which is priced at
in The conversion function, 'MarlinSolidpropeller' became 'MarlinSolidpropeller' Which is priced at
in The conversion function, 'Clarinet' became 'Clarinet' Which is priced at
in The conversion function, 'CarAuto' became 'CarAuto' Which is priced at
in The conversion function, 'PalmTreeSetWithKeywest' became 'PalmTreeSetWithKeywest' Which is priced at
in The conversion function, 'LightHouseTwo' became 'LightHouseTwo' Which is priced at
in The conversion function, 'TeddyBear' became 'TeddyBear' Which is priced at
in The conversion function, 'PitbullPortrait' became 'PitbullPortrait' Which is priced at
in The conversion function, 'ShihtzuPortrait49' became 'ShihtzuPortrait' Which is priced at 49
in The conversion function, 'BoatSimple' became 'BoatSimple' Which is priced at
in The conversion function, 'Drums29' became 'Drums' Which is priced at 29
in The conversion function, 'AngelPropeller' became 'AngelPropeller' Which is priced at
in The conversion function, 'FairyPropeller' became 'FairyPropeller' Which is priced at
in The conversion function, 'FishWheeled' became 'FishWheeled' Which is priced at
in The conversion function, 'SailboatPropeller' became 'SailboatPropeller' Which is priced at
in The conversion function, 'ScubaPropellerMale' became 'ScubaPropellerMale' Which is priced at
in The conversion function, 'OwlWings' became 'OwlWings' Which is priced at
in The conversion function, 'Peacock' became 'Peacock' Which is priced at
in The conversion function, 'DogFuzzyFace' became 'DogFuzzyFace' Which is priced at
in The conversion function, 'DachshundPlay' became 'DachshundPlay' Which is priced at
in The conversion function, 'ScubaPropellerFemale' became 'ScubaPropellerFemale' Which is priced at
in The conversion function, 'DramaMasks' became 'DramaMasks' Which is priced at
in The conversion function, 'GatorsFlorida' became 'GatorsFlorida' Which is priced at
in The conversion function, 'DogStick' became 'DogStick' Which is priced at
in The conversion function, 'MechanicalFish' became 'MechanicalFish' Which is priced at
in The conversion function, 'AligatorMechanical' became 'AligatorMechanical' Which is priced at
in The conversion function, 'DogChaseBall' became 'DogChaseBall' Which is priced at
in The conversion function, 'DachshundWalking' became 'DachshundWalking' Which is priced at
in The conversion function, 'KwFancyPalm39' became 'KwFancyPalm' Which is priced at 39
in The conversion function, 'ToMoonCopper' became 'ToMoonCopper' Which is priced at
in The conversion function, 'ToMoon34' became 'ToMoon' Which is priced at 34
in The conversion function, 'DachshundSad' became 'DachshundSad' Which is priced at
in The conversion function, 'UnicornStars' became 'UnicornStars' Which is priced at
in The conversion function, 'DragonMechanicalWoodbase' became 'DragonMechanicalWoodbase' Which is priced at
in The conversion function, 'Police' became 'Police' Which is priced at
in The conversion function, 'Panda' became 'Panda' Which is priced at
in The conversion function, 'Hellicopter' became 'Hellicopter' Which is priced at
in The conversion function, 'ChickenMechanical' became 'ChickenMechanical' Which is priced at
in The conversion function, 'TrexMechanical' became 'TrexMechanical' Which is priced at
in The conversion function, 'Skull' became 'Skull' Which is priced at
in The conversion function, 'KwFancyPalm49' became 'KwFancyPalm' Which is priced at 49
in The conversion function, 'Bee' became 'Bee' Which is priced at
in The conversion function, 'SunFlower' became 'SunFlower' Which is priced at
in The conversion function, 'frog' became 'frog' Which is priced at
in The conversion function, 'Bike35' became 'Bike' Which is priced at 35
in The conversion function, 'DragonFly35' became 'DragonFly' Which is priced at 35
in The conversion function, 'CatWithBall24' became 'CatWithBall' Which is priced at 24
in The conversion function, 'ChickenCopper39' became 'ChickenCopper' Which is priced at 39
in The conversion function, 'AligatorCartoon' became 'AligatorCartoon' Which is priced at
in The conversion function, 'MermaidBase' became 'MermaidBase' Which is priced at
in The conversion function, 'PomeranianPortrait' became 'PomeranianPortrait' Which is priced at
in The conversion function, 'TheBirdSignHand' became 'TheBirdSignHand' Which is priced at
in The conversion function, 'Ship' became 'Ship' Which is priced at
in The conversion function, 'EtsyOrder' became 'EtsyOrder' Which is priced at
in The conversion function, 'TrexOne' became 'TrexOne' Which is priced at
in The conversion function, 'ViolinPlayer' became 'ViolinPlayer' Which is priced at
in The conversion function, 'FlowerPropeller' became 'FlowerPropeller' Which is priced at
in The conversion function, 'FlowerVase' became 'FlowerVase' Which is priced at
in The conversion function, 'Drums39' became 'Drums' Which is priced at 39
in The conversion function, 'FlowerCounterSpin' became 'FlowerCounterSpin' Which is priced at
in The conversion function, 'CatLargeJumpDown' became 'CatLargeJumpDown' Which is priced at
in The conversion function, 'CatLargeCrouched' became 'CatLargeCrouched' Which is priced at
in The conversion function, 'NamesInfinity' became 'NamesInfinity' Which is priced at
in The conversion function, 'GuaCopper35Acoustic' became 'GuaCopper35Acoustic' Which is priced at
in The conversion function, 'FlamingoWingsUp' became 'FlamingoWingsUp' Which is priced at
in The conversion function, 'CarPalm' became 'CarPalm' Which is priced at
in The conversion function, 'Alligator3D' became 'Alligator3D' Which is priced at
in The conversion function, 'FlowerBounce' became 'FlowerBounce' Which is priced at
in The conversion function, 'BeMyHero' became 'BeMyHero' Which is priced at
in The conversion function, 'GrayhoundProfile' became 'GrayhoundProfile' Which is priced at
in The conversion function, 'MarlinSpring' became 'MarlinSpring' Which is priced at
in The conversion function, 'DrumsCymbolsBrass39' became 'DrumsCymbolsBrass' Which is priced at 39
in The conversion function, 'LightHouseKeyWest' became 'LightHouseKeyWest' Which is priced at
in The conversion function, 'DragonFrontFacingDetailed' became 'DragonFrontFacingDetailed' Which is priced at
in The conversion function, 'HeartSpiral' became 'HeartSpiral' Which is priced at
in The conversion function, 'SoccerPlayer' became 'SoccerPlayer' Which is priced at
in The conversion function, 'StoneSculpture' became 'StoneSculpture' Which is priced at
in The conversion function, 'FloridaMap' became 'FloridaMap' Which is priced at
in The conversion function, 'TrophyFishing' became 'TrophyFishing' Which is priced at
in The conversion function, 'SunsetSailboatPalmtreeOne' became 'SunsetSailboatPalmtreeOne' Which is priced at
in The conversion function, 'PalmTreeChickens39' became 'PalmTreeChickens' Which is priced at 39
in The conversion function, 'PalmPatina' became 'PalmPatina' Which is priced at
in The conversion function, 'FlipFlops' became 'FlipFlops' Which is priced at
in The conversion function, 'MargheritaSunset' became 'MargheritaSunset' Which is priced at
in The conversion function, 'Parrot' became 'Parrot' Which is priced at
in The conversion function, 'Ornament' became 'Ornament' Which is priced at
in The conversion function, 'WeatherCock' became 'WeatherCock' Which is priced at
in The conversion function, 'DolphinProp' became 'DolphinProp' Which is priced at
in The conversion function, 'MotorcycleChicken' became 'MotorcycleChicken' Which is priced at
in The conversion function, 'Earrings' became 'Earrings' Which is priced at
in The conversion function, 'PineappleEarrings' became 'PineappleEarrings' Which is priced at
in The conversion function, 'JellyfishEarrings' became 'JellyfishEarrings' Which is priced at
in The conversion function, 'SunsetEarrings' became 'SunsetEarrings' Which is priced at
in The conversion function, 'TurtleEarrings' became 'TurtleEarrings' Which is priced at
in The conversion function, 'ChickenEarrings' became 'ChickenEarrings' Which is priced at
in The conversion function, 'SingleNamePalm' became 'SingleNamePalm' Which is priced at
in The conversion function, 'KeywestWordEarrings' became 'KeywestWordEarrings' Which is priced at
in The conversion function, 'TwoChairPalm' became 'TwoChairPalm' Which is priced at
in The conversion function, 'ChairPalm' became 'ChairPalm' Which is priced at
in The conversion function, 'ChairName' became 'ChairName' Which is priced at
in The conversion function, 'TurtleTag' became 'TurtleTag' Which is priced at
in The conversion function, 'WaveEarrings' became 'WaveEarrings' Which is priced at
in The conversion function, 'SunEarrings' became 'SunEarrings' Which is priced at
in The conversion function, 'AbstractEarringsSwirlies' became 'AbstractEarringsSwirlies' Which is priced at
in The conversion function, 'SharkToothEarings' became 'SharkToothEarings' Which is priced at
in The conversion function, 'HairClipBird' became 'HairClipBird' Which is priced at
in The conversion function, 'NailClipLizard' became 'NailClipLizard' Which is priced at
in The conversion function, 'PalmTreeChickens49' became 'PalmTreeChickens' Which is priced at 49
in The conversion function, 'PalmFancyTurtle' became 'PalmFancyTurtle' Which is priced at
in The conversion function, 'SongBird' became 'SongBird' Which is priced at
in The conversion function, 'MobileEarrings' became 'MobileEarrings' Which is priced at
in The conversion function, 'Cigar' became 'Cigar' Which is priced at
in The conversion function, 'LoveYouMoreTricolor' became 'LoveYouMoreTricolor' Which is priced at
in The conversion function, 'LargeBirdSinging' became 'LargeBirdSinging' Which is priced at
in The conversion function, 'UnalomeEarrings' became 'UnalomeEarrings' Which is priced at
in The conversion function, 'GlassChicken' became 'GlassChicken' Which is priced at
in The conversion function, 'WoodShark' became 'WoodShark' Which is priced at
in The conversion function, 'WoodChairRowBoatPalm' became 'WoodChairRowBoatPalm' Which is priced at
in The conversion function, 'WoodFlamingo' became 'WoodFlamingo' Which is priced at
in The conversion function, 'WoodFlowers' became 'WoodFlowers' Which is priced at
in The conversion function, 'MobileFishWood' became 'MobileFishWood' Which is priced at
in The conversion function, 'WoodHammockPalms49' became 'WoodHammockPalms' Which is priced at 49
in The conversion function, 'WoodFishingPole' became 'WoodFishingPole' Which is priced at
in The conversion function, 'WoodCoralReef' became 'WoodCoralReef' Which is priced at
in The conversion function, 'WoodPelicanPost' became 'WoodPelicanPost' Which is priced at
in The conversion function, 'WoodBridgeBoatPalmPedestal' became 'WoodBridgeBoatPalmPedestal' Which is priced at
in The conversion function, 'CatDownwardPosition' became 'CatDownwardPosition' Which is priced at
in The conversion function, 'CatSittingUp' became 'CatSittingUp' Which is priced at
in The conversion function, 'WoodPalmBoat' became 'WoodPalmBoat' Which is priced at
in The conversion function, 'WoodFishingPoleBeer' became 'WoodFishingPoleBeer' Which is priced at
in The conversion function, 'ChickenWood' became 'ChickenWood' Which is priced at
in The conversion function, 'BoatWingsSunset' became 'BoatWingsSunset' Which is priced at
in The conversion function, 'KwWoodPalm' became 'KwWoodPalm' Which is priced at
in The conversion function, 'HumanPortrait' became 'HumanPortrait' Which is priced at
in The conversion function, 'WoodNameHeartPalm' became 'WoodNameHeartPalm' Which is priced at
in The conversion function, 'DogEarrings' became 'DogEarrings' Which is priced at
in The conversion function, 'JellyFishSilver' became 'JellyFishSilver' Which is priced at
in The conversion function, 'JellyfishEarringsSilver' became 'JellyfishEarringsSilver' Which is priced at
in The conversion function, 'HeartEaringsGold' became 'HeartEaringsGold' Which is priced at
in The conversion function, 'TurtleShellEarrings' became 'TurtleShellEarrings' Which is priced at
in The conversion function, 'KwPalm49' became 'KwPalm' Which is priced at 49
in The conversion function, 'CatLargeWalking' became 'CatLargeWalking' Which is priced at
in The conversion function, 'SeahorseEarrings' became 'SeahorseEarrings' Which is priced at
in The conversion function, 'DachshundEarrings' became 'DachshundEarrings' Which is priced at
in The conversion function, 'WoodHammockPalms59' became 'WoodHammockPalms' Which is priced at 59
in The conversion function, 'WoodHammockPalmGroup' became 'WoodHammockPalmGroup' Which is priced at
in The conversion function, 'TurtleCopper15' became 'TurtleCopper' Which is priced at 15
in The conversion function, 'PalmDoubleTreeTwin59' became 'PalmDoubleTreeTwin' Which is priced at 59
in The conversion function, 'LoveSignLanguageCopper19' became 'LoveSignLanguageCopper' Which is priced at 19
inventory query to create data for printing table returns a mysql result
SELECT
ID
, Name
, Price
, On_Display
, Inventory
, Backup
, Other_Sales
, Total_Sales
, Out_of_Blue
, Request_View_no_Sale
, Make_Time
, MaxStock
,((Price*On_Display)+(Price*Inventory)+(Price*Backup))
,(((Price-MaterialCost)*10)/Other_Sales)
,((On_Display + Inventory + Backup)*(Other_Sales))
, GroupID
, MinDisplay
, MaterialCost
FROM Inventory
WHERE Name != '0'
AND ID IN (1,2,3,4,5,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685)
ORDER BY Name ASC NameReturned = AbstractEarringsSwirlies NameReturned = AcousticGuitarGroup NameReturned = AddSomeSchtuff NameReturned = AirplanePropeller39 NameReturned = AirplanePropeller39 NameReturned = AirplanePropeller39 NameReturned = AirplaneSimple16$ NameReturned = AligatorCartoon NameReturned = AligatorMechanical NameReturned = AligatorOne20$ NameReturned = AligatorCartoon NameReturned = AngelPropeller NameReturned = AppleOne NameReturned = DogPortrait NameReturned = BalletCopper NameReturned = BassFiddle NameReturned = BassFish NameReturned = Bee NameReturned = BeMyHero NameReturned = BikeOne NameReturned = BikeOne NameReturned = BoatSimple NameReturned = BoatWingsSunset NameReturned = BostonTerrierPortrait NameReturned = DogPortrait NameReturned = BrokenItem NameReturned = Budha NameReturned = DogPortrait NameReturned = BullOne NameReturned = ButterFlyPair NameReturned = ButterFlySimple NameReturned = CactusOne NameReturned = CameraOne NameReturned = CarAuto NameReturned = CarPalm NameReturned = CartoonCharacter NameReturned = CatDownwardPosition NameReturned = CatWithBall29 NameReturned = CatLargeJumpDown NameReturned = CatLargeWalking NameReturned = CatPortrait NameReturned = CatSittingUp NameReturned = CatWithBall29 NameReturned = CatWithBall29 NameReturned = ChairName NameReturned = ChairPalm NameReturned = ChickenOne29 NameReturned = ChickenEarrings NameReturned = ChickenMechanical NameReturned = ChickenOne29 NameReturned = ChickenOne29 NameReturned = ChickenWood NameReturned = DogPortrait NameReturned = Chiropractor NameReturned = Cigar NameReturned = Clarinet NameReturned = DogPortrait NameReturned = DogPortrait NameReturned = DogPortrait NameReturned = CowOne NameReturned = CrabGold NameReturned = Cross NameReturned = DachshundGroup NameReturned = DachshundEarrings NameReturned = DachshundGroup NameReturned = DachshundGroup NameReturned = DachshundGroup NameReturned = DogPortrait NameReturned = DachshundGroup NameReturned = DachshundGroup NameReturned = DeletedItem NameReturned = DogSketch NameReturned = DogEarrings NameReturned = DogPortrait NameReturned = DogPortrait NameReturned = DogSketch NameReturned = DogSide NameReturned = DogSketch NameReturned = DogSketch NameReturned = DogSketch NameReturned = DolphinOne NameReturned = DolphinProp NameReturned = Doodle NameReturned = DragonGroup NameReturned = DragonGroup NameReturned = DragonFly35 NameReturned = DragonFlyOne NameReturned = DragonGroup NameReturned = DragonGroup NameReturned = DragonMechanicalWoodbase NameReturned = DramaMasks NameReturned = DrumsOne NameReturned = DrumsOne NameReturned = DrumsOne NameReturned = DrumsOne NameReturned = Earrings NameReturned = ElectricGuitar NameReturned = ElephantGroup NameReturned = ElephantGroup NameReturned = ElephantGroup NameReturned = ElephantGroup NameReturned = EtsyOrder NameReturned = FairyPropeller NameReturned = FerretOne NameReturned = FigureHuman NameReturned = FishingPoleGroup NameReturned = FishingPoleGroup NameReturned = FishingPoleGroup NameReturned = FishingPoleGroup NameReturned = FishingPoleGroup NameReturned = FishPwFishingPolePinWheel NameReturned = FishWheeled NameReturned = FlamingoOne NameReturned = FlamingoOne NameReturned = FlipFlops NameReturned = FloridaMap NameReturned = FlowerVase NameReturned = FlowerPropeller NameReturned = FlowerPropeller NameReturned = FlowerVase NameReturned = FrenchHornG NameReturned = DogPortrait NameReturned = frog NameReturned = GatorsFlorida NameReturned = DogPortrait NameReturned = GiraffeOne NameReturned = GlassChicken NameReturned = GoldenDoodlePortrait NameReturned = ElectricGuitar NameReturned = GoldFishBrassCopper NameReturned = GrayhoundProfile NameReturned = AcousticGuitarGroup NameReturned = GuaCopperAcousticGuitar NameReturned = AcousticGuitarGroup NameReturned = ElectricGuitar NameReturned = ElectricGuitar NameReturned = Gymnast NameReturned = HairClipBird NameReturned = HairDresser NameReturned = HeartEaringsGold NameReturned = HeartSpiral NameReturned = Hellicopter NameReturned = HippoOne NameReturned = HogfishOne NameReturned = HorseGroup NameReturned = HorseGroup NameReturned = HumanPortrait NameReturned = HummingBirdRg NameReturned = ILoveYouFourRose NameReturned = ILoveYouGroup NameReturned = LoveMomGroup NameReturned = LoveMomGroup NameReturned = ILoveYouMoreGroup NameReturned = ILoveYouMoreGroup NameReturned = ILoveYouMoreGroup NameReturned = ILoveYouMoreGroup NameReturned = ILoveYouMoreGroup NameReturned = DogPortrait NameReturned = JellyfishEarrings NameReturned = JellyfishEarringsSilver NameReturned = JellyFishSilver NameReturned = Judge NameReturned = KeyWestPalmTree NameReturned = KeywestWordEarrings NameReturned = DogPortrait NameReturned = KeyWestPalmTree NameReturned = KeyWestPalmTree NameReturned = KeyWestPalmTree NameReturned = KeyWestPalmTree NameReturned = KeyWestPalmTree NameReturned = KwWoodPalm NameReturned = DogPortrait NameReturned = Lacrosse NameReturned = LargeBirdSinging NameReturned = LightHouseTwo NameReturned = LightHouseTwo NameReturned = LionFace NameReturned = LobsterOne NameReturned = LogoBusiness NameReturned = LoveFourHandsGroup NameReturned = LoveFourHandsGroup NameReturned = LoveFourHandsGroup NameReturned = LoveFourHandsGroup NameReturned = LoveSignGroup NameReturned = LoveMomGroup NameReturned = LoveSignGroup NameReturned = LoveSignGroup NameReturned = LoveSignGroup NameReturned = LoveSignGroup NameReturned = ILoveYouMoreGroup NameReturned = MahiMahiFish NameReturned = Manetee NameReturned = MargheritaSunset NameReturned = MarlinPropeller NameReturned = MarlinSolidpropeller NameReturned = MarlinSpring NameReturned = MechanicalFish NameReturned = MermaidBase NameReturned = MermaidPropeller49 NameReturned = MermaidSolidprop NameReturned = Microphone NameReturned = Misc NameReturned = MobileEarrings NameReturned = MobileFishWood NameReturned = MotorcycleChicken NameReturned = MotorcycleOne NameReturned = NailClipLizard NameReturned = NameHeartNameThree NameReturned = NameOne NameReturned = NamesInfinity NameReturned = NameWithBasketball NameReturned = NawNamesWithDoublePalms NameReturned = OctopusOne NameReturned = Ornament NameReturned = Otter NameReturned = OwlOne NameReturned = OwlOne NameReturned = PalmGold NameReturned = PalmDoubleTreeTwin NameReturned = PalmDoubleTreeTwin NameReturned = PalmFancyTurtle NameReturned = NawNamesWithDoublePalms NameReturned = PalmGold NameReturned = PalmPatina NameReturned = PalmRose NameReturned = PalmTreeChickens39 NameReturned = PalmTreeChickens39 NameReturned = PalmTreeGroup NameReturned = PalmTreeSetWithKeywest NameReturned = Panda NameReturned = Parrot NameReturned = Peacock NameReturned = PelicanGroup NameReturned = PelicanGroup NameReturned = PelicanGroup NameReturned = PenguinOne NameReturned = PetPortraitNotDog NameReturned = PhoropterOptometrist NameReturned = Phrase NameReturned = PianoCopper NameReturned = PianoCopper NameReturned = PigFlyGroup NameReturned = PigFlyGroup NameReturned = PigFlyGroup NameReturned = Piggie12$ NameReturned = PineappleGroup NameReturned = PineappleGoldGilt NameReturned = PineappleEarrings NameReturned = PineappleGoldGilt NameReturned = PineappleGroup NameReturned = PineappleGroup NameReturned = DogPortrait NameReturned = Police NameReturned = DogPortrait NameReturned = PropellerOne NameReturned = DogPortrait NameReturned = RedFishTwo NameReturned = RetiredTuSmallTurtle7$ NameReturned = RoseSmall NameReturned = SailboatPropeller NameReturned = SaxOne NameReturned = ScubaDiver NameReturned = ScubaPropellerMale NameReturned = ScubaPropellerMale NameReturned = SeahorseEarrings NameReturned = Shark NameReturned = SharkToothEarings NameReturned = DogPortrait NameReturned = DogPortrait NameReturned = Ship NameReturned = LoveSignGroup NameReturned = signLanguageName NameReturned = SingleNamePalm NameReturned = Skull NameReturned = SoccerBallTwo NameReturned = SoccerPlayer NameReturned = SongBird NameReturned = StoneSculpture NameReturned = SunEarrings NameReturned = SunFaceG NameReturned = SunFlower NameReturned = SunsetEarrings NameReturned = SunsetSailboatPalmtreeOne NameReturned = TeddyBear NameReturned = TestFour NameReturned = TestThree NameReturned = TestWhatever NameReturned = TheBirdSignHand NameReturned = Tip NameReturned = ToMoonGold NameReturned = ToMoonGold NameReturned = ToMoonGold NameReturned = TractorOne NameReturned = TrexMechanical NameReturned = TrexOne NameReturned = TrophyFishing NameReturned = TrumpetOne NameReturned = TuBallanceTurtle NameReturned = TurtleGold NameReturned = TurtleCopper19 NameReturned = TurtleGold NameReturned = TurtleCopper19 NameReturned = TurtleCopper19 NameReturned = TurtleCopper29 NameReturned = TurtleEarrings NameReturned = TurtleGold NameReturned = TurtleShellEarrings NameReturned = TurtleSilver NameReturned = TurtleTag NameReturned = TwoChairPalm NameReturned = UnalomeEarrings NameReturned = UnicornOne NameReturned = UnicornOne NameReturned = ViolinPlayer NameReturned = VWBus NameReturned = WaveEarrings NameReturned = WeatherCock NameReturned = DogPortrait NameReturned = WineGlass NameReturned = WoodBridgeBoatPalmPedestal NameReturned = WoodChairRowBoatPalm NameReturned = WoodCoralReef NameReturned = WoodFishingPole NameReturned = WoodFishingPole NameReturned = WoodFlamingo NameReturned = WoodFlowers NameReturned = WoodHammockPalmGroup NameReturned = WoodHammockPalmGroup NameReturned = WoodHammockPalmGroup NameReturned = WoodNameHeartPalm NameReturned = WoodPalmBoat NameReturned = WoodPelicanPost NameReturned = WoodShark NameReturned = DogPortrait NameReturned = ZebraOne