INSERT INTO `watch` (`watchid`, `orderid`, `customer_id`, `receiptuser_id`, `altereduser_id`, `model`, `dateofreceipt`, `dateofinvoice`, `warranty`, `case`, `dial`, `brand`, `defectdescription`, `repairinfo`, `repairprice`, `dateofdispatch`, `dateoffinished`, `inprocess`, `control`, `waiting`, `finished`, `unfinished`, `defect`, `fetched`, `received_client`, `received_client_date`, `sent_repair_de`, `sent_repair_de_date`, `sent_shop_usa`, `sent_shop_usa_date`, `entrance`, `conveyed`, `conveyeddate`, `uip`, `uhost`, `week`, `sendnr`, `notes`) VALUES
(14740, 'T70845', 11759, 999999999, 0, '7001-Havana', '1970-01-01', '2025-11-13', '2024-06-06', 'gold', 'blue', 'Pionier', 'The calendar/date doesn\'t work properly, eg Displays Dec 32! ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '211.30.156.5', '211.30.156.5', '2025-11-13', '--', NULL),
(14741, 'T82051 ', 11762, 999999999, 0, '116-San Francisco', '1970-01-01', '2025-11-14', '2025-10-29', 'silver', 'silvgrey', 'Theorema', 'Watch doesn\'t fit my wrist ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '2600:387:f:5a12::7', '2600:387:f:5a12::7', '2025-11-14', '--', NULL),
(14742, '', 11763, 999999999, 0, '508-Dublin', '1970-01-01', '2025-11-16', '1970-01-01', 'bicolor gold', 'bicolor', 'Pionier', 'Mijn seconde wijzer is losgeraakt. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '77.163.17.235', '77-163-17-235.fixed.kpn.net', '2025-11-16', '--', NULL),
(14743, 'T82136', 11764, 999999999, 0, '123-Madame Butterfly', '2025-11-20', '2025-11-18', '2025-11-05', 'gold', 'gold', 'Theorema', 'My order number is T82136- The watch is brand new and unworn.. Please refund.', '--', '0', '1970-01-01', '2025-11-20', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '2a01:5241:400d:6101:28bc:10b2:2f8b:ff92', '2a01:5241:400d:6101:28bc:10b2:2f8b:ff92', '2025-11-18', '--', ''),
(14744, 'T82345', 11765, 999999999, 0, '121-St Petersburg', '1970-01-01', '2025-11-18', '2027-11-27', 'black', 'gold', 'Theorema', 'The minute hand is loose. The watch is brand new and never worn. Please  Replace.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '2a00:23c7:76f1:d101:b01e:f165:8f91:4166', '2a00:23c7:76f1:d101:b01e:f165:8f91:4166', '2025-11-18', '--', NULL),
(14745, 'Order number is T80405', 11766, 999999999, 0, '110-Oslo', '2025-12-07', '2025-11-19', '2025-07-28', 'black', 'silvgrey', 'Theorema', 'My Order number is T80405\nThe watch is running about 5 minutes ahead in 3 days\nPlease repair accordingly. \n\n', 'looks fine, timegrapher says 0.43s, 0.21ms \n\ntest start: 30.12.25 13:05\ntest end: 13.01.26 12:54\n\nrunning absolutely flawless, no issues at all, showing accurate time each day, send back', '0', '2026-01-13', '2026-01-13', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-30 13:09:21', 1, '2025-12-30 13:09:21', 1, '2026-01-14 12:28:21', 1, 1, '2026-01-17', '139.137.128.71', '139.137.128.71', '2025-11-19', '9405530109355273508019', ''),
(14746, 'GM-110-10', 11767, 999999999, 0, '110-Oslo', '1970-01-01', '2025-11-20', '2024-11-30', 'black', 'gold', 'Theorema', 'Time crown came out of watch.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '2607:fb91:3c05:9e27:5155:3b65:4b52:736a', '2607:fb91:3c05:9e27:5155:3b65:4b52:736a', '2025-11-20', '--', NULL),
(14747, '', 11768, 999999999, 0, 'other', '1970-01-01', '2025-11-20', '2025-11-11', 'gold', 'black', 'other', 'Tělo hodinek,je příliš vysoké ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '185.151.252.6', '252-6.nat.vejnet', '2025-11-20', '--', NULL),
(14748, ' #T75322', 11769, 999999999, 0, '117-Kingston', '2025-12-12', '2025-11-21', '2024-12-01', 'gold', 'gold', 'Theorema', 'I don\'t really know why, but the watch suddenly stopped working over a month ago. I thought it was powered by a battery, but when I looked at the watch\'s specifications, I couldn\'t find any battery information. I discovered it had stopped working for no apparent reason.', 'a small plastic piece from the movement holder ring broke off and was stuck between the balance wheel and hairspring, took it out, checked balance - all OK, demag case and mvt, cleaned hands and dial, glued outer dial circle , fresh crown and stem adhesive and lub and gasket grease, new gasket caseback', '0', '2026-01-13', '2026-01-13', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-01-14', '2a09:bac2:5265:286e::407:b', '2a09:bac2:5265:286e::407:b', '2025-11-21', '485657217603', 'Kullerstensvaegen 40\n13761 Jordbro'),
(14750, '417840506140', 11771, 999999999, 0, 'other', '2025-12-10', '2025-11-21', '2025-11-11', 'gold', 'black', 'other', 'Číslo mé objednávky je  T82286\nHodinky jsou zcela nové a nenošené,prosím o vrácení peněz.\nDěkuji Síkora Marek', '--', '0', '1970-01-01', '2025-12-10', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '193.165.247.194', 'karvina.org', '2025-11-21', '--', ''),
(14751, 'T82236', 11772, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-11-21', '2025-11-12', 'silver', 'white', 'Theorema', 'I ordered this watch by using the sort option on your site = Automatic filter. This watch kept coming up as I shopped = its lovely. This is my second Tufina watch as I loved my Pioneer. Sadly I received a manual watch but thought I will try it as its lovely. I wore it for 2 days approximately and wound it several times a day. I could not get it to keep time and was irritated by the winding so I opted to return before the 14 day policy. I love the automatic and it works great! I messaged your CS team and was told it was \"heavily worn\"? Impossible as I have not owned it very long. I am asking for a full refund or at very least a credit?  ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '2600:382:1b40:85ab:e82c:68c5:df75:1ba8', '2600:382:1b40:85ab:e82c:68c5:df75:1ba8', '2025-11-21', '--', NULL),
(14752, 'GM 115 12', 11773, 999999999, 0, '115-Helsinki', '2025-12-18', '2025-11-21', '2024-11-30', 'black', 'gold', 'Theorema', 'Crown pin came out.', 'glued outer dial ring, cleaned dial , new stem and crown, new case, cleaned band, demag mvt and case and band, 4.46s, 0.24ms, 298.2°', '0', '2026-01-13', '2026-01-13', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-30 15:28:09', 1, '2025-12-30 15:28:09', 1, '2026-01-14 12:26:44', 1, 1, '2026-01-17', '2607:fb91:3c05:9e27:3ca4:9f00:eb57:ff21', '2607:fb91:3c05:9e27:3ca4:9f00:eb57:ff21', '2025-11-21', '9405530109355273508026', ''),
(14753, 'GM 101 - 6', 11774, 999999999, 0, '101-Casablanca GM', '2025-12-30', '2025-11-21', '2024-07-17', 'silver', 'white', 'Theorema', '14428 I received my watch from repair, but the watch is still stopping randomly, even fully wound.\nPlease replace the movement with a new one. If the problem persist I will return it, asking for a refund, or replace it for a different stile.\nThanks very much for your attention to this matter.\nsincerely yours, Mario Ayala.', 'looks completely fine, timegrapher says same in all 6 positions, running smooth,  8.23s , 0.18ms\n\ntest start: 30.12.25 15:34\ntest end: 13.01.26 12:45 \n\nit is running perfectly fine, flawless, very good rate, will send it back, will prepare letter', '0', '2026-01-13', '2026-01-13', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-30 15:59:27', 1, '2025-12-30 15:59:27', 1, '2026-01-14 12:27:47', 1, 1, '2026-01-17', '2600:6c50:417f:7da4:8512:20a8:7bc1:53a6', 'syn-2600-6c50-417f-7da4-8512-20a8-7bc1-53a6.biz6.spectrum.com', '2025-11-21', '9405530109355273508033', ''),
(14754, 'T79735', 11540, 999999999, 0, '510-London', '2026-01-08', '2025-11-30', '2025-05-30', 'gold', 'white', 'Pionier', 'The decorative pieces on the face fell off after the watch was dropped . Please repair accordingly. Thank you! ', 'waiting for payment 70€ ,, all done, new dial new m ovement, new caseback, cleaned hands, cleaned case, demag case, 1.26s', '0', '2026-03-14', '2026-03-14', 1, 1, 1, 1, 0, 0, 1, 1, '2026-01-09 15:10:28', 1, '2026-01-09 15:10:28', 1, '2026-03-18 11:21:03', 1, 1, '2026-03-23', '47.148.140.108', '47-148-140-108.fdr01.ontr.ca.ip.frontiernet.net', '2025-11-30', '9405530109355333788498', ''),
(14770, 'T81462', 11790, 999999999, 0, 'GM 901-3', '2025-12-12', '2025-12-12', '2025-09-29', 'gold', 'gold', 'Theorema', 'Uhr läuft nur 20 Stunden, obwohl voll aufgezogen\nDualtime nicht einstellbar', 'test start: 15.12.25 11:20\nstopped at : 18:01 17.12.25 -> 55 hours\nnew wind: 18.12.25 12:55\n\nall OK, contacted client, will send it back', '0', '2026-01-26', '2026-01-26', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-01-26', '80.130.222.215', 'p5082ded7.dip0.t-ipconnect.de', '2025-12-12', '485657219396', ''),
(14756, 'T76711', 11776, 999999999, 0, '116-San Francisco', '2025-12-18', '2025-12-09', '2025-01-01', 'gold', 'white', 'Theorema', 'A month after I received the watch from the repair process, it is stuck fully wound.', 'has been dropped, escapement jammed, lubricated balance cock inca bloc and barrel, demag , rate 0.71s , new movement holder screws, works flawless again. If it comes back it was misused !!', '0', '2026-01-26', '2026-01-26', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-18 14:56:01', 1, '2025-12-18 14:56:01', 1, '2026-01-26 14:58:32', 1, 1, '2026-02-02', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-09', '9405530109355280378667', ''),
(14757, 't82012', 11777, 999999999, 0, '108-Oman', '2026-01-08', '2025-12-09', '2025-10-17', 'gold', 'gold', 'Theorema', 'The crown is spinning. Does not wind up or set time', 'new crown stem', '0', '2026-03-14', '2026-03-14', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 1, '2026-01-08 13:42:53', 1, '2026-03-18 11:21:24', 1, 1, '2026-03-23', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-09', '9405530109355334243279', ''),
(14758, 'T80834', 11778, 999999999, 0, '118-Venezia', '2026-01-20', '2025-12-09', '2025-08-20', 'gold', 'gold', 'Theorema', 'The winding mechanism doesn\'t work.', 'new crown stem, demag , new movement', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-27 05:01:47', 0, NULL, 1, '2026-03-22 15:04:45', 1, 1, '2026-03-26', '50.47.113.169', '50-47-113-169.evrt.wa.ptr.ziplyfiber.com', '2025-12-09', '9410830109355008876096', ''),
(14759, 'T82950', 11779, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-09', '2025-12-05', 'black', 'black', 'Theorema', 'The watch has a big face. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.41.95.90', 'pool-108-41-95-90.nycmny.fios.verizon.net', '2025-12-09', '--', NULL),
(14760, 'T82921', 11780, 999999999, 0, '3001-Paragon', '1970-01-01', '2025-12-10', '2025-12-03', 'bicolor rosé', 'silvgrey', 'Theorema', 'No defect; not as expected as it relates to appearance and weight; a bit too heavy and bulky and or encanbersome. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '50.53.116.113', 'static-50-53-116-113.bvtn.or.ptr.ziplyfiber.com', '2025-12-10', '--', NULL),
(14761, 'T82287', 11781, 999999999, 0, '123-Madame Butterfly', '1970-01-01', '2025-12-10', '2025-11-11', 'silver', 'white', 'Theorema', 'The clasp keeps coming undone when I am using my wrist such as when I go to hold an item or when my forearm muscle flexes in any way.The last time it slipped off my wrist it fell onto concrete and the small pin was dislodged. I did get the pin back in however the clasp constantly flipped open. I initially wore the watch as a loose hug around my wrist, still a small amount of play but because I have a very small wrist the band doubled up on itself until the end butted against the watch face. I started wearing it more losely and the clasp stayed closed longer, however it still came undone but not as often. Can the band be shorter ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '1.146.77.197', '1.146.77.197', '2025-12-10', '--', NULL),
(14762, '#T82615', 11782, 999999999, 0, '114-Buenos Aires', '1970-01-01', '2025-12-10', '2025-11-28', 'black', 'gold', 'Theorema', 'Jag beställde tre klockor för att kunna välja en av dem, men eftersom en klocka saknades i leveransen och jag endast fick två, har jag nu beslutat att behålla en av de två klockor jag fått och skicka tillbaka den andra.\n\nIch habe drei Uhren bestellt, um eine davon auswählen zu können, aber da eine Uhr in der Lieferung fehlte und ich nur zwei erhalten habe, habe ich nun beschlossen, eine der beiden erhaltenen Uhren zu behalten und die andere zurückzusenden.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, '2026-10-12 00:00:00', 0, 0, '1970-01-01', '77.218.229.60', 'm77-218-229-60.cust.tele2.se', '2025-12-10', '--', ''),
(14763, '', 11783, 999999999, 0, '120-Lady Butterfly', '2026-01-08', '2025-12-10', '2025-11-11', 'silver', 'white', 'Theorema', 'The catch securing the silver bank keeps coming open. I wear the watch lightly hugging my wrist but when I move my hand/forearm the clasp opens and the watch band slips off. I have attempted to keep the band loose and whilst it improves how often the clasp opens it only reduces the number of times and frequency. The last time it slipped off and landed on cement and the pin popped out.I put it back together, noting a slight deformity of the clasp, however the problem has become so frequent that I cannot wear the watch. I have a very small wrist the excess silver band tucks up under the bank and butts up against the watch face (underneath). ', 'all OK, new band', '0', '2026-03-19', '2026-03-19', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-08 14:10:32', 0, NULL, 0, NULL, 1, 1, '2026-03-20', '101.160.32.210', 'cpe-101-160-32-210.bpjl-r-036.lon.vic.bigpond.net.au', '2025-12-10', '1Z8VF459D962032525', ''),
(14764, 'T77653', 11784, 999999999, 0, '505-Florida', '2026-01-08', '2025-12-10', '2025-02-02', 'black', 'black', 'Pionier', 'It is randomly losing time, like hours worth even when worn and wound. This is my husband’s favorite watch, please help!', 'test start 3.3.26 16:20\ntest end 20.03.26 client is rifght\n\nnew movement, new minute and hour hand, cleaned dial, rate  11.67s , 0.13ms, 278.9°', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-09 15:12:02', 1, '2026-01-09 15:12:02', 1, '2026-03-22 15:05:01', 1, 1, '2026-03-26', '107.115.163.86', '107.115.163.86', '2025-12-10', '9405530109355305998221', ''),
(14765, 'T82566', 11785, 999999999, 0, '505-Florida', '1970-01-01', '2025-12-11', '2027-11-28', 'black', 'blue', 'Pionier', 'returning due to cost', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '76.23.129.67', 'c-76-23-129-67.hsd1.nh.comcast.net', '2025-12-11', '--', NULL),
(14766, 'T82589', 11786, 999999999, 0, 'GM 132-4', '2025-12-11', '2025-12-11', '2025-11-25', 'gold', 'black', 'Theorema', 'I want to return the new and unused watch, please refund the purchase price. ', '--', '0', '1970-01-01', '2025-12-11', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '80.130.222.215', 'p5082ded7.dip0.t-ipconnect.de', '2025-12-11', '--', ''),
(14767, 'T82935', 11787, 999999999, 0, '514-Hawaii', '2025-12-17', '2025-12-11', '2025-12-06', 'gold', 'black', 'Pionier', 'The watch is brand new and unworn, i find thze dial too large. I\'D LIKE TO EXHANGE IT FOR A FLORIDA GM-505-1', '--', '0', '1970-01-01', '2025-12-18', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '84.196.49.68', 'd54C43144.access.telenet.be', '2025-12-11', '--', ''),
(14768, 'T 82806', 11788, 999999999, 0, '7002-Chicago', '1970-01-01', '2025-12-11', '2025-12-01', 'gold', 'white', 'Pionier', 'case too large and not to my liking ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.185.70.218', 'c-73-185-70-218.hsd1.ca.comcast.net', '2025-12-11', '--', NULL),
(14769, 'T83014', 11789, 999999999, 0, '501-Copernicus', '1970-01-01', '2025-12-12', '2025-12-12', 'black', 'gold', 'Pionier', 'No defect my husband did not like the clasp', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.223.7.217', '71-223-7-217.phnx.qwest.net', '2025-12-12', '--', NULL),
(14771, 'T74959', 11791, 999999999, 0, '121-St Petersburg', '2026-01-08', '2025-12-13', '2024-11-27', 'gold', 'black', 'Theorema', 'Watch does not keep time. After winding watch the watch does not keep time for more than a short period of time, less than a couple of hours.', 'new movement, cleaned hands and dial, new caseback gasket, new caseback screws, demag case', '0', '2026-03-14', '2026-03-14', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-09 15:11:05', 1, '2026-01-09 15:11:05', 1, '2026-03-18 11:21:47', 1, 1, '2026-03-23', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-13', '9405530109355334261365', ''),
(14772, 'T82997', 11792, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-13', '2025-12-03', 'blue', 'white', 'Theorema', 'N/A', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '66.229.185.230', '66.229.185.230', '2025-12-13', '--', NULL),
(14773, 'T67031', 11793, 999999999, 0, '101-Casablanca GM', '2026-01-08', '2025-12-13', '2023-12-18', 'silver', 'blue', 'Theorema', 'The winding mechanism no longer cranks the watch, it spins loosely in place so no longer puts momentum into the watch', 'fixed manual winding, new stem and crown , new case for free, dmeag movement and adjsuted to 8.16s, fixed hands', '0', '2026-02-18', '2026-02-18', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-08 14:17:59', 0, NULL, 0, NULL, 1, 1, '2026-02-19', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-13', '1Z8VF459D962157696', ''),
(14774, 'T81795', 11794, 999999999, 0, '116-San Francisco', '1970-01-01', '2025-12-13', '2025-10-11', 'gold', 'gold', 'Theorema', 'ANTONIO DO NOT SEND THIS WATCH TO THE CUSTOMER. HE IS GETTING A REPLACEMENT. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2025-12-22 19:58:02', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-13', '--', ''),
(14775, 'T82912', 11795, 999999999, 0, '3011-Macau', '1970-01-01', '2025-12-13', '2025-11-30', 'gold', 'black', 'Theorema', ' When i got the package i inpescted the watch and i noticed that the face of the watch was unprotected and did\'nt come with the protective film and i noticed that it came with some scratches and pinholes. In the package it did\'nt come with the warramty card for the watch.                    ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '99.96.181.40', '99.96.181.40', '2025-12-13', '--', NULL),
(14776, 'T83213', 11796, 999999999, 0, '116-San Francisco', '1970-01-01', '2025-12-15', '1970-01-01', 'gold', 'gold', 'Theorema', 'The face was too big for my wrist. And the whole watch was too big.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.191.111.123', 'ool-18bf6f7b.dyn.optonline.net', '2025-12-15', '--', NULL),
(14777, 'T83234', 11797, 999999999, 0, '508-Dublin', '1970-01-01', '2025-12-15', '2025-12-12', 'black', '', 'Pionier', 'I ordered the wrong watch. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '100.14.202.238', 'pool-100-14-202-238.phlapa.fios.verizon.net', '2025-12-15', '--', NULL),
(14778, '', 11798, 999999999, 0, 'GM3006-3', '2025-12-15', '2025-12-15', '2017-07-17', 'black', 'gold', 'Theorema', 'inside watch 3 rings are brocken down and blocked the arrow of watch.\nJust remove the rings inside it.', 'waiting for answer 70€ for repair  or only to take the rings out,, all done, new hands new dial new mvt, new case for free and glass, cleaned crown and stem, fresh lub and adhesive, new gasket caseback and gasket grease, greased buttons , demag, all perfect, 3.52s, ', '0', '2026-01-26', '2026-01-26', 1, 1, 1, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-01-26', '80.130.222.215', 'p5082ded7.dip0.t-ipconnect.de', '2025-12-15', '00340434129949135335', ''),
(14779, 'T82951', 11799, 999999999, 0, '103-Sao Paulo', '1970-01-01', '2025-12-15', '2025-12-01', 'gold', 'white', 'Theorema', 'The size of this watch is too big.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.195.36.52', '71.195.36.52', '2025-12-15', '--', NULL),
(14780, 'T80413 ', 11800, 999999999, 0, 'Choose option', '2026-01-08', '2025-12-15', '2025-09-10', 'Choose option', 'Choose option', 'Choose option', '. The calendar jumps from 4 to 15. Please replace/ repair accordingly.', 'fixed date mechanism, clients fault, cleaned dial and hands, demag case and mvt, adjusted to 4.67s', '0', '2026-03-14', '2026-03-14', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-08 13:53:57', 0, NULL, 1, '2026-03-18 11:20:22', 1, 1, '2026-03-23', '4.35.39.234', '4.35.39.234', '2025-12-15', '9410830109355008818324', ''),
(14781, 'T83246 ', 11801, 999999999, 0, '107-Rio', '1970-01-01', '2025-12-16', '2025-10-12', 'black', 'silvgrey', 'Theorema', 'No defect.  Just did not like the watch.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.247.218.43', 'c-73-247-218-43.hsd1.il.comcast.net', '2025-12-16', '--', NULL),
(14782, 'My Order number is T80627. ', 11802, 999999999, 0, '4004-Newton', '2026-01-20', '2025-12-16', '2025-04-08', 'gold', 'black', 'Theorema', 'My Order number is T80627. The watch stops even when manually wound and then stored inside the winder. It is wound 40 turns, is shaken for good measure and does not last thru the night whether it is in a watch winder or not. Please repair accordingly.\n\nAlso please return original warranty card and original storage box as I always use the box when it is not in the winder.  \nThank you!', 'tested 1 week, all pefect, will send it back.', '0', '2026-02-18', '2026-02-18', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-27 05:46:44', 0, NULL, 1, '2026-02-24 09:07:46', 1, 1, '2026-02-26', '65.175.152.49', 'd-65-175-152-49.nh.cpe.atlanticbb.net', '2025-12-16', '9405530109355292555636', ''),
(14783, '#T82150', 11803, 999999999, 0, '118-Sahara', '2026-02-19', '2025-12-16', '2025-11-03', 'silver', 'gold', 'Theorema', 'I bought a watch from Tel, but the watch has a defect, sometimes it is ahead or sometimes it stops when it is on the wrist. I ask if you can\'t figure it out. Please send me my money back. I have bought three watches from Tel before, why didn\'t I have such a problem then, that is, the watch model is bad. The options are to exchange the watch for a model that I could choose myself or my money back.\n\nBest regards Namiq Taha Fatah', 'will send brand new watch. i hgope no issues this time. ', '0', '2026-03-18', '2026-03-18', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-03-20', '87.100.156.77', '87-100-156-77.bb.dnainternet.fi', '2025-12-16', '485657229000', 'This guy is totally crazy, he keeps inventing problems with his watch. Can the watch be put on the timegrapher so we can show to him that it is working perfectly? '),
(14784, '', 11804, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-16', '2025-11-01', 'silver', '', 'Theorema', 'Minute hand fell off and hour hand coming away from movement ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.194.246.130', 'c-71-194-246-130.hsd1.il.comcast.net', '2025-12-16', '--', NULL),
(14785, '', 11805, 999999999, 0, '108-Oman', '1970-01-01', '2025-12-16', '1970-01-01', 'gold', 'gold', 'Theorema', 'watch doesn\'t function unless tapped or turned upside down', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '152.130.14.6', '152-130-14-6.tic.va.gov', '2025-12-16', '--', NULL),
(14786, 'T82483', 11806, 999999999, 0, '114-Buenos Aires', '1970-01-01', '2025-12-17', '2025-11-19', 'gold', 'gold', 'Theorema', 'When going to adjust the time the crown came out and we are now unable to adjust the time.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '32.221.192.69', '32-221-192-69.bng02.wtrb.ct.ip.frontiernet.net', '2025-12-17', '--', NULL),
(14787, 'T82909', 11807, 999999999, 0, '511-New York', '1970-01-01', '2025-12-17', '2025-12-01', 'rosé', 'blue', 'Pionier', 'The crown of the watch came off when making efforts to wind the time ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '69.125.117.8', 'ool-457d7508.dyn.optonline.net', '2025-12-17', '--', NULL),
(14788, 'T79850', 11808, 999999999, 0, '101-Casablanca GM', '2026-01-16', '2025-12-17', '1970-01-01', 'silver', 'white', 'Theorema', 'My order number is T79850. The watch has stopped working suddenly. Please replace/ repair accordingly.', 'test start 26.01.26 14:26\ntest end: 24.02.26 15:47 not OK. \nfixed manual winding, all OK now, demag case and mvt, ', '0', '2026-03-14', '2026-03-14', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-07 01:27:28', 0, NULL, 1, '2026-03-18 11:22:02', 1, 1, '2026-03-23', '184.83.33.214', '184-83-33-214-dynamic.midco.net', '2025-12-17', '9405530109355333785480', ''),
(14789, 'T83096', 11809, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-18', '1970-01-01', 'silver', 'yellow', 'Theorema', 'None ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.198.181.120', 'c-73-198-181-120.hsd1.nj.comcast.net', '2025-12-18', '--', NULL),
(14790, 'T83018', 11810, 999999999, 0, 'other', '1970-01-01', '2025-12-19', '2025-12-04', 'black', 'black', 'other', 'Order number: T83018\nReason for return: changed mind/no longer want\n\nItem is unused and unworn with all protective stickers.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, '2025-12-19 00:00:00', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '146.75.154.0', '146.75.154.0', '2025-12-19', '--', ''),
(14791, 'T81365', 11811, 999999999, 0, '515-Amsterdam', '2026-01-16', '2025-12-19', '1970-01-01', 'gold', 'blue', 'Pionier', 'My order number is T81511. The crystal shattered. The watch is running fine and all the other functions seem to be OK. ', 'waiting for payment 155€ ,, all done, new case, movement, hands and dial, all perfect,  6.63s', '0', '2026-03-14', '2026-03-14', 1, 1, 1, 1, 0, 0, 1, 1, '2026-01-07 02:07:41', 0, NULL, 1, '2026-03-18 11:18:56', 1, 1, '2026-03-23', '66.26.126.55', 'syn-066-026-126-055.res.spectrum.com', '2025-12-19', '9405530109355334265547', 'The correct order number is T81511'),
(14792, 'T82759', 11812, 999999999, 0, '505-Florida', '1970-01-01', '2025-12-19', '2025-11-28', 'silver', 'silvgrey', 'Pionier', 'No defects. Just returning. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.178.156.222', 'ip98-178-156-222.ok.ok.cox.net', '2025-12-19', '--', NULL),
(14793, 'T83243 ', 11813, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-20', '2025-12-20', 'silver', 'yellow', 'Theorema', 'Returning due to dial size too big. Not what I want right now', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.8.11.167', 'c-24-8-11-167.hsd1.co.comcast.net', '2025-12-20', '--', NULL),
(14794, 'T00000', 11814, 999999999, 0, '502-Malibu', '2025-12-21', '2025-12-21', '2025-12-01', 'bicolor gold', 'gold', 'Pionier', 'test---- IGNOREvasdzxvsdgsddfaskhjfvdsascxvasda', '--asdasdasdqawasdsa', '0', '2025-12-21', '2025-12-21', 1, 1, 1, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '109.236.40.241', 'dynamic.pool-109-236-40-241.abissnet.al', '2025-12-21', '--', 'fsdfasdasdasdascxscvcx'),
(14795, 'T82967', 11815, 999999999, 0, '118-Venezia', '2026-01-08', '2025-12-22', '2025-12-01', 'silver', '', 'Theorema', 'It gains 2 hours in 24 hours. It is always going fast. Replace repair accordingly. Thank you!\nHe also wants to change the mesh band with a leather band. he is ready to pay. Thank you', 'new movement, fixed hands and dial, new movement holder ring, cleaned glass, fresh lub crown stem, ', '0', '2026-03-17', '2026-03-17', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-08 14:50:08', 0, NULL, 1, '2026-03-18 11:18:24', 1, 1, '2026-03-23', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-22', '9405530109355334247031', 'He also wants to change the mesh band to a leather ban  '),
(14796, 'T83233', 11816, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-22', '1970-01-01', 'silver', 'white', 'Theorema', 'The crown lock that covers the dial will not close. The dial itself clicks when you turn it. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '70.183.127.205', 'wsip-70-183-127-205.no.no.cox.net', '2025-12-22', '--', NULL),
(14797, 'T83131', 11817, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-24', '2025-12-06', 'silver', 'black', 'Theorema', 'unfortunately, the face of the watch was too big on the wrist of the person i wanted to gift it to ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.126.144.128', 'c-24-126-144-128.hsd1.ga.comcast.net', '2025-12-24', '--', NULL),
(14798, '#T56979', 11818, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-25', '2026-01-09', 'silver', 'yellow', 'Theorema', 'Nachdem die Uhr über einem Monat lang stillstand, habe ich sie heute wieder aufgezogen. Tickt sie zwar, aber die Zeiger bewegen sich nicht. Also kann ich mir keine Uhrzeit anzeigen lassen.\n\nIch hoffe auf eine Möglichkeit, die Uhr bei Ihnen einschicken zu können, um diese zu reparieren\n\nMit freundlichen Grüßen\nBen Thiemann', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.226.108.56', 'a172-226-108-56.deploy.static.akamaitechnologies.com', '2025-12-25', '--', NULL),
(14799, 'T83229', 11819, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2025-12-26', '1970-01-01', 'gold', 'black', 'Theorema', 'My order number is T83229. I ordered the wrong watch. The watch is brand new and never worn. Please exchange with Casablanca GM-101.4 Silver', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.98.210.136', '98.98.210.136', '2025-12-26', '--', NULL),
(14800, '', 11820, 999999999, 0, '', '1970-01-01', '2025-12-26', '1970-01-01', '', '', '', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '52.25.99.106', 'ec2-52-25-99-106.us-west-2.compute.amazonaws.com', '2025-12-26', '--', NULL),
(14801, 'GM505-10', 11821, 999999999, 0, '505-Florida', '1970-01-01', '2025-12-26', '2025-12-12', 'gold', 'blue', 'Pionier', 'The calendar has to be set manually will not change on it\'s own and the date will not change as well.  The watch does not keep time. Watch needs to be serviced  Thank You!', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '173.170.196.102', 'syn-173-170-196-102.res.spectrum.com', '2025-12-26', '--', NULL),
(14802, 'T67234', 11822, 999999999, 0, '106-Toronto GM', '2026-01-16', '2025-12-27', '2023-12-18', 'gold', 'gold', 'Theorema', 'fallen hands but before the hands fell it had stopped working', 'new movement, cleaned hands, new caseback screws, 1.33s , fixed dial number 5', '0', '2026-03-14', '2026-03-14', 1, 1, 0, 1, 0, 0, 1, 1, '2025-12-27 05:41:06', 0, NULL, 0, NULL, 1, 1, '2026-03-18', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2025-12-27', '1Z8VF459DA63578055', ''),
(14803, 'T78850', 11823, 999999999, 0, '107-Rio', '2026-03-04', '2025-12-27', '2025-04-01', 'gold', 'silvgrey', 'Theorema', 'My order number is T78850. The watch ticks only every few minutes or so. Please repair accordingly', 'test start: 26.01.26 14:20\n\n-> not ok. new movement , cleaned dial, cleaned hands, flawless now. 0.45s ', '0', '2026-03-14', '2026-03-14', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-07 01:39:32', 0, NULL, 1, '2026-03-18 11:20:32', 1, 1, '2026-03-23', '104.28.78.115', '104.28.78.115', '2025-12-27', '9410830109355008818249', ''),
(14804, 'T83466', 11824, 999999999, 0, '110-Oslo', '1970-01-01', '2025-12-29', '2025-12-19', 'gold', 'blue', 'Theorema', 'My order number is T83466- The watches are brand new and unworn.. Please Refund.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '94.31.68.235', '94.31.68.235', '2025-12-29', '--', NULL),
(14805, 'T83466', 11824, 999999999, 0, '117-Kingston', '1970-01-01', '2025-12-29', '2025-12-19', 'gold', 'blue', 'Theorema', 'My Order Number is T83466. The watches are Brand new and Unworn, please Refund me to the original payment Method.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '94.31.68.235', '94.31.68.235', '2025-12-29', '--', NULL),
(14806, 'T83466', 11824, 999999999, 0, '127-Vienna', '2026-01-05', '2025-12-29', '2025-12-19', 'gold', 'blue', 'Theorema', 'My order number is T83466- The watches are brand new and unworn.. Please Refund me the Money to my original Payment method.', '--', '0', '1970-01-01', '2026-01-05', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '94.31.68.235', '94.31.68.235', '2025-12-29', '--', ''),
(14807, 'T82817', 11825, 999999999, 0, '505-Florida', '2026-02-10', '2025-12-29', '2025-12-04', 'silver', 'blue', 'Pionier', 'Once the watch has been wound and gently shaken, as advised in a previous video, the watch is not keeping time appropriately. Even after a few hours it can be more than 15 minutes behind the actual time. For example I have worn the watch all day and it\'s more than 15 minutes behind. I need to adjust the watch several times a day to keep it in line with the time on my phone. Thus defeating the object of the watch which is to tell the actual time. I enjoy wearing the watch, as it looks good and people have commented on it. But as it is not keeping time, I will send it back to have it checked.\n\n\n', 'test start 20.04.26 15:55\ntest end 05.05.26 11:30\n\nnew movement, cleaned hands, cleaned dial, new stem and crown, demag case', '0', '1970-01-01', '1970-01-01', 1, 1, 0, 0, 0, 0, 0, 1, '2026-01-18 02:52:53', 1, '2026-02-02 00:36:31', 0, NULL, 1, 0, '1970-01-01', '62.64.186.3', '62.64.186.3', '2025-12-29', '--', 'Any chance to send me a picture of the watch on the timegrapher if it is working fine before sending it back? Thank you'),
(14808, 'T83109', 11826, 999999999, 0, '121-St Petersburg', '1970-01-01', '2025-12-29', '2025-12-15', 'black', 'gold', 'Theorema', 'No defects. I did not like the watch once it arrived and I was able to see it in person.\n\nI would like to replace this St. Petersburg Theorema | Orange | GM-121-11 for a different watch.\n\nPlease send me the Automatic Florida Diamonds by Pionier Germany GM-505-9 | Silver | https://tufinawatches.com/products/florida-diamonds-pionier-gm-505-9?variant=45464229544099\n\nThis replacement watch is the same prices as the one I am returning.\n\nThank you!\n\nMauricio Hinojosa\nm2.hinojosa@outlook.com', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.212.90.169', '108-212-90-169.lightspeed.tukrga.sbcglobal.net', '2025-12-29', '--', NULL),
(14809, 'c20458458972323.1 paypal invoice number', 11827, 999999999, 0, '112-Madrid', '2026-02-12', '2025-12-30', '2021-05-17', 'gold', 'black', 'Theorema', 'The watch is outside of warranty. It\'s stopped working and the marker is loose. The winder also has issues. Please repair accordingly. Thank you for your time', 'waiting for payment 80€ ,, all done', '0', '2026-05-05', '2026-05-05', 1, 1, 1, 1, 0, 0, 1, 1, '2026-01-23 01:56:14', 1, '2026-02-02 00:37:26', 0, NULL, 1, 1, '2026-05-05', '86.191.222.78', 'host86-191-222-78.range86-191.btcentralplus.com', '2025-12-30', '1Z8VF459DA62095382', ''),
(14810, 'T75589', 11828, 999999999, 0, '101-Casablanca GM', '2026-01-20', '2025-12-30', '2025-12-30', 'silver', 'white', 'Theorema', 'Watch has stopped keeping time. Time hands have stopped moving.', 'fixed escapement, tighte4ned all screws, demag adjusted rate to 7.69 . 0.27ms', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-12 21:51:56', 0, NULL, 1, '2026-03-22 15:03:58', 1, 1, '2026-03-26', '172.59.188.11', '172.59.188.11', '2025-12-30', '9405530109355351331034', ''),
(14811, '', 11829, 999999999, 0, '509-Barbados', '2026-01-08', '2025-12-30', '1970-01-01', 'silver', 'black', 'Pionier', 'The watch is not under warranty anymore. \nIt needs general service and the band needs. \nI no longer have the invoice or the warranty card;\n I must have lost everything during the move.\nAdjusting the settings is difficult; the button \nat 10 o\'clock is very unreliable, and the others are too. \nDoes the strap need to be replaced, or is it enough \nto refurbish it and adjust it ? ', 'waiting for payment, 150 / 190 €, all done, flawless now', '0', '2026-01-26', '2026-01-26', 1, 1, 1, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-01-27', '217.171.61.50', '50.217-171-61.tkchopin.pl', '2025-12-30', '414163180689', ''),
(14812, '#T83703', 11830, 999999999, 0, '515-Amsterdam', '1970-01-01', '2025-12-30', '2025-12-25', 'gold', 'blue', 'Pionier', 'Decorative pattern fallen off', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '81.152.158.24', 'host81-152-158-24.range81-152.btcentralplus.com', '2025-12-30', '--', NULL),
(14813, '', 11831, 999999999, 0, 'Choose option', '1970-01-01', '2026-01-01', '2025-12-03', 'Choose option', 'Choose option', 'Choose option', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.206.89.165', 'c-98-206-89-165.hsd1.il.comcast.net', '2026-01-01', '--', NULL),
(14814, 'T82952', 11831, 999999999, 0, '114-Buenos Aires', '1970-01-01', '2026-01-01', '2025-12-03', 'black', 'gold', 'Theorema', 'Watch won’t stay wound. Will stop after 30 minutes and not work longer than 6 to 8. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.206.89.165', 'c-98-206-89-165.hsd1.il.comcast.net', '2026-01-01', '--', NULL),
(14815, '', 11832, 999999999, 0, '506-Miami', '2026-02-12', '2026-01-03', '1970-01-01', 'gold', 'gold', 'Pionier', 'The watch is out of warranty- The watch has stopped working, i also would like a replacement band. Please repair accordingly.\n\n', 'waiting for payment 150€, new movement, dial and hands, demag and cleaned case, 10.83s, 0.24ms, 290.1° , new gasket caseback', '0', '1970-01-01', '1970-01-01', 1, 1, 1, 0, 0, 0, 0, 1, '2026-01-18 02:11:46', 1, '2026-02-02 00:36:05', 0, NULL, 1, 0, '1970-01-01', '86.158.252.194', 'host86-158-252-194.range86-158.btcentralplus.com', '2026-01-03', '--', ''),
(14816, 'T83585', 11833, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-03', '2025-12-29', 'silver', 'white', 'Theorema', 'GM122-3 (pulldown above does nit give right options!)\n\n\nThe watch is brand new and unworn.. Please refund\nThank you.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.28.130.6', '104.28.130.6', '2026-01-03', '--', NULL),
(14817, 'T82582', 11834, 999999999, 0, 'Choose option', '1970-01-01', '2026-01-06', '1970-01-01', 'Choose option', 'Choose option', 'Choose option', 'The watch stop working ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-06 00:00:00', 0, '2026-01-06 00:00:00', 0, NULL, 0, 0, '1970-01-01', '73.156.104.190', 'c-73-156-104-190.hsd1.fl.comcast.net', '2026-01-06', '--', ''),
(14818, 'T82406', 11835, 999999999, 0, '101-Casablanca GM', '2026-02-10', '2026-01-06', '2025-07-01', 'black', 'white', 'Theorema', 'My order number is T82406 The watch doesn\'t wind anymore. Please replace/ repair accordingly.', 'fixed ratchet wheel, demag case and mvt, tightened all screws, rate 4.61', '0', '2026-04-17', '2026-04-17', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-18 03:00:11', 1, '2026-02-02 00:36:44', 1, '2026-04-19 14:59:06', 1, 1, '2026-04-25', '24.198.166.127', 'syn-024-198-166-127.res.spectrum.com', '2026-01-06', '9405530109355371187307', ''),
(14819, 'T82582', 11836, 999999999, 0, 'Choose option', '1970-01-01', '2026-01-07', '1970-01-01', 'Choose option', 'Choose option', 'Choose option', 'The watch stop working ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '50.145.130.30', '50.145.130.30', '2026-01-07', '--', NULL),
(14820, '', 11837, 999999999, 0, '7001-Havana', '1970-01-01', '2026-01-07', '2025-12-22', 'black', 'gold', 'Pionier', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.57.51.44', 'c-98-57-51-44.hsd1.tx.comcast.net', '2026-01-07', '--', NULL),
(14821, 'T82664', 11838, 999999999, 0, '101-Casablanca GM', '2026-01-16', '2026-01-07', '2025-11-28', 'silver', 'yellow', 'Theorema', 'My order number is T82664. There is condensation inside the watch without being exposed to water. Please repair', 'set hands again, cleaned them, cleaned dial, fresh crown stem lub, cleaned glassm demag case and mvt, accuracy perfect, -1.29 . 0.08ms, 274 , no conedensation, did all testes. there was never smth', '0', '2026-03-13', '2026-03-13', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '88.164.58.224', '88-164-58-224.subs.proxad.net', '2026-01-07', '--', ''),
(14822, 'T78113', 11839, 999999999, 0, '3005-Marco Polo', '2026-01-20', '2026-01-07', '2025-03-25', 'gold', 'black', 'Theorema', 'Dear Tufina Customer Services,\n\nLast March 3, 2025, I ordered a Teorema Marco Polo GM3005-7, which seems very unique design and great. But, The watch did not run right after Christmas day. For several days I wore the watch to wind up, but the second hand does not move. I have contacted your Tufina Care Team. According your instructions, I also carelly winded up a couple of times. However, it stopped and does not move at all. \n\nSincerely,\nHokwon Cho', 'new movementz, new dial, cleaned hands, cleaned case and glass, demag case , ratre 8.63s , 0.01ms , 260.9°', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-13 07:42:00', 1, '2026-01-13 07:42:04', 1, '2026-03-22 15:04:14', 1, 1, '2026-03-26', '70.175.36.13', 'ip70-175-36-13.lv.lv.cox.net', '2026-01-07', '9405530109355351316208', ''),
(14823, 'T82473', 11840, 999999999, 0, '123-Madame Butterfly', '1970-01-01', '2026-01-07', '1970-01-01', 'silver', 'white', 'Theorema', 'The watch was described as a \"ladies watch\".  However, we determined upon receipt that it was equal to most men\'s watches, and simply too heavy for my wife.  The issue was not the band ... the issue was the weight and thickness of the actual watch.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.91.180.143', 'syn-071-091-180-143.res.spectrum.com', '2026-01-07', '--', NULL),
(14824, '', 11841, 999999999, 0, '3001-Paragon', '2026-01-12', '2026-01-08', '2014-11-25', 'gold', 'white', 'Theorema', 'Bei meiner Uhr (Theorema Paragon) dreht sich der Uhrzeiger nicht mehr.\nReferenz der Uhr ist: T3001 von 25-11-2014.', 'waiting for payment 100 / 130€', '0', '2026-03-11', '1970-01-01', 0, 0, 1, 0, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-03-11', '24.132.4.124', 'j4124.upc-j.chello.nl', '2026-01-08', '485657227453', 'Austausch gegen neue Uhr GM122-5'),
(14825, 'T82909 ', 11842, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-08', '1970-01-01', 'black', '', 'Theorema', 'Does not wind/work', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '67.20.7.228', 'host-67.20.7.228.cspirefiber.net', '2026-01-08', '--', NULL),
(14826, 'T83108', 11843, 999999999, 0, '506-Miami', '1970-01-01', '2026-01-08', '2025-12-20', 'black', 'black', 'Pionier', 'No defect , too big ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '174.224.222.85', '85.sub-174-224-222.myvzw.com', '2026-01-08', '--', NULL),
(14827, 'T77309', 11844, 999999999, 0, '505-Florida', '2026-02-12', '2026-01-08', '2025-01-27', 'silver', 'black', 'Pionier', 'GM 505-5.    \nThe calendar and the month sub dial don\'t work correctly. the Time doesn\'t set smoothly. \n\nMore specific details - when pushing the date button - it will skip from the 4th straight to the 15th. In addition, if on the 17 (use to be the 7th) the dates no longer adjust. The waiting period for the date button use to return is about 24 hrs. smooth time - gear grinding.\n\nSince inquiring about how to activate the warranty, the locking clip on the wrist band fell off due - I was only left with a partial pressure pin (pin had lost one side of the springe dowel) in the band.\n\nPlease replace/repaid accordingly.\n', 'new clasp, new movement, new hands, cleaned dial, demag case,  6.92s , 0.06ms , 301.5°', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-18 02:18:24', 1, '2026-02-02 00:35:52', 1, '2026-05-05 18:52:20', 1, 0, '1970-01-01', '205.193.239.44', '205.193.239.44', '2026-01-08', '--', ''),
(14829, 'T82391', 11846, 999999999, 0, '108-Oman', '1970-01-01', '2026-01-09', '1970-01-01', 'gold', 'gold', 'Theorema', 'La montre, est entièrement remonter mais elle perd de temps, on dirait qu’elle est bloquée quelque part. Merci de le faire réparer au remplacer.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-09 20:15:32', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '31.10.145.200', '31-10-145-200.cgn.dynamic.upc.ch', '2026-01-09', '--', ''),
(14828, 'T81784', 11845, 999999999, 0, '116-San Francisco', '1970-01-01', '2026-01-09', '2025-10-13', 'gold', 'white', 'Theorema', ' I bought a watch for my husband on Oct 13, 2025 and I was saving it since then to give it as a Christmas gift for him and I just have it to him and he found out that it is not working at all . I know it is under warranty for 24 months since purchase date but I need to know how to return it for refund or how to exchange it with another watch . Please advise. Thank you', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, '2026-01-09 17:25:06', 0, '2026-01-09 17:25:52', 0, NULL, 0, 0, '1970-01-01', '50.100.191.108', 'bras-base-stckon0807w-grc-41-50-100-191-108.dsl.bell.ca', '2026-01-09', '--', ''),
(14830, 'T71867', 11847, 999999999, 0, '101-Casablanca GM', '2026-01-19', '2026-01-09', '2024-07-30', 'black', 'black', 'Theorema', 'Der Minutenzeiger ist während dem tragen meiner Uhr heruntergerutscht.', 'new dial, fixed balance wheel, fixed hands, demag case and mvt, new caseback vgasket ,  8s', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-03-23', '83.215.82.251', '83-215-82-251.dyn.cablelink.at', '2026-01-09', '1Z8VF459DL62446643', ''),
(14831, 'T74205', 11848, 999999999, 0, '132-Portofino', '2026-02-24', '2026-01-10', '2024-11-04', 'gold', 'gold', 'Theorema', 'Problem description:\nThe Theorema watch is not working properly. The winding button (crown), which must be used every 24 hours to keep the watch running, does not function correctly. Despite winding the watch, it stops and does not continue working.', 'new movement, cleaned dial and hands, demag case, rate 2.95 , 0.02ms , 308°', '0', '2026-03-22', '2026-03-22', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-03-23', '176.128.235.143', 'res34-h01-176-128-235-143.dsl.sta.abo.bbox.fr', '2026-01-10', '1Z8VF459D963463620', ''),
(14832, 'T82582', 11834, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-10', '2025-11-23', 'rosé', '', 'Theorema', 'The watch stop working ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.156.104.190', 'c-73-156-104-190.hsd1.fl.comcast.net', '2026-01-10', '--', NULL),
(14833, 'T82582', 11849, 999999999, 0, '123-Madame Butterfly', '2026-02-19', '2026-01-10', '2025-11-23', 'rosé', 'silvgrey', 'Theorema', 'The watch stopped working ', 'new movement, cleaned hands, new dial, cleaned glass, demag, rate 2.81s , 0.28ms, 284.6', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-09 01:11:47', 1, '2026-02-19 01:40:46', 1, '2026-03-22 15:04:30', 1, 1, '2026-03-26', '73.156.104.190', 'c-73-156-104-190.hsd1.fl.comcast.net', '2026-01-10', '9405530109355351340067', ''),
(14834, 'T83948', 11850, 999999999, 0, '106-Toronto GM', '1970-01-01', '2026-01-11', '2026-01-11', 'rosé', 'blue', 'Theorema', 'Exchange request for the GM-106-11 / Rose', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.187.141.86', 'pool-71-187-141-86.nwrknj.fios.verizon.net', '2026-01-11', '--', NULL),
(14835, 'T82391', 11851, 999999999, 0, '108-Oman', '1970-01-01', '2026-01-11', '1970-01-01', 'gold', 'gold', 'Theorema', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '31.10.145.200', '31-10-145-200.cgn.dynamic.upc.ch', '2026-01-11', '--', NULL);
INSERT INTO `watch` (`watchid`, `orderid`, `customer_id`, `receiptuser_id`, `altereduser_id`, `model`, `dateofreceipt`, `dateofinvoice`, `warranty`, `case`, `dial`, `brand`, `defectdescription`, `repairinfo`, `repairprice`, `dateofdispatch`, `dateoffinished`, `inprocess`, `control`, `waiting`, `finished`, `unfinished`, `defect`, `fetched`, `received_client`, `received_client_date`, `sent_repair_de`, `sent_repair_de_date`, `sent_shop_usa`, `sent_shop_usa_date`, `entrance`, `conveyed`, `conveyeddate`, `uip`, `uhost`, `week`, `sendnr`, `notes`) VALUES
(14836, 'T68819', 11852, 999999999, 0, '126-Golden Gate', '2026-02-12', '2026-01-11', '2024-02-20', 'black', 'gold', 'Theorema', 'The watch just stop working. Can\'t say precisely what happened.', 'new movement, new minute hand, demag case, 725s , 0.19ms, 285.3° , cleaned case , lub stem', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-23 01:51:28', 1, '2026-02-02 00:37:11', 1, '2026-05-05 18:54:37', 1, 0, '1970-01-01', '68.33.127.125', 'c-68-33-127-125.hsd1.md.comcast.net', '2026-01-11', '--', ''),
(14837, 'T82001', 11853, 999999999, 0, '108-Oman', '1970-01-01', '2026-01-12', '2025-10-23', 'black', 'gold', 'Theorema', 'I tried using this watch after buying it and tried following all the instructions on how to use it, The watch has stopped working even when fully wound. Usually when trying to use it manually you would shake it and it would start working but this one didn’t. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '76.39.222.60', 'syn-076-039-222-060.res.spectrum.com', '2026-01-12', '--', NULL),
(14838, 'T83522', 11854, 999999999, 0, 'Choose option', '1970-01-01', '2026-01-12', '1970-01-01', 'Choose option', 'Choose option', 'Choose option', 'No defect. Box was never opened. I ordered more that I can afford. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '155.43.78.102', 'nat-hc-staff-78.nat.commnet.edu', '2026-01-12', '--', NULL),
(14839, '', 11855, 999999999, 0, '101-Casablanca GM', '2026-02-19', '2026-01-13', '2025-11-28', 'gold', 'white', 'Theorema', 'When the watch is set fully in will not work. It also will not unwind fro the position it \nis set at. Im not sure what the Order ID is. Please let me know if that\'s an issue.', 'fixed escapement, demag case and mvt, tighteend screws, rate perfect,  9.63s', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-09 01:03:23', 1, '2026-02-19 01:41:03', 0, NULL, 1, 1, '2026-03-23', '108.173.221.163', 'd108-173-221-163.abhsia.telus.net', '2026-01-13', '1Z8VF459DA62898434', ''),
(14840, 'T83872', 11856, 999999999, 0, '104-Copacabana', '1970-01-01', '2026-01-13', '2026-01-02', 'gold', 'white', 'Theorema', 'The watch stalls even when fully wound. It starts and stops. Loses time within 15 mins. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.81.1.29', '172.81.1.29', '2026-01-13', '--', NULL),
(14841, 'T83994', 11857, 999999999, 0, '505-Florida', '1970-01-01', '2026-01-14', '2026-01-09', 'silver', 'blue', 'Pionier', 'The watch is a beautiful timepiece; however, after seeing it in person, I have decided that it does not quite meet my current needs.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '68.200.238.213', 'syn-068-200-238-213.res.spectrum.com', '2026-01-14', '--', NULL),
(14842, 'T83331', 11858, 999999999, 0, '117-Kingston', '1970-01-01', '2026-01-14', '2026-01-13', 'gold', 'blue', 'Theorema', 'Too large for wife\'s wrist (Sally Mars, who initiated the return). ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '216.82.44.125', '216.82.44.125', '2026-01-14', '--', NULL),
(14843, 'T82391', 11859, 999999999, 0, '108-Oman', '2026-04-13', '2026-01-14', '1970-01-01', 'gold', 'gold', 'Theorema', 'The hour and minute hands get stuck; even when the second hand is moving, the hour and minute hands stay at the same time.\n\nDie Uhr hat ein Problem mit den Zeigern, die sich während meiner Nutzung bewegen, sie blockieren sogar beim Aufziehen, daher kenne ich die Uhr gut, weil es die zweite Uhr ist, die ich kaufe, und die erste funktionierte perfekt.\n', 'new movement, new minute and hour hand, demag case. new crown protector screws, lub stem, cleaned dial,  753s, 0.47ms, 306.2°', '0', '1970-01-01', '1970-01-01', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '31.10.145.200', '31-10-145-200.cgn.dynamic.upc.ch', '2026-01-14', '--', ''),
(14844, 'T62093', 11860, 999999999, 0, '903-Basel', '1970-01-01', '2026-01-14', '1970-01-01', 'gold', 'white', 'Pionier', 'Order number is \n\nT62093- The mechanism never activated the watch. The watch then remains fully wound without ever functioning. Please repair accordingly. \nI have previously sent this watch to you for repairs with the same issue.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '180.150.80.120', '180-150-80-120.NBN.mel.aussiebb.net', '2026-01-14', '--', NULL),
(14845, 'T62093', 11861, 999999999, 0, '903-Basel', '2026-02-12', '2026-01-14', '1970-01-01', 'gold', 'white', 'Pionier', 'My Order number is \n\nT62093- The mechanism never activated the watch. The watch then remains fully wound without ever functioning. Please repair accordingly.', 'test start 18.03.26 15:23,, new movement, cleaned dial, new hour hand, cleaned hands, cleaned case, 5.29s, 0.01ms, 273.9°', '0', '1970-01-01', '1970-01-01', 1, 1, 0, 0, 0, 0, 0, 1, '2026-01-21 22:52:09', 1, '2026-02-02 00:36:58', 0, NULL, 1, 0, '1970-01-01', '180.150.80.120', '180-150-80-120.NBN.mel.aussiebb.net', '2026-01-14', '--', ''),
(14846, 'T83882', 11862, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-14', '1970-01-01', 'silver', 'white', 'Theorema', 'dont like style ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '50.77.14.121', '50.77.14.121', '2026-01-14', '--', NULL),
(14847, 'T83456', 11863, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-16', '2025-12-12', 'black', 'yellow', 'Theorema', 'My husband went to wind up the watch that I bought for him in December, and nothing happened when he went to wind it up. The watch has completely stopped working. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.129.179.122', 'dynamic-104-129-179-122.tidewater.net', '2026-01-16', '--', NULL),
(14848, '#T82407', 11864, 999999999, 0, '7001-Havana', '2026-04-02', '2026-01-17', '2025-11-16', 'black', 'gold', 'Pionier', 'My order number is T82407- The watch is brand new and unworn.', '--', '0', '1970-01-01', '2026-04-02', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '77.56.152.79', '77-56-152-79.dclient.hispeed.ch', '2026-01-17', '--', ''),
(14849, 'T83564', 11865, 999999999, 0, '114-Buenos Aires', '2026-02-10', '2026-01-18', '2025-12-19', '', '', 'Theorema', 'I am very upset. I have 8 watches from you. This is the second one I am sending for repair, and by far the worst. I wore it only once, and the crown came off. What quality is this? I removed my Trustpilot review, but I am really worried about my watches quality. I might write another review because this is not good. Replace or repair, although I have lost my trust.', 'new croiwn stem, fixed manual winding, fresh lubricant for stem and adhesive , cleaned glass, fixed minute hand', '0', '2026-03-18', '2026-03-18', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-18 02:37:42', 1, '2026-02-02 00:36:18', 1, '2026-03-18 11:19:16', 1, 1, '2026-03-23', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-01-18', '9405530109355334265547', ''),
(14850, 'T82817', 11866, 999999999, 0, '505-Florida', '1970-01-01', '2026-01-18', '2025-11-29', 'silver', 'blue', 'Pionier', 'The watch does not keep the correct time. It delays. It is never on time. Thanks.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-01-18 02:50:56', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-01-18', '--', ''),
(14851, 'gm 12g.1', 11867, 999999999, 0, 'other', '1970-01-01', '2026-01-19', '2026-01-19', 'gold', 'silvgrey', 'other', 'Watch does not keep time when fully wound.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.77.85.97', '108-77-85-97.lightspeed.rlghnc.sbcglobal.net', '2026-01-19', '--', NULL),
(14852, 'T84032', 11868, 999999999, 0, '117-Kingston', '1970-01-01', '2026-01-19', '2026-01-10', 'gold', 'white', 'Theorema', 'DOES NOT WORK AFTER WINDING THE WATCH 30 TIMES PER TUFINA EMAIL THE WATCH \n\nONLY WORKS FOR 2-3 MINUTES.    THEN IT STOPS.    THIS IS UNACCEPTABLE.\n\nI CURRENTLY OWN 7 OTHER TUFINA WATCHES AND HAVE HAD NO PROBLEMS AND THEY \n\nALL WORK GREAT.   DR. FORREST PATIN  925-699-7300', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.132.244.152', '71-132-244-152.lightspeed.irvnca.sbcglobal.net', '2026-01-19', '--', NULL),
(14853, 'gm 101-14', 11869, 999999999, 0, '101-Casablanca GM', '2026-02-10', '2026-01-19', '2024-11-25', 'gold', 'white', 'Theorema', 'The watch stopped working a few days ago. I followed the instructions in the manual, but it\'s still not working.', 'fixed escapement, demag case and mvt, lubricated fresh, rate 1.74', '0', '2026-04-17', '2026-04-17', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-30 17:31:33', 1, '2026-02-02 00:37:58', 1, '2026-04-19 14:59:25', 1, 1, '2026-04-25', '104.187.72.170', '104-187-72-170.lightspeed.rcsntx.sbcglobal.net', '2026-01-19', '9405530109355371188861', ''),
(14854, '', 11870, 999999999, 0, '7001-Havana', '1970-01-01', '2026-01-19', '1970-01-01', 'silver', 'black', 'Pionier', 'De heeft 2 weken gewerkt en is daarna kapot gegaan .\nIk zou het graag weer laten maken ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '217.104.40.252', '217-104-40-252.cable.dynamic.v4.ziggo.nl', '2026-01-19', '--', NULL),
(14855, 'T83470 ', 11871, 999999999, 0, '7002-Chicago', '1970-01-01', '2026-01-19', '1970-01-01', 'gold', 'white', 'Pionier', 'the watch I bought Chicago P7002-3 | Gold  has an all white face causing the small print to fade into the background. I can not se the small print. I believe this watch PIONIER | GM-505-8 | GOLD has more contrast and will be readable.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '45.132.159.55', '45.132.159.55', '2026-01-19', '--', NULL),
(14856, '', 11872, 999999999, 0, '7001-Havana', '1970-01-01', '2026-01-20', '1970-01-01', 'silver', 'black', 'Pionier', 'De dagen teller is kapot gegaan\nZou hem graag gemaakt zien worden.\nHij is de eerste week al kapot gegaan', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '213.126.218.242', 'ip-213-126-218-242.ip.prioritytelecom.net', '2026-01-20', '--', NULL),
(14857, 'T83522', 11873, 999999999, 0, '103-Sao Paulo', '1970-01-01', '2026-01-20', '2025-12-25', '', '', 'Theorema', 'I can\'t aford this watch, I bought too many of them. This is new in box, never opened. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.61.199.9', 'c-24-61-199-9.hsd1.ct.comcast.net', '2026-01-20', '--', NULL),
(14858, 'T84051', 11874, 999999999, 0, '3001-Paragon', '1970-01-01', '2026-01-20', '2026-01-20', '', '', 'Theorema', 'There is no defect. I just ordered the wrong model', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.58.133.48', '172.58.133.48', '2026-01-20', '--', NULL),
(14859, 'T84049', 11875, 999999999, 0, 'other', '2026-01-23', '2026-01-21', '1970-01-01', 'bicolor', 'black', 'other', 'Die Uhr habe ich am 13.01.2026 erhalten. Ich habe Sie sofort kontaktiert um mir ein Retourschein zu senden. Ich habe Ihnen bereits Fotos geschickt, die Uhr ist in der originalen Verpackung und wurde gar nicht getragen, also es ist neu ich möchte es zurückgeben, weil der Armband meiner Vorstellung nicht gepasst hat.\nVielen Dank für Ihr Verständnis.\nBitte senden Sie mir ein Retourschein.\n\nMit freundlichen Grüßen \nAdem Yildirim ', '--', '0', '1970-01-01', '2026-01-26', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '87.157.241.0', 'p579df100.dip0.t-ipconnect.de', '2026-01-21', '--', ''),
(14860, 'T84130', 11876, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-23', '2026-01-19', 'silver', 'yellow', 'Theorema', 'Does not stay wound. Time lapses are too much for me to maintain. \nWill be exchanging for automatic. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '100.26.150.206', 'ec2-100-26-150-206.compute-1.amazonaws.com', '2026-01-23', '--', NULL),
(14861, 'T84130', 11876, 999999999, 0, '108-Oman', '1970-01-01', '2026-01-23', '2026-01-19', 'gold', 'gold', 'Theorema', 'Does not stay wound. Will exchange for automatic. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '100.26.150.206', 'ec2-100-26-150-206.compute-1.amazonaws.com', '2026-01-23', '--', NULL),
(14862, '', 11877, 999999999, 0, 'other', '1970-01-01', '2026-01-24', '1970-01-01', 'bicolor gold', 'gold', 'Javelle', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.18.254.232', 'c-73-18-254-232.hsd1.mi.comcast.net', '2026-01-24', '--', NULL),
(14863, 'CM n06-5', 11878, 999999999, 0, '508-Dublin', '2026-02-19', '2026-01-24', '2025-06-05', 'gold', 'silvgrey', 'Pionier', 'When wind to start…won’t start…watch won’t run…Provided pictures and video', 'seems OK, test start 15:45 18.03.26, Tatiana tested during our 3 week vacation and it was working constant perfect', '0', '2026-04-17', '2026-04-17', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-19 01:41:59', 1, '2026-02-19 01:41:59', 1, '2026-04-19 14:58:21', 1, 1, '2026-04-25', '108.211.192.23', '108-211-192-23.uvs.miamfl.sbcglobal.net', '2026-01-24', '9405530109355371190413', 'When we received the watch in the US, it was working perfectly for almost 3 days, then when it stopped, we could not start it again, even by manually winding it or shaking it'),
(14864, 'T84034', 11879, 999999999, 0, '117-Kingston', '1970-01-01', '2026-01-24', '2026-01-10', 'gold', 'white', 'Theorema', 'I wind the watch turning the crown clockwise 30 times likes the manual says star to work but them stops ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.24.129.253', 'syn-024-024-129-253.res.spectrum.com', '2026-01-24', '--', NULL),
(14865, 'T84034', 11880, 999999999, 0, '117-Kingston', '1970-01-01', '2026-01-24', '2026-01-10', 'gold', 'white', 'Theorema', 'I wind the watch by turning the crown 30 times star to work but them after stops', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.24.139.137', 'syn-024-024-139-137.res.spectrum.com', '2026-01-24', '--', NULL),
(14866, 'T81084', 11881, 999999999, 0, '110-Oslo', '2026-02-19', '2026-01-25', '2025-09-05', 'rosé', 'blue', 'Theorema', 'My order number is T81084. The decorative part of the second hand is loose. Specifically, the winged piece around the dial has fallen off (screws seem to have come undone) inside the chassis. The timekeeping mechanism appears undamaged, and there is no exterior damage. Additionally, the watch runs about 30 seconds slow to the day (since I obtained it), so any type of tuning is welcome if you are able (otherwise it’s not a large issue). Please replace/repair accordingly.', 'new movement, new hands, new dial, cleaned glass, demagh case and mvt, adjsuted to 0.63s , 0.02ms', '0', '2026-03-21', '2026-03-21', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-09 00:53:25', 1, '2026-02-19 01:42:11', 1, '2026-03-22 15:05:18', 1, 1, '2026-03-26', '153.90.20.233', 'secure-wireless-nat-20-233.msu.montana.edu', '2026-01-25', '9410830109355008876775', ''),
(14867, 'T883625', 11882, 999999999, 0, '104-Copacabana ', '2026-02-12', '2026-01-26', '2025-12-22', 'gold', 'yellow', 'Theorema', '  I ROTATE 40 CLOCKWISE, IT RUNS FOR A WHILE AND IT STOPS\n MAY YOU FIX IT OR EXCHANGE ME A GOOD ONE. I APPRECIATE YOUR WORK\n\n', 'fixed escapement, lubricated fresh, demag case and mvt, tightened all screws, rate 0.20s , 0.13ms , ', '0', '2026-04-17', '2026-04-17', 1, 1, 0, 1, 0, 0, 1, 1, '2026-01-30 17:28:57', 1, '2026-02-02 00:38:10', 1, '2026-04-19 14:59:48', 1, 1, '2026-04-25', '35.146.180.202', 'syn-035-146-180-202.res.spectrum.com', '2026-01-26', '9405530109355371185778', ''),
(14868, 'T84004', 11883, 999999999, 0, '3011-Macau', '1970-01-01', '2026-01-29', '2026-01-13', 'gold', 'white', 'Theorema', 'Order number T84004. I am returning the watch because its too heavy and i dont like it.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '174.227.141.109', '109.sub-174-227-141.myvzw.com', '2026-01-29', '--', NULL),
(14869, '', 11884, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-01-29', '1970-01-01', '', '', 'Theorema', 'It did not fit comfortably on the wrist - order number T84171. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '70.118.9.170', 'syn-070-118-009-170.biz.spectrum.com', '2026-01-29', '--', NULL),
(14870, 'T58053', 11885, 999999999, 0, '505-Florida', '1970-01-01', '2026-01-29', '2022-07-12', 'black', 'gold', 'Pionier', 'Lateral knob not functioning, and watch gears are slow therefore time is not accurate. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.59.201.152', '172.59.201.152', '2026-01-29', '--', NULL),
(14871, 'T58053', 11886, 999999999, 0, '505-Florida', '2026-02-19', '2026-01-29', '2023-08-20', 'black', 'gold', 'Pionier', 'Lateral knob not functioning, and watch gears working intermittently ', 'waiting for payment 90€ , all done', '0', '2026-05-05', '2026-05-05', 1, 1, 1, 1, 0, 0, 1, 1, '2026-02-09 00:29:02', 1, '2026-02-19 01:41:19', 1, '2026-05-05 18:51:59', 1, 0, '1970-01-01', '172.59.201.152', '172.59.201.152', '2026-01-29', '--', ''),
(14872, '', 11887, 999999999, 0, '108-Oman', '1970-01-01', '2026-01-30', '2024-04-17', 'gold', 'gold', 'Theorema', 'Die Uhr funktioniert nicht ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '80.128.99.196', 'p508063c4.dip0.t-ipconnect.de', '2026-01-30', '--', NULL),
(14873, '', 11888, 999999999, 0, 'Choose option', '1970-01-01', '2026-01-30', '1970-01-01', 'Choose option', 'Choose option', 'Choose option', 'Hi,\nI\'d like to return order #T84268.\nMy son didn\'t love the watch that we ordered and thought it looked different from the pictures online. The watch was opened for a total of 2 minutes. Never worn or used.\nThank you so much,\nNaomi Cadle', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '96.244.233.228', 'pool-96-244-233-228.bltmmd.fios.verizon.net', '2026-01-30', '--', NULL),
(14874, 'T81797', 11889, 999999999, 0, '502-Malibu', '2026-04-23', '2026-01-30', '2025-10-16', 'gold', 'blue', 'Pionier', 'The glass of my watch is broken, and the movement has stopped.”', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-10 00:52:47', 1, '2026-04-20 01:02:20', 0, NULL, 1, 0, '1970-01-01', '50.218.165.37', '50.218.165.37', '2026-01-30', '--', ''),
(14875, 'T83869', 11890, 999999999, 0, '102-Monte Carlo GM', '1970-01-01', '2026-01-31', '2026-01-02', 'rosé', 'white', 'Theorema', 'Watch too large for my wrist', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '154.5.167.47', 'd154-5-167-47.bchsia.telus.net', '2026-01-31', '--', NULL),
(14876, 'T83856', 11891, 999999999, 0, '505-Florida', '1970-01-01', '2026-02-02', '2025-12-31', 'rosé', 'blue', 'Pionier', 'Received the watch, set it and placed it back into the box for storing.  Took it out to wear to dinner. At the restaurant my husband was complimented on his watch. On our way home he went to look at the watch and noticed the glass was gone and one of the hands.  We searched everywhere in the vehicle, drove back looked around outside and could not find it.  The watch was not hit or bumped.  We placed it back into the box and I emailed the next day. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '70.65.76.33', 'S010638ad2bf09c63.lb.shawcable.net', '2026-02-02', '--', NULL),
(14877, 'T84284', 11892, 999999999, 0, '511-New York', '1970-01-01', '2026-02-02', '2026-02-01', 'gold', 'black', 'Pionier', 'Watch is to big for me no defects', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.56.34.115', 'ue.tmodns.net', '2026-02-02', '--', NULL),
(14878, 'T83864', 11893, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-02', '2026-02-01', 'gold', 'white', 'Theorema', 'The watch has stopped working although it has been wound correctly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.207.75.152', '108-207-75-152.lightspeed.irvnca.sbcglobal.net', '2026-02-02', '--', NULL),
(14879, 'T81784', 11894, 999999999, 0, '116-San Francisco', '2026-02-19', '2026-02-03', '2025-10-13', 'gold', 'gold', 'Theorema', 'The hand has fallen off and it is winding at all', 'new movement, new dial , new hands, demag case, demag movement ring, rate 4.14 . 0.44 , 238° ,, brand new watch , no repair', '0', '2026-03-22', '2026-03-22', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-15 03:48:28', 1, '2026-02-19 01:41:45', 0, NULL, 1, 1, '2026-03-23', '50.100.191.245', 'bras-base-stckon0807w-grc-41-50-100-191-245.dsl.bell.ca', '2026-02-03', '1Z8VF459DA63079595', ''),
(14880, 'T84361', 11895, 999999999, 0, '7001-Havana', '1970-01-01', '2026-02-04', '2026-01-31', 'gold', 'blue', 'Pionier', 'No defect, in fact I haven\'t picked it up from the post office yet, so it is in Perfect shipped condition from your team. It looks like a beautiful watch from the online pictures, but my boyfriend and I broke up, so I don\'t need it anymore.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '35.149.70.20', 'syn-035-149-070-020.res.spectrum.com', '2026-02-04', '--', NULL),
(14881, 'T84302', 11896, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-04', '2026-01-26', 'silver', 'white', 'Theorema', 'My order number is T84302. The watch is manually wound but doesn\'t work. The watch is brand new, in original packaging and never worn. I have been advised via email that it will be replaced.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '90.246.72.98', '90.246.72.98', '2026-02-04', '--', NULL),
(14882, 'T84242', 11897, 999999999, 0, '101-Casablanca GM', '2026-02-19', '2026-02-04', '2026-01-22', 'silver', 'white', 'Theorema', 'The clasp over the dial is loose and unable to latch properly. The wrist latch is also scuffed a little. Would like to return item and receive a refund.', 'waiting for chargeback to close, fixed crown protector, and wrist clasp, both tight now', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-15 02:11:08', 1, '2026-02-19 01:41:33', 1, '2026-05-05 18:53:34', 1, 0, '1970-01-01', '172.58.125.47', '172.58.125.47', '2026-02-04', '--', ''),
(14883, '', 11898, 999999999, 0, '506-Miami', '2026-02-10', '2026-02-05', '1970-01-01', 'gold', 'black', 'Pionier', 'There are specks of dirt on the dial under the watch glass, and a foreign body on the date display, as if a part of the mechanism had been broken off.', 'new dial, cleaned hands, demag movement and case, cleaned case and band,  8.28s, 0.11ms, 236,5° , ', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-05-05', '178.159.171.15', '178-159-171-15.tsm.tarnobrzeg.pl', '2026-02-05', '1Z8VF459DA63707576', ''),
(14884, 'T81094', 11899, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-06', '2025-09-09', 'silver', '', 'Theorema', '\nUnfortunately, I have encountered an issue with the crown of the watch.\nWhen I attempt to wind it, it unwinds immediately and does not function properly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '148.75.19.18', 'ool-944b1312.dyn.optonline.net', '2026-02-06', '--', NULL),
(14885, '', 11900, 999999999, 0, '131- Singapore', '2026-03-11', '2026-02-08', '2025-08-12', 'black', 'white', 'Theorema', 'T83094 - Stopped ticking and can\'t get it started', 'new movement, demag case, cleaned case', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-24 17:00:18', 1, '2026-03-04 18:15:20', 1, '2026-05-05 18:54:19', 1, 0, '1970-01-01', '68.8.3.12', 'ip68-8-3-12.sd.sd.cox.net', '2026-02-08', '--', ''),
(14886, 'Ilmi Kadriu', 11901, 999999999, 0, '505-Florida', '1970-01-01', '2026-02-08', '2025-04-09', 'gold', 'blue', 'Pionier', 'Its not working date for example it stay now in 20 and it dont more anymore', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '213.188.117.5', 'IP-213188117005.dynamic.medianet-world.de', '2026-02-08', '--', NULL),
(14887, 'T84063', 11902, 999999999, 0, 'other', '1970-01-01', '2026-02-10', '2026-02-10', 'gold', 'gold', 'other', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '174.208.98.27', '27.sub-174-208-98.myvzw.com', '2026-02-10', '--', NULL),
(14888, 'T84063', 11903, 999999999, 0, '116-San Francisco', '1970-01-01', '2026-02-10', '2026-02-10', 'gold', 'gold', 'Theorema', 'The dial is too big for my wife’s wrist. And the band is too wide for her hands as well. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.12.253.82', 'c-73-12-253-82.hsd1.ca.comcast.net', '2026-02-10', '--', NULL),
(14889, 'T84322', 11904, 999999999, 0, '112-Madrid', '1970-01-01', '2026-02-11', '1970-01-01', 'gold', 'black', 'Theorema', 'No defects.  This is a return.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.22.151.81', 'c-24-22-151-81.hsd1.wa.comcast.net', '2026-02-11', '--', NULL),
(14890, 'Gmaoldd', 11905, 999999999, 0, '101-Casablanca GM', '2026-03-11', '2026-02-11', '1970-01-01', 'gold', 'yellow', 'Theorema', 'Can not set time.Stem pulls out rose gold', 'new movement, demag case, 14.07s , 0.07ms , 302.2°', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-21 01:46:13', 1, '2026-03-04 18:15:32', 1, '2026-05-05 18:53:51', 1, 0, '1970-01-01', '172.116.176.10', 'syn-172-116-176-010.res.spectrum.com', '2026-02-11', '--', ''),
(14891, 'T84389', 11906, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-12', '2026-02-04', 'silver', 'white', 'Theorema', 'Does not fit', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '76.122.14.74', 'c-76-122-14-74.hsd1.ga.comcast.net', '2026-02-12', '--', NULL),
(14892, '#T84547', 11907, 999999999, 0, '121-St Petersburg', '1970-01-01', '2026-02-14', '1970-01-01', 'rosé', 'blue', 'Theorema', 'The watch is to small for my hands so I would like to return it for a refund It literally just arrived yesterday Friday the 13.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '167.88.62.214', '214-62-88-167.clients.gthost.com', '2026-02-14', '--', NULL),
(14893, 'T84487', 11908, 999999999, 0, '505-Florida', '1970-01-01', '2026-02-15', '2026-02-03', '', '', 'Pionier', 'I didn’t like how it looked, it’s not my style. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.255.201.248', '108-255-201-248.lightspeed.sndgca.sbcglobal.net', '2026-02-15', '--', NULL),
(14894, '', 11909, 999999999, 0, '117-Kingston', '2026-03-11', '2026-02-15', '2025-12-21', 'silver', 'blue', 'Theorema', 'One of the second hands is stuck in the automatic spinner', 'new date hand, fixed hands, cleaned hands, cleaned dial, cleaned glass, demag case and mvt, adjusted rate to  8.74s, 0.37ms, 304.6°', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-27 01:29:34', 1, '2026-03-04 18:15:47', 1, '2026-05-05 18:55:53', 1, 0, '1970-01-01', '45.50.208.210', 'syn-045-050-208-210.res.spectrum.com', '2026-02-15', '--', ''),
(14895, 'T84360', 11904, 999999999, 0, '519-Milano', '1970-01-01', '2026-02-16', '1970-01-01', 'gold', 'black', 'Pionier', 'No defect. I shouldn\'t have bought it at this so returning it un-opened and un-used.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.22.151.81', 'c-24-22-151-81.hsd1.wa.comcast.net', '2026-02-16', '--', NULL),
(14896, 'T78102', 11910, 999999999, 0, 'اختر الخيار', '2026-02-24', '2026-02-16', '1970-01-01', 'اختر الخيار', 'اختر الخيار', 'اختر الخيار', 'Bestellnu Bestellnummer T78102 – Die Uhr geht vor. Bitte entsprechend reparieren.\nOrder number T78102-The watch is running ahead of time. Please repair accordingly.]', 'demag, looks fine, test start 15:01 22.03.26, Tatiana tested it during our 3 week vacation and it was working constantly perfect', '0', '2026-04-17', '2026-04-17', 1, 1, 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-04-20', '88.130.147.20', 'i58829314.versanet.de', '2026-02-16', '00340434129949135861', ''),
(14897, 'T84374', 11911, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-16', '2026-02-05', 'white', 'white', 'Theorema', 'Dial is too big for my wrist.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '152.58.152.4', '152.58.152.4', '2026-02-16', '--', NULL),
(14898, 'T82694', 11912, 999999999, 0, '2009-Casablanca', '1970-01-01', '2026-02-17', '1970-01-01', 'rosé', 'white', 'Theorema', 'The watch band comes undone all the time . Very irritating and I’m asking to be sent a different band same color with no clasp . ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '174.219.125.36', '36.sub-174-219-125.myvzw.com', '2026-02-17', '--', NULL),
(14899, 'T82781', 11912, 999999999, 0, '106-Toronto GM', '2026-03-20', '2026-02-17', '2025-12-01', 'gold', 'white', 'Theorema', 'The watch stopped working . Will wind up 40 times like told and it stays going for a few minutes and stops won’t start back . ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-03-04 18:57:42', 1, '2026-03-21 16:52:11', 0, NULL, 1, 0, '1970-01-01', '174.219.125.36', '36.sub-174-219-125.myvzw.com', '2026-02-17', '--', 'Ship only to 795 Grinders Switch Rd, Centerville, TN, 37033'),
(14900, 'T82694', 11912, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-17', '1970-01-01', 'rosé', 'white', 'Theorema', 'Clasp pops open multiple times while wearing . Asking please for different band no clasp', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, '2026-03-04 18:57:22', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '174.219.125.36', '36.sub-174-219-125.myvzw.com', '2026-02-17', '--', 'Ship only to 795 Grinders Switch Rd, Centerville, TN, 37033'),
(14901, 'T84473', 11913, 999999999, 0, '101-Casablanca GM', '2026-02-24', '2026-02-17', '2026-02-04', 'gold', 'white', 'Theorema', 'Didn\'t like the watch style. Would like to make a refund. ', '--', '0', '1970-01-01', '2026-02-24', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '85.190.239.154', '85.190.239.154', '2026-02-17', '--', ''),
(14902, 'T73563', 11914, 999999999, 0, '115-Helsinki', '2026-03-11', '2026-02-17', '2024-10-15', 'black', 'white', 'Theorema', 'My order number is T73563.The watch has stopped working. Please replace/repair accordingly.\n\n', 'new movement, demag case, cleaned hands, cleaned glass', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-27 01:10:08', 1, '2026-03-04 18:16:26', 0, NULL, 1, 1, '2026-05-05', '49.184.126.143', 'pa49-184-126-143.pa.vic.optusnet.com.au', '2026-02-17', '1Z8VF459D961016590', ''),
(14903, 'T84581', 11915, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-17', '2026-02-17', 'rosé', 'yellow', 'Theorema', 'no defect- the watch face is much larger than i anticipated.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '163.116.145.90', '163.116.145.90', '2026-02-17', '--', NULL),
(14904, 'GM 7001-3', 11916, 999999999, 0, '505-Florida', '1970-01-01', '2026-02-18', '2024-07-19', 'gold', 'blue', 'Pionier', 'All with the watch working properly except the date. It stops, impossible to change date.\nI checked to see if it will change automatically, nothing changed.\nThat’s why I’m sending back to you to repair.\nGreetings!', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '95.160.153.171', '095160153171.warszawa.vectranet.pl', '2026-02-18', '--', NULL),
(14905, 'T68254', 11917, 999999999, 0, '125-Istanbul', '2026-03-11', '2026-02-18', '2024-02-20', 'black', 'gold', 'Theorema', 'The components inside came loose. I would really appreciate this repaired at no cost as I have bought several watches from you all. This watch was purchased on 1/23/24 and worn about 10 times.', 'njew movement. new dial, new hands, cleaned case, 10.88s , 0.62ms , 255.4°', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-02-27 01:22:50', 1, '2026-03-04 18:15:59', 1, '2026-05-05 18:54:56', 1, 0, '1970-01-01', '99.27.248.95', '99.27.248.95', '2026-02-18', '--', ''),
(14908, 'T84669', 11920, 999999999, 0, '519-Milano', '1970-01-01', '2026-02-19', '1970-01-01', 'gold', 'gold', 'Pionier', 'Non/N/A', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.58.129.196', '172.58.129.196', '2026-02-19', '--', NULL),
(14909, 'T84499', 11921, 999999999, 0, '123-Madame Butterfly', '1970-01-01', '2026-02-19', '2026-02-15', 'blue', 'blue', 'Theorema', 'order number T84499  and request an exchange for GM-123-10\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.62.12.164', 'c-71-62-12-164.hsd1.va.comcast.net', '2026-02-19', '--', NULL),
(14910, 'T84669', 11922, 999999999, 0, '519-Milano', '1970-01-01', '2026-02-19', '1970-01-01', 'gold', 'gold', 'Pionier', 'Non.N/A', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.58.135.210', '172.58.135.210', '2026-02-19', '--', NULL),
(14911, 'T84729', 11923, 999999999, 0, '7002-Chicago', '1970-01-01', '2026-02-20', '2026-02-20', 'gold', 'blue', 'Pionier', 'Please exchange my watch with the p7002 - blue and I will pay $65.00 for delivery to my address 1604 Ventura blv Camarillo ,ca 93010 thank you ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.147.175.21', '108.147.175.21', '2026-02-20', '--', NULL),
(14912, 'NA', 11924, 999999999, 0, 'T2001', '2026-03-04', '2026-02-21', '2006-02-10', 'silver', '', 'Theorema', 'Not function, check-up for repair ', 'waiting for payment 170/200€, new case, new movement, new hands, demag everything,  8.28s, 0.15ms, 297.9°', '0', '1970-01-01', '1970-01-01', 1, 1, 1, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '93.47.43.178', '93-47-43-178.ip111.fastwebnet.it', '2026-02-21', '--', ''),
(14913, 'T84581', 11925, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-23', '2026-02-20', 'bicolor gold', 'yellow', 'Theorema', 'Watch face is too large ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.179.44.27', 'pool-71-179-44-27.bltmmd.fios.verizon.net', '2026-02-23', '--', NULL),
(14914, 'T84568 ', 11926, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-02-23', '2026-02-18', 'gold', 'white', 'Theorema', 'The watch is not working and I decided that I also do not want the watch after seeing it.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.58.241.34', '172.58.241.34', '2026-02-23', '--', NULL),
(14915, 'T83794', 11927, 999999999, 0, '7001-Havana', '1970-01-01', '2026-02-23', '2025-11-01', 'blue', 'white', 'Pionier', 'Hello! The date feature of my watch does not seem to be working correctly. The date will jump from the 4th to the 15th. and it will rotate all the way until the 39th. Something seems to be happening with whatever turns the date. Thank you!', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-05-03 20:30:14', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.15.125.20', '104-15-125-20.lightspeed.okcbok.sbcglobal.net', '2026-02-23', '--', ''),
(14916, 'T77214', 11928, 999999999, 0, '115-Helsinki', '2026-04-13', '2026-02-23', '2025-01-27', 'silver', 'gold', 'Theorema', 'I purchased a Theorema Helsinki watch model GM-115-9 on January 21, 2025, and it stopped working in June 2025. I did nothing wrong and used it correctly and carefully. I tried winding it manually 30 times clockwise and moving it as shown in the instruction booklet and the video received by email, but without success. The watch still isn\'t working. Please replace/repair accordingly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-03-30 03:44:49', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '35.183.244.232', 'ec2-35-183-244-232.ca-central-1.compute.amazonaws.com', '2026-02-23', '--', ''),
(14917, '', 11929, 999999999, 0, '7002-Chicago', '1970-01-01', '2026-02-24', '2024-10-28', 'silver', 'white', 'Pionier', 'Watch face clouds when its cold out. Random gold trim inside watch face has come loose. Dials are loose and not keeping time ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '96.54.197.165', 'S0106400fc1c02d7e.cc.shawcable.net', '2026-02-24', '--', NULL),
(14918, 'T73978', 11930, 999999999, 0, '7002-Chicago', '2026-03-20', '2026-02-25', '2024-10-28', 'silver', 'white', 'Pionier', 'My order number is T73978. There is condensation inside the watch and a loose gold rim inside the face. Please replace/ repair accordingly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-03-21 16:53:02', 1, '2026-03-21 16:53:02', 0, NULL, 1, 0, '1970-01-01', '70.67.150.122', 'S0106f8345a7fd333.cc.shawcable.net', '2026-02-25', '--', ''),
(14919, 'T81619', 11931, 999999999, 0, '7001-Havana', '1970-01-01', '2026-02-26', '2025-10-10', 'blue', 'white', 'Pionier', 'The date window has a defect that when it gets to ten it skips to 17 and won\'t allow for the numbers in between, the watch has only been worn one time due to changing out the strap due to poor quality strap provided', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '72.49.59.210', 'mh1-dsl-72-49-59-210.fuse.net', '2026-02-26', '--', NULL),
(14920, 'T84719', 11932, 999999999, 0, 'other', '1970-01-01', '2026-02-26', '2026-02-23', 'silver', '', 'other', 'The watch is too heavy for my husbands wrist. It has never been warm besides to try it on. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '146.75.128.225', '146.75.128.225', '2026-02-26', '--', NULL),
(14921, 'T61526', 11933, 999999999, 0, '108-Oman', '1970-01-01', '2026-02-27', '2020-10-26', 'black', 'gold', 'Theorema', 'Crown popped out ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '165.140.231.99', '165.140.231.99', '2026-02-27', '--', NULL),
(14922, 'T30562', 11934, 999999999, 0, '108-Oman', '1970-01-01', '2026-02-27', '2020-10-26', 'black', '', 'Theorema', 'Crown broken ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '165.140.231.99', '165.140.231.99', '2026-02-27', '--', NULL),
(14923, '#T79841', 11935, 999999999, 0, '102-Monte Carlo GM', '2026-04-13', '2026-03-01', '2025-04-06', 'gold', 'gold', 'Theorema', 'The  number 4 has fallen off please repair accordingly \n Thanks ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-03-30 05:09:58', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '66.27.99.172', 'syn-066-027-099-172.res.spectrum.com', '2026-03-01', '--', ''),
(14924, 'T64634', 11936, 999999999, 0, '101-Casablanca GM', '2026-04-13', '2026-03-02', '2023-09-18', 'gold', 'white', 'Theorema', 'The watch does not work. Once I turn the crown to tighten the coil so the watch will return to its working state it doesn’t do anything. Not of the gears turn. It just remains motionless. I’ve sent a video to Tufina watche showing what I’m describing as well.', 'waiting for payment 120€', '0', '1970-01-01', '1970-01-01', 0, 0, 1, 0, 0, 0, 0, 1, '2026-03-23 22:11:08', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '143.105.15.75', 'customer.ashnvax2.isp.starlink.com', '2026-03-02', '--', ''),
(14925, 'T40629', 11937, 999999999, 0, '3006-Monaco Diamond', '2026-04-13', '2026-03-02', '2020-02-03', 'black', 'gold', 'Theorema', 'The winding mechanism is no longer working. when I try to wind I can tell that its not winding with the gear on the inside of the dial. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-02 01:26:53', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '68.113.131.118', 'syn-068-113-131-118.res.spectrum.com', '2026-03-02', '--', ''),
(14926, 'T40629', 11938, 999999999, 0, '3006-Monaco Diamond', '1970-01-01', '2026-03-03', '2021-09-04', 'black', 'gold', 'Theorema', 'The winding mechanism is no longer working when I tried to wind. I can tell that the winding isn’t turning with the gear on the inside of the dial', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '217.217.113.43', '217.217.113.43', '2026-03-03', '--', NULL),
(14927, 'T84891', 11939, 999999999, 0, '7001-Havana', '1970-01-01', '2026-03-03', '2026-03-02', 'gold', 'black', 'Pionier', 'Too large ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '40.133.86.146', 'h146.86.133.40.static.ip.windstream.net', '2026-03-03', '--', NULL),
(14928, '', 11940, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-03-04', '2022-10-27', 'gold', 'white', 'Theorema', 'The watch is out of warranty- The crown has fallen off.  Please replace/ repair accordingly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '27.33.131.165', '27-33-131-165.tpgi.com.au', '2026-03-04', '--', NULL),
(14929, '', 11941, 999999999, 0, '101-Casablanca GM', '2026-03-20', '2026-03-04', '2027-12-27', 'silver', 'yellow', 'Theorema', 'The hand has fallen off. Please replace/repair accordingly', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-03-15 01:35:13', 1, '2026-03-21 16:53:34', 0, NULL, 1, 0, '1970-01-01', '66.27.200.179', 'syn-066-027-200-179.res.spectrum.com', '2026-03-04', '--', ''),
(14930, 'T53820', 11942, 999999999, 0, '101-Casablanca GM', '2026-03-20', '2026-03-05', '2022-07-26', 'black', 'black', 'Theorema', 'My order number is T53820-The watch is out of warranty, but it has stopped working. Please repair accordingly.', 'waiting for payment 80/110€', '0', '1970-01-01', '1970-01-01', 0, 0, 1, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '90.129.108.12', 'm90-129-108-12.cust.tele2.se', '2026-03-05', '--', ''),
(14931, 'T85000', 11943, 999999999, 0, '103-Sao Paulo', '1970-01-01', '2026-03-06', '2026-03-05', 'black', 'yellow', 'Theorema', 'T85000\n\nNo longer needed. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '144.86.183.134', '144.86.183.134', '2026-03-06', '--', NULL),
(14932, '', 11944, 999999999, 0, '506-Miami', '1970-01-01', '2026-03-06', '1970-01-01', 'gold', 'black', 'Pionier', 'Da ich ein schmales Handgelenk habe und das Armband schon der letzten einstell möglichenkeit ist ist es immer noch zu groß. Dadurch drückt der Metallbügel der Schließe ständig auf den Knochen,dadurch ist die Uhr nicht ohne Probleme tragbar. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '91.137.21.15', 'nat-91-137-21-15.net.encoline.de', '2026-03-06', '--', NULL),
(14933, 'T23304', 11945, 999999999, 0, 'Choose option', '1970-01-01', '2026-03-06', '1970-01-01', 'Choose option', 'Choose option', 'Choose option', 'No funciona el botón para darle cuerda pienso que esta desconectado con la parte de adentro \n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '47.17.219.240', 'ool-2f11dbf0.dyn.optonline.net', '2026-03-06', '--', NULL),
(14934, '485657225770', 11946, 999999999, 0, '511-New York', '2026-03-13', '2026-03-07', '1970-01-01', 'silver', 'black', 'Pionier', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '94.234.65.108', 'c-5eea416c-74736162.cust.telenor.se', '2026-03-07', '--', ''),
(14935, 'T84649', 11947, 999999999, 0, '7001-Havana', '1970-01-01', '2026-03-09', '2026-02-13', 'gold', 'white', 'Pionier', 'Watch is ticking too fast. The second hand moves too fast. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '45.27.129.188', '45.27.129.188', '2026-03-09', '--', NULL),
(14936, 'T85083', 11948, 999999999, 0, '111-Copenhagen', '1970-01-01', '2026-03-10', '2026-03-06', '', '', 'Theorema', 'Jonah Ndekugri', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.56.109.120', '172.56.109.120', '2026-03-10', '--', NULL),
(14937, 'T85082', 11948, 999999999, 0, '121-St Petersburg', '1970-01-01', '2026-03-10', '2026-03-06', 'silver', 'white', 'Theorema', 'Jonah Ndekugri', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.56.109.120', '172.56.109.120', '2026-03-10', '--', NULL),
(14938, 'T84755', 11949, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-03-10', '2026-02-24', 'black', 'black', 'Theorema', 'No Defect. No longer wanted.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '98.58.129.192', 'c-98-58-129-192.hsd1.fl.comcast.net', '2026-03-10', '--', NULL),
(14939, '', 11950, 999999999, 0, 'Choose option', '1970-01-01', '2026-03-11', '2026-03-11', 'Choose option', 'Choose option', 'Choose option', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '87.122.19.12', '87.122.19.12', '2026-03-11', '--', NULL),
(14940, 'T84926', 11951, 999999999, 0, 'GM 506-3', '2026-03-12', '2026-03-12', '2026-02-27', 'gold-braun', 'gold-braun', 'Pionier', '', '--', '0', '1970-01-01', '2026-03-12', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '79.239.46.123', 'p4fef2e7b.dip0.t-ipconnect.de', '2026-03-12', '--', ''),
(14941, 'T85061', 11952, 999999999, 0, '7002-Chicago', '1970-01-01', '2026-03-13', '2026-03-05', 'black', 'black', 'Pionier', 'returning the watch as the quality was not per expectation. The dial is heavy, and the golden rim has a plastic texture instead of high-quality material. \n\norder #: T85061 ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '99.234.101.14', 'pool-99-234-101-14.cpe.net.cable.rogers.com', '2026-03-13', '--', NULL),
(14942, 'P-511-5', 11953, 999999999, 0, '511-New York', '2026-04-13', '2026-03-14', '1970-01-01', 'black', 'bicolor', 'Pionier', 'Das Glas der Uhr ist beschlagen, wenn es mit der Kälte und der Wärme meines Arms in Kontakt kommt und ein teil von Uhr ist nicht Ordnung.Das Glas der Uhr ist trüb, als ob Luft\n eindringt', 'new movement, cleaned hands, cleaned dial, fixed crown protector- new screw, demag case,  1.01s, 0.34ms, 302.0°', '0', '1970-01-01', '1970-01-01', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '104.28.98.105', '104.28.98.105', '2026-03-14', '--', 'Please ship the watch back to Kathleen und Robert Brautzsch 43149. Hohenkrähenstrasse 22. Jestetten, 79798 Deutschland Thank you'),
(14943, 'T84845', 11954, 999999999, 0, '511-New York', '1970-01-01', '2026-03-14', '2026-03-15', 'silver', 'black', 'Pionier', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '88.130.152.155', 'i59F6B59B.versanet.de', '2026-03-14', '--', NULL),
(14944, 'T79586', 11955, 999999999, 0, '121-St Petersburg', '2026-03-20', '2026-03-15', '2025-05-20', 'rosé', 'silvgrey', 'Theorema', 'the watch doesn’t work even manually wound. ', 'this was the clients fault, pretty heavy bump, which you can also see on tjhe case. New movement, cleaned hands, cleaned case, new caseback screws, demag case, 5.92s , 0.24ms , 307.3°', '0', '2026-05-05', '2026-05-05', 1, 1, 0, 1, 0, 0, 1, 1, '2026-03-21 16:53:21', 1, '2026-03-21 16:53:21', 1, '2026-05-05 18:55:16', 1, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-03-15', '--', '');
INSERT INTO `watch` (`watchid`, `orderid`, `customer_id`, `receiptuser_id`, `altereduser_id`, `model`, `dateofreceipt`, `dateofinvoice`, `warranty`, `case`, `dial`, `brand`, `defectdescription`, `repairinfo`, `repairprice`, `dateofdispatch`, `dateoffinished`, `inprocess`, `control`, `waiting`, `finished`, `unfinished`, `defect`, `fetched`, `received_client`, `received_client_date`, `sent_repair_de`, `sent_repair_de_date`, `sent_shop_usa`, `sent_shop_usa_date`, `entrance`, `conveyed`, `conveyeddate`, `uip`, `uhost`, `week`, `sendnr`, `notes`) VALUES
(14945, '', 11956, 999999999, 0, '515-Amsterdam', '1970-01-01', '2026-03-16', '2025-02-15', 'gold', 'white', 'Pionier', 'The Date function does not advance automatically. I can set date manually after it has been out of the watch winder for 8 hours but still will not advance.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '50.96.17.30', 'h30.17.96.50.static.ip.windstream.net', '2026-03-16', '--', NULL),
(14946, 'T85179 ', 11957, 999999999, 0, '515-Amsterdam', '1970-01-01', '2026-03-17', '2026-03-18', 'gold', 'black', 'Pionier', 'Watch is brand new it is just too big on my wrist and arm', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '99.44.97.229', '99.44.97.229', '2026-03-17', '--', NULL),
(14947, 'T85068', 11958, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-03-17', '2026-03-17', 'gold', 'white', 'Theorema', 'Leather strap has a slight tear. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '64.109.254.91', '64.109.254.91', '2026-03-17', '--', NULL),
(14948, 'T84845', 11959, 999999999, 0, '511-New York', '2026-04-02', '2026-03-18', '2026-02-23', 'black', 'black', 'Pionier', 'Es ist eine wunderschöne Uhr, aber sie ist schwer am Handgelenk, und ihr Automatikwerk bleibt nachts stehen, wenn man sie abnimmt; sie hat keine Gangreserve.\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '87.122.19.0', '87.122.19.0', '2026-03-18', '--', ''),
(14949, 'T85014', 11960, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-03-19', '2026-03-18', 'gold', '', 'Theorema', 'Mind changed as it was a gift.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.191.36.35', 'c-73-191-36-35.hsd1.md.comcast.net', '2026-03-19', '--', NULL),
(14950, 'T85123', 11961, 999999999, 0, '511-New York', '1970-01-01', '2026-03-19', '2026-03-13', 'silver', 'black', 'Pionier', 'The day setting button depresses but the day hand is not moving. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '63.85.131.13', '63.85.131.13', '2026-03-19', '--', NULL),
(14951, 'Unknown', 11802, 999999999, 0, '4004-Newton', '2026-04-14', '2026-03-20', '1970-01-01', 'gold', 'gold', 'Theorema', 'This was sent in 3 months ago for the same issue. It has been tested in several watch N winders and stops after a couple of hours. Even without a watch Winder, it stops after a couple of hours. It does not last throughout its reserve. I will attach notes when I ship the watch in. The rotor does not seem to work when it’s in the winder and the watch stops prematurely within the winder.. Even outside the winder, the watch stops prematurely.\nThe former RMA is 14782.  It is a Newton diamonds watch gold with a brown strap.  It was sent in for the same issue and it is still unresolved.\n\nThank you\nEvan Marks', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-02 01:27:45', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '65.175.152.49', 'd-65-175-152-49.nh.cpe.atlanticbb.net', '2026-03-20', '--', 'He really wants to know what caused the issue with his watch and make sure that we test the watch for 2 weeks before sending it back to him\n'),
(14952, '81942', 11964, 999999999, 0, '106-Toronto GM', '1970-01-01', '2026-03-23', '2001-09-25', 'silver', 'bicolor', 'Theorema', 'Watch will not operate even when manually wound and shaken', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '75.182.19.20', 'syn-075-182-019-020.res.spectrum.com', '2026-03-23', '--', NULL),
(14953, 'T85001', 11965, 999999999, 0, '115-Helsinki', '1970-01-01', '2026-03-23', '2026-03-03', 'gold', '', 'Theorema', 'Keeps stopping regardless of recalibration   ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '146.75.245.141', '146.75.245.141', '2026-03-23', '--', NULL),
(14954, 'th1531', 11966, 999999999, 0, '505-Florida', '2026-04-13', '2026-03-23', '2026-02-02', 'black', 'black', 'Pionier', 'The  watch stops before 24 hours even manually wound', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-03-23 22:10:54', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-03-23', '--', ''),
(14955, 'G14-123-3', 11967, 999999999, 0, '123-Madame Butterfly', '1970-01-01', '2026-03-24', '2023-03-09', 'gold', 'blue', 'Theorema', 'Scratched glass. I would like to get the glass replaced.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '86.104.249.204', '204.249.104.86.baremetal.zare.com', '2026-03-24', '--', NULL),
(14956, 'T76162', 11968, 999999999, 0, 'Tourbillon P-Cairo', '2026-04-23', '2026-03-25', '2024-12-18', 'silver', 'black', 'Pionier', 'I CANNOT WIND THIS WATCH! THE CROWN IS TOO SMALL AND BADLY LOCATED ON THE LOWER RIGHT SIDE OF THE WATCH FOR ME TO SUCCESSFULLY TURN IT. I CAN TURN IT ONLY IF I WEAR A SPECIAL GLOVE--BUT EVEN THEN THE CROWN IS EXTREMELY HARD TO TURN.\nThe watch is the Lausanne Tourbillon by Pionier Germany - GM-905-2 |Silver with black-gold dial.\nNote that my reference number for the watch is GM 905-2 but that reference number is not listed as a choice above.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-10 01:07:45', 1, '2026-04-20 01:08:24', 0, NULL, 1, 0, '1970-01-01', '73.227.71.5', 'c-73-227-71-5.hsd1.ct.comcast.net', '2026-03-25', '--', ''),
(14957, 'T84259', 11969, 999999999, 0, '3001-Paragon', '2026-04-14', '2026-03-26', '2026-01-23', 'silver', 'black', 'Theorema', 'The crown fell off when I tried to set the time.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-02 01:26:42', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-03-26', '--', ''),
(14958, 'T47645 ', 8906, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-03-26', '2021-11-26', '', '', 'Theorema', 'The clasp of the crown needs to be repaired\nI would also like the band to be replaced.\n Please repair accordingly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '99.24.231.90', '99-24-231-90.lightspeed.irvnca.sbcglobal.net', '2026-03-26', '--', NULL),
(14959, 'T84941', 11970, 999999999, 0, 'other', '1970-01-01', '2026-03-26', '1970-01-01', 'black', 'black', 'other', 'T84941- The watch is brand new and unworn, please refund', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '146.75.200.10', '146.75.200.10', '2026-03-26', '--', NULL),
(14960, 'T21321', 11971, 999999999, 0, '101-Casablanca GM', '2026-03-27', '2026-03-27', '2026-03-28', 'silver', 'white', 'Theorema', ' dfaskdbsakdbaskj', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 1, '2026-03-27', '109.236.40.43', 'dynamic.pool-109-236-40-43.abissnet.al', '2026-03-27', '--', ''),
(14961, '', 11972, 999999999, 0, 'other', '1970-01-01', '2026-03-29', '1970-01-01', 'gold', 'white', 'other', 'Ressort spirale détérioré ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '77.133.250.122', '122.250.133.77.rev.sfr.net', '2026-03-29', '--', NULL),
(14962, 'T78556', 11973, 999999999, 0, '101-Casablanca GM', '2026-04-23', '2026-03-29', '2025-03-28', 'silver', 'blue', 'Theorema', 'My order number is T78556 - The watch has stopped working even fully wound. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-10 01:03:19', 1, '2026-04-20 01:09:42', 0, NULL, 1, 0, '1970-01-01', '50.4.27.38', 'd4-50-38-27.try.wideopenwest.com', '2026-03-29', '--', ''),
(14963, 'T85437', 11974, 999999999, 0, '505-Florida', '1970-01-01', '2026-03-30', '2026-03-30', 'gold', 'black', 'Pionier', 'My original Order # is T 85437.  I wish to exchange for GM-511-3.This is the Pioneer with the white face.  \n\n ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '45.25.0.94', '45.25.0.94', '2026-03-30', '--', NULL),
(14964, 'T84941', 11975, 999999999, 0, 'other', '1970-01-01', '2026-03-30', '2026-03-30', 'black', 'black', 'other', 'Perfect condition never used, return because the watch is too big', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.28.45.4', '104.28.45.4', '2026-03-30', '--', NULL),
(14965, ' #T83708', 11976, 999999999, 0, '108-Oman', '2026-04-23', '2026-03-31', '2025-12-28', 'black', 'black', 'Theorema', 'My watch suddenly stopped working, and I tried winding the crown by turning it 40 times, but nothing works. I\'m starting to think the watch mechanism is really poor quality.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-17 19:34:07', 1, '2026-04-20 01:00:40', 0, NULL, 1, 0, '1970-01-01', '173.178.39.182', 'modemcable182.39-178-173.mc.videotron.ca', '2026-03-31', '--', ''),
(14966, 'T81579', 11977, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-03-31', '2025-10-01', 'black', 'white', 'Theorema', 'je suis venu pour mettre la montre et l`aiguille a tombe\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.48.127.143', 'modemcable143.127-48-24.mc.videotron.ca', '2026-03-31', '--', NULL),
(14967, 'T47645', 11978, 999999999, 0, '101-Casablanca GM', '2026-04-23', '2026-03-31', '2021-11-26', 'white', 'blue', 'Theorema', 'The clasp of the crown needs to be repaired and the band replaced. Please repair accordingly and provide me a quote for price for the repair.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-10 00:41:27', 1, '2026-04-20 01:05:42', 0, NULL, 1, 0, '1970-01-01', '104.182.216.228', '104.182.216.228', '2026-03-31', '--', ''),
(14968, 'T78839', 11979, 999999999, 0, '117-Kingston', '2026-04-23', '2026-04-01', '2025-10-04', 'blue', 'gold', 'Theorema', 'The watch stopped working, no matter how much I wind it.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-10 01:15:42', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '204.76.191.249', '204.76.191.249', '2026-04-01', '--', ''),
(14969, 'T85001', 11980, 999999999, 0, '115-Helsinki', '2026-04-14', '2026-04-01', '2026-03-02', 'gold', 'silvgrey', 'Theorema', 'My Helsinki stops 10-15 min after being wound. Recalibration does not resolve it. The crown fell off. I have 21 watches from you folks. I expect great service. Thank you!', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-02 01:26:15', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-04-01', '--', ''),
(14970, 'T81942', 11981, 999999999, 0, 'Tourbillon T-Marrakesh', '2026-04-13', '2026-04-01', '2025-10-19', '', '', 'Theorema', 'does not wind. just stuck not working. i have 3 watches from you this just stopped working.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-02 01:26:31', 0, NULL, 0, NULL, 1, 0, '1970-01-01', '98.38.228.210', 'c-98-38-228-210.hsd1.co.comcast.net', '2026-04-01', '--', ''),
(14971, 'P1068', 11982, 999999999, 0, '502-Malibu', '1970-01-01', '2026-04-02', '1970-01-01', '', '', 'Pionier', ' I ordered the wrong parts. I need black hands for the watch and black leather band with silver clasp for the GM-503 Sydney', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.28.114.7', '104.28.114.7', '2026-04-02', '--', NULL),
(14972, 'T75672', 11983, 999999999, 0, '106-Toronto GM', '1970-01-01', '2026-04-03', '2024-12-07', 'gold', 'gold', 'Theorema', 'RMA 14190- The watch is fully wound but has stopped working again. Please replace the movemen.\nThis is the second time has happened. \nI\'m not happy. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '88.97.210.16', '88.97.210.16', '2026-04-03', '--', NULL),
(14973, 'T85225', 11984, 999999999, 0, '7001-Havana', '1970-01-01', '2026-04-03', '1970-01-01', 'gold', 'white', 'Pionier', 'Too bulky for my taste. Also, did not like that it is a winding watch, rather than a battery watch. With wearing various watches each day, the dates, days, etc. have to be reset every time I would wear the watch.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '69.119.62.14', 'ool-45773e0e.dyn.optonline.net', '2026-04-03', '--', NULL),
(14974, 'T85432 ', 11985, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-03', '2026-04-03', 'gold', 'white', 'Theorema', 'no defect - 2 watches', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.205.248.32', 'c-71-205-248-32.hsd1.co.comcast.net', '2026-04-03', '--', NULL),
(14975, 'T85510', 11986, 999999999, 0, '505-Florida', '1970-01-01', '2026-04-03', '2026-04-01', 'gold', '', 'Pionier', 'There is no defect - my father thinks its too heavy and does not like it. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '50.89.194.20', 'syn-050-089-194-020.res.spectrum.com', '2026-04-03', '--', NULL),
(14976, 'T85492', 11987, 999999999, 0, '108-Oman', '1970-01-01', '2026-04-03', '2026-04-01', 'gold', 'black', 'Theorema', 'I do not like this model and wish to return it', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '100.0.53.40', 'pool-100-0-53-40.bstnma.fios.verizon.net', '2026-04-03', '--', NULL),
(14977, '#T85507 ', 11988, 999999999, 0, 'Tourbillon T-Marrakesh', '1970-01-01', '2026-04-04', '1970-01-01', 'silver', 'bicolor', 'Theorema', '', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.46.40.53', 'ool-182e2835.dyn.optonline.net', '2026-04-04', '--', NULL),
(14978, 'T85551', 11989, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-05', '2026-05-04', 'rosé', 'white', 'Theorema', 'Deploysnt clasp impossible to deploy even after showing it to a jeweler.and it doesn’t run more than a few minutes. So that’s not acceptable ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '146.75.244.1', '146.75.244.1', '2026-04-05', '--', NULL),
(14979, 'T67971', 11990, 999999999, 0, '123-Madame Butterfly', '1970-01-01', '2026-04-06', '2024-01-10', 'gold', 'gold', 'Theorema', ' [My Order number T67971- The crown has fallen off. Please repair accordingly.}', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-05-03 21:06:24', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '84.39.151.212', '84.39.151.212', '2026-04-06', '--', ''),
(14980, 'T85551', 11991, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-06', '2026-04-17', 'rosé', 'white', 'Theorema', 'The deployant clasp is difficult to use AND the watch runs just a few minutes after winding.  Not as expected', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.28.55.252', '104.28.55.252', '2026-04-06', '--', NULL),
(14981, 'T84941', 11992, 999999999, 0, 'other', '2026-04-29', '2026-04-07', '2026-04-07', 'black', 'black', 'other', 'I bought as a gift to my dad but its too big at hurting his hands he have only tried it on, its still brand new with the protecting plastic etc ', '--', '0', '1970-01-01', '2026-04-29', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '91.100.223.63', '91.100.223.63.generic-hostname.arrownet.dk', '2026-04-07', '--', ''),
(14982, 'T85504', 11993, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-08', '2026-03-30', 'silver', '', 'Theorema', 'Band is too small for my wrist and I a not able to read the dial. \nThe information above for dial color does not offer green as an option so it was left blank.  Order ID T85504', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.92.239.12', '172.92.239.12', '2026-04-08', '--', NULL),
(14983, '#T85530', 11994, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-09', '2026-04-01', 'gold', 'white', 'Theorema', 'Damage to the glass. See previous emails.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '77.63.74.8', '77-63-74-8.mobile.kpn.net', '2026-04-09', '--', NULL),
(14984, '#T85530', 11995, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-09', '2026-04-01', 'gold', 'white', 'Theorema', 'Damage to the glass. See previous emails.\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '77.63.74.8', '77-63-74-8.mobile.kpn.net', '2026-04-09', '--', NULL),
(14985, '#T85530', 11996, 999999999, 0, '101-Casablanca GM', '2026-04-23', '2026-04-09', '2026-04-01', 'gold', 'white', 'Theorema', 'damage to the glass.\nsee previous emails.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '84.83.63.123', '84-83-63-123.fixed.kpn.net', '2026-04-09', '--', ''),
(14986, 'T84924', 11997, 999999999, 0, '117-Kingston', '2026-04-23', '2026-04-10', '2026-02-02', 'gold', 'gold', 'Theorema', 'My order number is T84924, The button is dislocated. Please repair accordingly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-04-20 00:29:39', 1, '2026-04-20 00:59:05', 0, NULL, 1, 0, '1970-01-01', '136.174.187.5', 'mypinellas.org', '2026-04-10', '--', ''),
(14987, 'T85368', 11998, 999999999, 0, '112-Madrid', '1970-01-01', '2026-04-10', '1970-01-01', 'rosé', 'gold', 'Theorema', 'I don\'t like the watch.The watch is brand new and never worn. Please refund', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '45.91.115.241', '45.91.115.241', '2026-04-10', '--', NULL),
(14988, 'T85663 and T85662', 11999, 999999999, 0, '102-Monte Carlo GM', '1970-01-01', '2026-04-10', '2026-04-10', 'silver', 'gold', 'Theorema', 'New ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.58.183.204', '172.58.183.204', '2026-04-10', '--', NULL),
(14989, 'T85713', 11359, 999999999, 0, '511-New York', '1970-01-01', '2026-04-11', '2026-04-09', 'gold', 'gold', 'Pionier', 'T85713: The watch is brand new and never worn. Unfortunately, I do not like the watch; it\'s too heavy and big. Please refund, and I would like to exchange it for another model of watch. \n\nThank You\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '86.29.54.241', 'cpc89262-grnk8-2-0-cust5872.14-2.cable.virginm.net', '2026-04-11', '--', NULL),
(14990, ' Order #T85673', 12000, 999999999, 0, '503-Sydney', '1970-01-01', '2026-04-13', '1970-01-01', 'black', 'black', 'Pionier', 'NO DEFECT - JUSRT TOO BIG FOR MY WRIST NOTHING WRONG WITH THE WATCH.\n\n I JUTS OPENED IT TO TRY THE WATCH BUT TOO BIG FOR ME.\n\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '63.247.190.162', '3ff7bea2.cst.lightpath.net', '2026-04-13', '--', NULL),
(14991, 'D1061', 12001, 999999999, 0, '510-London', '1970-01-01', '2026-04-13', '2026-11-22', 'gold', 'bicolor', 'Pionier', 'I am writing to request a warranty claim for my Tufina watch, which has unfortunately stopped working despite normal usage and proper care.\n\nOrder Details:\n\nOrder Number: D1061\nModel: London Diamonds Pionier GM-510-3\nReference: GM 510-3\nDate of Purchase: 22 November 2024\n\nThe watch was functioning properly until recently, but it has now completely stopped working.\n\nKindly advise me on the next steps to proceed with repair or replacement under the warranty.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-05-03 23:05:06', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '142.112.163.128', 'bras-base-toroon5049w-grc-19-142-112-163-128.dsl.bell.ca', '2026-04-13', '--', 'The box arrived broken'),
(14992, 'T79816', 12003, 999999999, 0, '902-Geneva', '2026-04-30', '2026-04-15', '2025-06-03', 'blue', 'blue', 'Pionier', 'Running way too fast. Send photo where it was 4 hours and 19 min faster in 6 days.\nPurchased in june 3. 2025. Delivered june 6th. Not opened until sept 2025. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '89.11.161.117', '117.89-11-161.customer.lyse.net', '2026-04-15', '--', ''),
(14993, 'T85691', 12004, 999999999, 0, 'other', '1970-01-01', '2026-04-15', '2026-04-08', 'silver', 'white', 'other', 'No defect just exchange.  Order number:  T85691 for exchange for GM108-5', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '71.205.247.217', '71.205.247.217', '2026-04-15', '--', NULL),
(14994, 'T85746', 12005, 999999999, 0, '103-Sao Paulo', '1970-01-01', '2026-04-15', '2026-05-14', 'silver', 'black', 'Theorema', 'No defect, never worn. Wife did not like it.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '63.143.185.13', 'ool-3f8fb90d.dyn.optonline.net', '2026-04-15', '--', NULL),
(14995, 'T83129', 12006, 999999999, 0, '117-Kingston', '1970-01-01', '2026-04-16', '1970-01-01', 'black', 'white', 'Theorema', 'Buongiorno. L\'orologio NO shock da urto. Orologio in ottime condizioni e funziona .Non mi sono mai accorto della mancanza della lancetta che segna i giorni. Forse si è staccata, i professionisti siete voi, Mi piace molto e spero di rimetterlo al polso presto. Ed anche acquistarne un\' altro x mio figlio. Inoltre se avete qualche gadget mi piacerebbe riceverlo per donarlo a chi ne ha più bisogno.\nDistinti Saluti. \n\nCremon Alessandro', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '83.98.92.171', '83.98.92.171', '2026-04-16', '--', NULL),
(14996, 'T83129', 12007, 999999999, 0, '117-Kingston', '2026-04-24', '2026-04-16', '2025-12-10', 'black', 'white', 'Theorema', 'Buonasera, NO shock da urto . Orologio in ottime condizioni e funzionante. Non mi sono mai accorto. Lancetta che indica i giorni assente. Attendo vostre. Spedisco con corriere espresso. Distinti saluti. Alessandro\n\nGuten Abend, kein Schock durch Schlag. Uhr in ausgezeichnetem Zustand und funktionsfähig. Ich habe es nie bemerkt. Zeiger, der die Tage anzeigt, fehlt. Ich warte auf Ihre Rückmeldung. Versand mit Expresskurier. Mit freundlichen Grüßen, Alessandro', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '5.102.26.98', '5.102.26.98', '2026-04-16', '--', ''),
(14997, 'T85755', 12008, 999999999, 0, '515-Amsterdam', '2026-04-21', '2026-04-16', '2026-04-13', 'gold', 'blue', 'Pionier', 'T85755 – The watch is too big. The watch is brand new and unworn, please refund my payment in full.', '--', '0', '1970-01-01', '2026-04-21', 0, 0, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '83.168.77.138', '83-168-77-138.static.ipv4.korbank.pl', '2026-04-16', '--', ''),
(14998, 'T83627', 12009, 999999999, 0, '3011-Macau', '1970-01-01', '2026-04-16', '2025-12-22', 'black', '', 'Theorema', 'The minute hand is moving faster about 15 minutes', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '69.136.203.3', 'c-69-136-203-3.hsd1.ga.comcast.net', '2026-04-16', '--', NULL),
(14999, '', 12010, 999999999, 0, '506-Miami', '1970-01-01', '2026-04-17', '2025-10-29', 'black', 'black', 'Pionier', 'Its not working enymore', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '178.226.252.176', '178.226.252.176', '2026-04-17', '--', NULL),
(15000, '', 12011, 999999999, 0, '506-Miami', '1970-01-01', '2026-04-17', '2025-11-29', 'black', 'black', 'Pionier', 'Its not working enymore', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '178.230.132.96', '178.230.132.96', '2026-04-17', '--', NULL),
(15001, 'GM101-11', 12012, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-20', '2024-07-12', '', 'black', 'Theorema', 'Recently has had condensation under the crystal portion of the watch-face. Occurs with rapid changes in temperature (ie air conditioning, indoors)', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '101.115.68.184', '101.115.68.184', '2026-04-20', '--', NULL),
(15002, 'TH1528', 12013, 999999999, 0, 'GM115-10', '2026-04-20', '2026-04-20', '2026-02-06', 'gold', 'white-gold', 'Theorema', 'Krone ist rausgefallen.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '80.130.212.107', 'p5082d46b.dip0.t-ipconnect.de', '2026-04-20', '--', ''),
(15003, 'T85168', 12014, 999999999, 0, '511-New York', '1970-01-01', '2026-04-22', '2026-03-10', 'gold', 'black', 'Pionier', 'My order number is T85168. The decorative screws keep falling from the outer bezel. Please replace-repair accordingly.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-05-03 20:41:10', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '99.9.198.251', '99.9.198.251', '2026-04-22', '--', ''),
(15004, 'T85799', 12015, 999999999, 0, '7001-Havana', '2026-04-27', '2026-04-22', '2026-04-14', 'silver', 'white', 'Pionier', 'Mon numéro de commande est T85799- La couronne est tombée dès que j\'ai réglé l\'heure. La montre est encore toute neuve. \n\nMeine Bestellnummer ist T85799 - Die Krone ist abgefallen, sobald ich die Uhrzeit eingestellt habe. Die Uhr ist noch ganz neu.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 1, 0, '1970-01-01', '80.15.184.168', '80-15-184-168.ftth.fr.orangecustomers.net', '2026-04-22', '--', ''),
(15005, '', 12016, 999999999, 0, '3011-Macau', '1970-01-01', '2026-04-22', '2025-12-22', 'black', 'gold', 'Theorema', 'Watch is not keeping the right time', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-05-03 20:47:46', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.59.64.245', '172.59.64.245', '2026-04-22', '--', ''),
(15006, 'T85347', 12017, 999999999, 0, '103-Sao Paulo', '1970-01-01', '2026-04-24', '2026-03-03', 'gold', 'white', 'Theorema', 'The time piece runs 3 hours fast in a 24 hour day.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '99.64.93.30', '99.64.93.30', '2026-04-24', '--', NULL),
(15007, 'T85205', 12018, 999999999, 0, '123-Madame Butterfly', '1970-01-01', '2026-04-24', '2026-03-18', 'blue', 'gold', 'Theorema', 'The watch is delaying even when manually wound. Please replace/ repair accordingly', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '108.28.120.21', 'pool-108-28-120-21.washdc.fios.verizon.net', '2026-04-24', '--', NULL),
(15008, '', 12019, 999999999, 0, '7001-Havana', '1970-01-01', '2026-04-25', '1970-01-01', 'black', 'gold', 'Pionier', 'Just not working ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '162.154.100.45', 'syn-162-154-100-045.res.spectrum.com', '2026-04-25', '--', NULL),
(15009, '558446775 / Groupon', 12020, 999999999, 0, '505-Florida', '1970-01-01', '2026-04-25', '2018-03-16', 'silver', 'white', 'Pionier', 'First problem I have that even if I use the watch for long time lets say 1 full day and I take it off it stops within max 1 hours ! It used to stay much longer .\n\nSecond problem suddenly the Date Frame on the dial fall down and got stuck inside the watch mechanism .\n\nThird problem is with the strap Its lose from the lock side and I try to push the small scree but it pops up everytime', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '104.28.45.5', '104.28.45.5', '2026-04-25', '--', NULL),
(15010, 'T70616.', 12021, 999999999, 0, '901-Zurich', '1970-01-01', '2026-04-25', '2024-05-23', 'gold', 'black', 'Theorema', 'My order number is T70616. The watch keeps stopping randomly even when fully wound. Every time I wind it, it starts working and then stops again in 5 to 10 minutes. When you receive it, it will be fully wound and stopped. It is under warranty and I would like it repaired or replaced.\n\nAlso, while it is opened for repair, I would like to inquire if you can exchange the dial. From the 901-3 gold/black dial I have to a 901-2 all gold dial. Since it is opened for repair, I would think this is possible. Can you let me know how much this change would cost?\n\n', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 1, '2026-05-03 20:33:34', 0, NULL, 0, NULL, 0, 0, '1970-01-01', '173.77.194.182', 'pool-173-77-194-182.nycmny.fios.verizon.net', '2026-04-25', '--', 'He already paid for the band order T85389. Please replace it on his watch. Thanks'),
(15011, '', 12022, 999999999, 0, '108-Oman', '1970-01-01', '2026-04-27', '2024-04-01', 'blue', 'black', 'Theorema', 'The Crown my watch will continue to turn when I try to set it.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '107.196.199.216', '107-196-199-216.lightspeed.irvnca.sbcglobal.net', '2026-04-27', '--', NULL),
(15012, 'T71327', 12023, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-04-29', '2024-07-05', 'gold', 'white', 'Theorema', 'The watch no longer works. I have reached out to support via e-mail and tried the recommended \"shake 15 times\" but nothing is moving at all.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '121.45.78.253', '121-45-78-253.tpgi.com.au', '2026-04-29', '--', NULL),
(15013, '#T62543', 12024, 999999999, 0, '505-Florida', '1970-01-01', '2026-04-29', '1970-01-01', 'gold', 'blue', 'Pionier', '1. The watch strap is broken.\n2. The hands have stopped moving.\n3. Part of the coating has peeled off.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '202.82.32.109', '202.82.32.109', '2026-04-29', '--', NULL),
(15014, 'T85838', 12025, 999999999, 0, '108-Oman', '1970-01-01', '2026-04-30', '2026-04-16', 'black', 'gold', 'Theorema', 'My Order Number T85838.I DO NOT LIKE THE WATCH. The wrist band was too lose and felt cheap.the watch itself was too big and I couldn\'t use my hand properly. Please refund me as soon as possible.', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '24.128.193.81', 'c-24-128-193-81.hsd1.mi.comcast.net', '2026-04-30', '--', NULL),
(15015, '#T70350', 12026, 999999999, 0, '7001-Havana', '1970-01-01', '2026-05-01', '2026-05-31', 'silver', 'black', 'Pionier', 'the hands or whatever they call it is not moving! its stuck and the buttons do not work anymore!! I CANNOT CHANGE DATES THE CORRECT WAY MORE IMPORTANTLY THEY ARE EITHER BOTH NUMBER DATES IN BETWEEN 2 NUMBERS OR ITS SOMEHOW THE 63RD DAY OF THE MONTH HAHA! I THOUGHT I CANNOT BE FIXED AND NEVER SAID ANYTHING ABOUT IT ! BUT IF I CAN ! I AM SENDING IT YOUR WAY SOON!! PLEASE LOOK INTO IT ! IT DID NOT EVEN FALL OFF MY HAND AND THAT HAPPENED! SUCH A BUMMER ! I THOUGHT ITS JUST SOMETHING THAT HAPPENS TO IT AND NEVER LOOKED INTO IT AGAIN! PLEASE HAVE IT FIXED I LOVE THE WATCH!', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '83.110.198.19', 'bba-83-110-198-19.alshamil.net.ae', '2026-05-01', '--', NULL),
(15016, 'T85866.', 10999, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-05-01', '2026-04-21', 'gold', 'blue', 'Theorema', 'Casablanca Theorems the case color is yellow gold the dial is crystal. It has no power reserve. It only works for about an hour after wound per instructions. ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '50.158.172.213', 'ip50-158-172-213.lv.lv.cox.net', '2026-05-01', '--', NULL),
(15017, 'T85218', 12027, 999999999, 0, '107-Rio', '1970-01-01', '2026-05-02', '2026-03-13', 'black', 'silvgrey', 'Theorema', 'When he washed his hands, the watch got wet under the faucet, and it caused condensation inside the watch, after it dried out, it left a film inside on the glass or lens. so I’m guessing the seal is not tight in there, and it’s gonna need a new lens or the lens to be cleaned because it’s cloudy now it may look clear inside, but if you go outside in the bright light, you can see the film on it. Yeah all he did is wash his hands and having the watch under some running water shouldn’t have made it leak because it wasn’t submerged. He just was washing his hands.\n                Thank you very much !\n                        Colette Petri ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.59.97.160', '172.59.97.160', '2026-05-02', '--', NULL),
(15018, '#T73956', 12028, 999999999, 0, '108-Oman', '1970-01-01', '2026-05-03', '2024-10-28', 'gold', 'gold', 'Theorema', 'The crown protector has fallen off', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '172.3.184.58', '172-3-184-58.lightspeed.sntcca.sbcglobal.net', '2026-05-03', '--', NULL),
(15019, '', 12029, 999999999, 0, '111-Copenhagen', '1970-01-01', '2026-05-05', '2025-11-24', 'black', 'gold', 'Theorema', 'Gears not working, looks like something fell apart inside ', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '73.169.44.100', 'c-73-169-44-100.hsd1.co.comcast.net', '2026-05-05', '--', NULL),
(15020, 'No warranty and it’s been a long time ago', 12030, 999999999, 0, '101-Casablanca GM', '1970-01-01', '2026-05-05', '2025-11-01', 'silver', 'white', 'Theorema', 'Hi dear , Kindly if your team could please replace Wrist band with an identical one , metallic silver and the face of the watch which is slightly scratched it would be greatly appreciate . Thank you !', '--', '0', '1970-01-01', '1970-01-01', 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, '1970-01-01', '80.233.38.115', '80.233.38.115', '2026-05-05', '--', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`customerid`);

--
-- Indexes for table `uploadliste`
--
ALTER TABLE `uploadliste`
  ADD PRIMARY KEY (`uploadlisteid`);

--
-- Indexes for table `uploadliste_test`
--
ALTER TABLE `uploadliste_test`
  ADD PRIMARY KEY (`uploadlisteid`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `watch`
--
ALTER TABLE `watch`
  ADD PRIMARY KEY (`watchid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `customerid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12031;

--
-- AUTO_INCREMENT for table `uploadliste`
--
ALTER TABLE `uploadliste`
  MODIFY `uploadlisteid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483648;

--
-- AUTO_INCREMENT for table `uploadliste_test`
--
ALTER TABLE `uploadliste_test`
  MODIFY `uploadlisteid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `watch`
--
ALTER TABLE `watch`
  MODIFY `watchid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15021;
COMMIT;

