Order=94-01117-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (94, '01117', '1', '', '', '', '', '', '2025-04-13 10:59:54', 'ORDERED', '2025-04-13 10:59:54', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 10:59:54', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 Order=95-22230-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '22230', '1', '', '', '', '', '', '2025-04-13 11:37:37', 'ORDERED', '2025-04-13 11:37:37', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 11:37:37', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '22230', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-13 11:37:37', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 11:37:37' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '22230' AND Type = '1' AND ItemId = 1 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=95-22230-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '22230', '1', '', '', '', '', '', '2025-04-13 12:04:32', 'ORDERED', '2025-04-13 12:04:32', 80, 0, 11.20, 0, 10, 101.20) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 12:04:32', Amount=80, Savings=0, ServiceFee=11.20, Tax=0, Shipping=10, Total=101.20 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '22230', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-13 12:04:32', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 12:04:32' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '22230' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '22230', '1', 2, 0, 'A', '', '', '0', '', '', '', 4, '80', '0', 'ORDERED', '2025-04-13 12:04:32', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'A', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 4, Cost = 80, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 12:04:32' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '22230' AND Type = '1' AND ItemId = 2 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 1, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '122021', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '122021', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 2, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '122023', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '122023', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 3, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '122024', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '122024', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 4, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '121793', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '121793', Suffix = 'JPG' Order=95-22230-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '22230', '1', '', '', '', '', 'M', '2025-04-13 12:04:53', 'ORDERED', '2025-04-13 12:04:53', 80, 0, 11.20, 0, 10, 101.20) ON DUPLICATE KEY UPDATE Fulfillment = 'M', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 12:04:53', Amount=80, Savings=0, ServiceFee=11.20, Tax=0, Shipping=10, Total=101.20 Number of Items = 2 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '22230', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-13 12:04:53', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 12:04:53' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '22230' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '22230', '1', 2, 0, 'A', '', '', '0', '', '', '', 4, '80', '0', 'ORDERED', '2025-04-13 12:04:53', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'A', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 4, Cost = 80, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 12:04:53' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '22230' AND Type = '1' AND ItemId = 2 Number of Images = 4 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 1, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '122021', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '122021', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 2, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '122023', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '122023', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 3, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '122024', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '122024', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '22230', '1', 2, 0, 4, '', '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', '121793', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/DALLAS_SKYLINE_11_BLACK_NATL_CT77_05PM_04-06_LK/', File = '121793', Suffix = 'JPG' Order=95-09033-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '09033', '1', '', '', '', '', '', '2025-04-13 13:07:30', 'ORDERED', '2025-04-13 13:07:30', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 13:07:30', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 Order=95-04025-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '04025', '1', '', '', '', '', '', '2025-04-13 14:49:01', 'ORDERED', '2025-04-13 14:49:01', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 14:49:01', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 Order=96-65291-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '65291', '1', '', '', '', '', '', '2025-04-13 17:08:05', 'ORDERED', '2025-04-13 17:08:05', 90, 30, 12.60, 0, 0, 102.60) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 17:08:05', Amount=90, Savings=30, ServiceFee=12.60, Tax=0, Shipping=0, Total=102.60 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '65291', '1', 1, 0, 'C', '', '', '0', '', '', '', 3, '90', '30', 'ORDERED', '2025-04-13 17:08:05', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 3, Cost = 90, Savings = 30, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 17:08:05' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '65291' AND Type = '1' AND ItemId = 1 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '65291', '1', 1, 0, 1, '', '17s/CLUB_V_17_LEXI_AMER_CT45_04PM_04-06_JW/', '081759', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '17s/CLUB_V_17_LEXI_AMER_CT45_04PM_04-06_JW/', File = '081759', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '65291', '1', 1, 0, 2, '', '17s/CLUB_V_17_LEXY_AMER_CT52_11AM_04-07_EL/', '105028', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '17s/CLUB_V_17_LEXY_AMER_CT52_11AM_04-07_EL/', File = '105028', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '65291', '1', 1, 0, 3, '', '17s/CLUB_V_17_LEXY_AMER_CT52_11AM_04-07_EL/', '104922', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '17s/CLUB_V_17_LEXY_AMER_CT52_11AM_04-07_EL/', File = '104922', Suffix = 'JPG' Order=95-13179-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '13179', '1', '', '', '', '', '', '2025-04-13 22:05:02', 'ORDERED', '2025-04-13 22:05:02', 90, 30, 12.60, 0, 0, 102.60) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 22:05:02', Amount=90, Savings=30, ServiceFee=12.60, Tax=0, Shipping=0, Total=102.60 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '13179', '1', 1, 0, 'C', '', '', '0', '', '', '', 3, '90', '30', 'ORDERED', '2025-04-13 22:05:02', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 3, Cost = 90, Savings = 30, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 22:05:02' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' AND ItemId = 1 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 1, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040807', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040807', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 2, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040790', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040790', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 3, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040791', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040791', Suffix = 'JPG' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '13179', '1', 2, 0, 'C', '', '', '0', '', '', '', 0, '0', '0', 'ORDERED', '2025-04-13 22:05:02', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 0, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 22:05:02' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' AND ItemId = 2 Number of Images = 0 Order=95-13179-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '13179', '1', '', '', '', '', '', '2025-04-13 22:06:19', 'ORDERED', '2025-04-13 22:06:19', 90, 30, 12.60, 0, 0, 102.60) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 22:06:19', Amount=90, Savings=30, ServiceFee=12.60, Tax=0, Shipping=0, Total=102.60 Number of Items = 2 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '13179', '1', 1, 0, 'C', '', '', '0', '', '', '', 3, '90', '30', 'ORDERED', '2025-04-13 22:06:19', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 3, Cost = 90, Savings = 30, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 22:06:19' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' AND ItemId = 1 Number of Images = 3 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 1, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040807', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040807', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 2, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040790', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040790', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 3, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040791', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040791', Suffix = 'JPG' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '13179', '1', 2, 0, 'C', '', '', '0', '', '', '', 0, '0', '0', 'ORDERED', '2025-04-13 22:06:19', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 0, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 22:06:19' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' AND ItemId = 2 Number of Images = 0 Order=95-13179-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '13179', '1', '', '', '', '', '', '2025-04-13 22:07:26', 'ORDERED', '2025-04-13 22:07:26', 40, 0, 5.60, 0, 0, 45.60) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 22:07:26', Amount=40, Savings=0, ServiceFee=5.60, Tax=0, Shipping=0, Total=45.60 Number of Items = 2 DELETE FROM orderitems WHERE GalleryId = 95 AND Album = '13179' AND Type='1' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '13179', '1', 1, 0, 'C', '', '', '0', '', '', '', 1, '40', '0', 'ORDERED', '2025-04-13 22:07:26', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 40, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 22:07:26' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' AND ItemId = 1 Number of Images = 3 DELETE FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 1, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040807', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040807', Suffix = 'JPG' Order=95-13179-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '13179', '1', '', '', '', '', 'M', '2025-04-13 22:07:34', 'ORDERED', '2025-04-13 22:07:34', 40, 0, 5.60, 0, 0, 45.60) ON DUPLICATE KEY UPDATE Fulfillment = 'M', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-13 22:07:34', Amount=40, Savings=0, ServiceFee=5.60, Tax=0, Shipping=0, Total=45.60 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '13179', '1', 1, 0, 'C', '', '', '0', '', '', '', 1, '40', '0', 'ORDERED', '2025-04-13 22:07:34', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 40, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-13 22:07:34' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '13179' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '13179', '1', 1, 0, 1, '', '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', '040807', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '11s/FORT_WORTH_FIRE_11_PURPLE_CLUB_CT82_0430PM_04-05_JB/', File = '040807', Suffix = 'JPG' Order=96-00001-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '00001', '1', '', '', '', '', '', '2025-04-14 10:23:36', 'ORDERED', '2025-04-14 10:23:36', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 10:23:36', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '00001', '1', 1, 0, '', '', '', '0', '', '', '', 0, '0', '0', 'ORDERED', '2025-04-14 10:23:36', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 0, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 10:23:36' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '00001' AND Type = '1' AND ItemId = 1 Number of Images = 0 Order=96-00888-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '00888', '1', '', '', '', '', '', '2025-04-14 14:03:33', 'ORDERED', '2025-04-14 14:03:33', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 14:03:33', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 Order=96-00888-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '00888', '1', '', '', '', '', '', '2025-04-14 14:03:33', 'ORDERED', '2025-04-14 14:03:33', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 14:03:33', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 Order=95-01124-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '01124', '1', '', '', '', '', '', '2025-04-14 19:18:43', 'ORDERED', '2025-04-14 19:18:43', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 19:18:43', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '01124', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 19:18:43', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 19:18:43' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '01124' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '01124', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=95-01124-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '01124', '1', '', '', '', '', '', '2025-04-14 19:19:37', 'ORDERED', '2025-04-14 19:19:37', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 19:19:37', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (95, '01124', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 19:19:37', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 19:19:37' SELECT Album FROM orderimages WHERE GalleryId = 95 AND Album = '01124' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (95, '01124', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=96-44414-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '44414', '1', '', '', '', '', '', '2025-04-14 18:22:07', 'ORDERED', '2025-04-14 18:22:07', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 18:22:07', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '44414', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 18:22:07', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 18:22:07' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '44414' AND Type = '1' AND ItemId = 1 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '44414', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=96-44414-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '44414', '1', '', '', '', '', '', '2025-04-14 18:22:24', 'ORDERED', '2025-04-14 18:22:24', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 18:22:24', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '44414', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 18:22:24', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 18:22:24' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '44414' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '44414', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=96-34511-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '34511', '1', '', '', '', '', '', '2025-04-14 19:55:38', 'ORDERED', '2025-04-14 19:55:38', 0, 0, 0, 0, 0, 0) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 19:55:38', Amount=0, Savings=0, ServiceFee=0, Tax=0, Shipping=0, Total=0 Number of Items = 0 Order=96-34511-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '34511', '1', '', '', '', '', '', '2025-04-14 20:01:37', 'ORDERED', '2025-04-14 20:01:37', 70, 10, 9.80, 0, 0, 79.80) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 20:01:37', Amount=70, Savings=10, ServiceFee=9.80, Tax=0, Shipping=0, Total=79.80 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '34511', '1', 1, 0, 'C', '', '', '0', '', '', '', 2, '70', '10', 'ORDERED', '2025-04-14 20:01:37', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'C', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 2, Cost = 70, Savings = 10, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:01:37' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '34511' AND Type = '1' AND ItemId = 1 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '34511', '1', 1, 0, 1, '', '15s/SF_ELITE_15_SALAZAR__NC_OPEN_CT36_11AM_04-12_KE/', '161473', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/SF_ELITE_15_SALAZAR__NC_OPEN_CT36_11AM_04-12_KE/', File = '161473', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '34511', '1', 1, 0, 2, '', '15s/SF_ELITE_15_SALAZAR__NC_OPEN_CT36_11AM_04-12_KE/', '161640', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/SF_ELITE_15_SALAZAR__NC_OPEN_CT36_11AM_04-12_KE/', File = '161640', Suffix = 'JPG' Order=96-77777-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '77777', '1', '', '', '', '', '', '2025-04-14 20:14:05', 'ORDERED', '2025-04-14 20:14:05', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 20:14:05', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 0 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 20:14:05', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:14:05' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 1 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=96-77777-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '77777', '1', '', '', '', '', '', '2025-04-14 20:14:06', 'ORDERED', '2025-04-14 20:14:06', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 20:14:06', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 20:14:06', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:14:06' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=96-77777-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '77777', '1', '', '', '', '', '', '2025-04-14 20:17:53', 'ORDERED', '2025-04-14 20:17:53', 80, 0, 11.20, 0, 10, 101.20) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 20:17:53', Amount=80, Savings=0, ServiceFee=11.20, Tax=0, Shipping=10, Total=101.20 Number of Items = 1 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 20:17:53', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:17:53' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 2, 0, 'A', '', '', '0', '', '', '', 4, '80', '0', 'ORDERED', '2025-04-14 20:17:53', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'A', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 4, Cost = 80, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:17:53' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 2 Number of Images = 0 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 1, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', '144318', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', File = '144318', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 2, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', '144492', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', File = '144492', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 3, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', '195437', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', File = '195437', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 4, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', '195825', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', File = '195825', Suffix = 'JPG' Order=96-77777-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '77777', '1', '', '', '', '', 'M', '2025-04-14 20:17:58', 'ORDERED', '2025-04-14 20:17:58', 80, 0, 11.20, 0, 10, 101.20) ON DUPLICATE KEY UPDATE Fulfillment = 'M', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 20:17:58', Amount=80, Savings=0, ServiceFee=11.20, Tax=0, Shipping=10, Total=101.20 Number of Items = 2 INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 20:17:58', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:17:58' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 2, 0, 'A', '', '', '0', '', '', '', 4, '80', '0', 'ORDERED', '2025-04-14 20:17:58', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = 'A', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 4, Cost = 80, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:17:58' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 2 Number of Images = 4 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 1, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', '144318', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', File = '144318', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 2, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', '144492', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT47_08AM_04-12_JW/', File = '144492', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 3, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', '195437', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', File = '195437', Suffix = 'JPG' INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 2, 0, 4, '', '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', '195825', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '15s/NEXT_LEVEL_15_NAUPAKA__SC__AMER_CT74_10AM_04-13_PC/', File = '195825', Suffix = 'JPG' Order=96-77777-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (96, '77777', '1', '', '', '', '', '', '2025-04-14 20:21:35', 'ORDERED', '2025-04-14 20:21:35', 0, 0, 0.00, 0, 0, 0.00) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 20:21:35', Amount=0, Savings=0, ServiceFee=0.00, Tax=0, Shipping=0, Total=0.00 Number of Items = 2 DELETE FROM orderitems WHERE GalleryId = 96 AND Album = '77777' AND Type='1' INSERT INTO orderitems (GalleryId, Album, Type, ItemId, PackageId, ItemCode, Option1, Option1Prompt, Option2, Option2Prompt, Option3, Option3Prompt, Qty, Cost, Savings, ItemStatus, ItemStatusChanged, PackagingTypeComputed, TrackingType, TrackingId) VALUES (96, '77777', '1', 1, 0, '', '', '', '0', '', '', '', 1, '0', '0', 'ORDERED', '2025-04-14 20:21:35', '', '', '') ON DUPLICATE KEY UPDATE ItemCode = '', Option1 = '', Option1Prompt = '', Option2 = '0', Option2Prompt = '', Option3 = '', Option3Prompt = '', Qty = 1, Cost = 0, Savings = 0, ItemStatus = 'ORDERED', ItemStatusChanged = '2025-04-14 20:21:35' SELECT Album FROM orderimages WHERE GalleryId = 96 AND Album = '77777' AND Type = '1' AND ItemId = 1 Number of Images = 1 INSERT INTO orderimages (GalleryId, Album, Type, ItemId, PackageId, ImageId, Qualifier, Path, File, Suffix) VALUES (96, '77777', '1', 1, 0, 1, '', '', '', 'JPG') ON DUPLICATE KEY UPDATE Qualifier = '', Path = '', File = '', Suffix = 'JPG' Order=95-10090-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '10090', '1', '', '', '', '', '', '2025-04-14 22:15:03', 'ORDERED', '2025-04-14 22:15:03', 0, 0, 0, 0, 0, 0) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 22:15:03', Amount=0, Savings=0, ServiceFee=0, Tax=0, Shipping=0, Total=0 Number of Items = 0 Order=95-10090-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '10090', '1', '', '', '', '', '', '2025-04-14 22:15:13', 'ORDERED', '2025-04-14 22:15:13', 0, 0, 0, 0, 0, 0) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 22:15:13', Amount=0, Savings=0, ServiceFee=0, Tax=0, Shipping=0, Total=0 Number of Items = 0 Order=95-10090-1 INSERT INTO orders (GalleryId, Album, Type, ShipFirst, ShipLast, Email, Text, Fulfillment, OrderDate, OrderStatus, OrderStatusChanged, Amount, Savings, ServiceFee, Tax, Shipping, Total) VALUES (95, '10090', '1', '', '', '', '', '', '2025-04-14 22:15:13', 'ORDERED', '2025-04-14 22:15:13', 0, 0, 0, 0, 0, 0) ON DUPLICATE KEY UPDATE Fulfillment = '', OrderStatus = 'ORDERED', OrderStatusChanged = '2025-04-14 22:15:13', Amount=0, Savings=0, ServiceFee=0, Tax=0, Shipping=0, Total=0 Number of Items = 0