Sql © Chucky Credits Meucashback.com Database
- Thread starter
- Administrator
- Moderator
- Thread Author
- #1
INSERT INTO `coupons` (`id`, `title`, `description`, `store_id`, `code`, `admin_notes`, `link`, `is_affiliate_link`, `cats`, `is_featured`, `created_mode`, `network_id`, `network_coupon_id`, `start_date`, `expiry_date`, `status`, `clicks`, `created_at`, `updated_at`) VALUES
(6984, '{\"pt\": \"Kits Especiais de Dia Das Mães\"}', '{\"pt\": \"KITS Para Presentear com Descontos Exclusivos. Uma Seleção de Presentes para Você Surpreender nesse Dia das Mães!\"}', 103, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"344\", \"44\", \"51\", \"69\", \"70\", \"248\", \"246\", \"247\"]', 0, 'network', 4, '1252639', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6985, '{\"pt\": \"10% off no Site da Targus\"}', '{\"pt\": \"10% de Desconto no site da Targus utilizando o cupom. Uso único por CPF.,terms :Uso único por cpf válido para todo o site de 10% de desconto.\"}', 170, 'AFILIADOTARGUS', NULL, 'You must be logged in to see this link.', 1, '[\"106\"]', 0, 'network', 4, '1252629', '2021-04-28', '2021-12-31', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6986, '{\"pt\": \"Ofertas infantis para a Mamãe.\"}', '{\"pt\": \"Produtos com até 25% de desconto. + R$ 25 de desconto e Frete Grátis para todo o Brasil. Cupom: QUERO25. Aproveite!\"}', 118, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252613', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6987, '{\"pt\": \"Ser mãe: A beleza do cuidado.\"}', '{\"pt\": \"Produtos com descontos de até 50% + R$ 25 de desconto. Cupom: QUERO25 Aproveite!\"}', 118, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252611', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6988, '{\"pt\": \"Ser mãe: A beleza do cuidado.\"}', '{\"pt\": \"Produtos com descontos de até 50%. Aproveite!\"}', 122, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252607', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6990, '{\"pt\": \"Nossos livros favoritos na progressiva: 1 com 15% off, 2 ou mais com 20% off\"}', '{\"pt\": \"Nossos livros favoritos na progressiva: 1 com 15% off, 2 ou mais com 20% off no cupom MAISLIVROS,terms :Na compra de 1 item da seleção 15% off; 2 ou mais com 20% off no cupom MAISLIVROS. Válido para itens vendidos e entregues pela Americanas.com até às 23h59 do dia 02/05 ou para os primeiros 1000 pedidos.\"}', 140, 'MAISLIVROS', NULL, 'You must be logged in to see this link.', 1, '[\"164\"]', 0, 'network', 4, '1252201', '2021-04-28', NULL, 'publish', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6991, '{\"pt\": \"Especial Gama Dia das Mães.\"}', '{\"pt\": \"Descontos de até 50% + frete grátis para SP e RJ nas compras acima de R$ 199. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252145', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6992, '{\"pt\": \"Dia das Mãe com L\'occitane.\"}', '{\"pt\": \"Kits & Presentes a partir de R$29,00. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252143', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6993, '{\"pt\": \"Pharmaton Energy\"}', '{\"pt\": \"Pharmaton Energy com 70% de desconto na 2ª unidade\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252141', '2021-04-28', '2021-04-30', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6994, '{\"pt\": \"Ofertas infantis para a Mamãe\"}', '{\"pt\": \"Produtos com até 25% de desconto. + R$ 25 de desconto e Frete Grátis para todo o Brasil. Cupom: QUERO25. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252135', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6995, '{\"pt\": \"Ser mãe: A beleza do cuidado.\"}', '{\"pt\": \"Produtos com descontos de até 50% + R$ 25 de desconto Cupom: QUERO25. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252133', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6996, '{\"pt\": \"Controle sua Diabetes.\"}', '{\"pt\": \"Produtos Accu Check com até 25% de desconto\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252119', '2021-04-28', '2021-04-30', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6997, '{\"pt\": \"Zinzane - Frete Grátis acima de R$ 250,00 em compras para Sul e Sudeste. \"}', '{\"pt\": \"Frete Grátis acima de R$ 250,00 em compras para Sul e Sudeste. \"}', 302, 'SEUFRETE ', NULL, 'You must be logged in to see this link.{aid}&sskey={sskey}', 1, '[\"12\"]', 0, 'network', 3, '147234', '2021-04-28', '2021-04-30', 'draft', 0, '2021-04-29 12:00:17', '2021-04-29 12:00:17'),
(6998, '{\"pt\": \"TECHMANIA | $5 OFF em compras a partir de $50\"}', '{\"pt\": \"Válido até 30.04.2021\\r\\nRegras: Código promocional obrigatório.\\r\\nA oferta está disponível somente para entregas para o Brasil.\\r\\nO código promocional só se aplica aos itens da página do link.\\r\\nO código promocional pode ser usado uma vez em cada compra.\\r\\nOferta com tempo limitado. Quantidade limitada.\\r\\nEncontre mais informações sobre como usar o código promocional na página.\"}', 171, 'TECH5', NULL, 'You must be logged in to see this link.', 1, '[\"412\"]', 0, 'network', 2, '372212', '2021-04-29', '2021-05-01', 'draft', 0, '2021-04-29 09:00:30', '2021-04-29 09:00:30'),
(6999, '{\"pt\": \"TECHMANIA | $5 OFF em compras a partir de $30 para NOVOS COMPRADORES\"}', '{\"pt\": \"Válido até 30.04.2021\\r\\nRegras: Código promocional obrigatório.\\r\\nA oferta está disponível somente para entregas para o Brasil.\\r\\nO código promocional só se aplica aos itens da página do link.\\r\\nO código promocional pode ser usado uma vez em cada compra.\\r\\nOferta com tempo limitado. Quantidade limitada.\\r\\nEncontre mais informações sobre como usar o código promocional na página.\"}', 171, 'AETECH5NEW', NULL, 'You must be logged in to see this link.', 1, '[\"412\"]', 0, 'network', 2, '372211', '2021-04-29', '2021-05-01', 'draft', 0, '2021-04-29 09:00:30', '2021-04-29 09:00:30'),
(7000, '{\"pt\": \"TECHMANIA | $29 OFF em compras a partir de $199\"}', '{\"pt\": \"Válido até 30.04.2021\\r\\nRegras: Código promocional obrigatório.\\r\\nA oferta está disponível somente para entregas para o Brasil.\\r\\nO código promocional só se aplica aos itens da página do link.\\r\\nO código promocional pode ser usado uma vez em cada compra.\\r\\nOferta com tempo limitado. Quantidade limitada.\\r\\nEncontre mais informações sobre como usar o código promocional na página.\"}', 171, 'techgenbr', NULL, 'You must be logged in to see this link.', 1, '[\"406\", \"407\", \"408\", \"409\", \"410\", \"411\", \"412\"]', 0, 'network', 2, '372210', '2021-04-29', '2021-05-01', 'draft', 0, '2021-04-29 09:00:30', '2021-04-29 09:00:30'),
INSERT INTO `clicks` (`id`, `code`, `click_time`, `store_id`, `user_id`, `cashback_enabled`, `cashback_type`, `cashback_percent`, `referral_enabled`, `referral_percent`, `can_claim`, `confirm_duration`, `original_link`, `redirect_link`, `user_cashback_id`, `network_id`, `network_campaign_id`, `source_type`, `source_id`, `extra_info`, `ip_address`, `user_agent`, `http_referrer`) VALUES
(33378, 'bXvfUJ0byy', '2022-07-07 21:04:46', 986, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '30049', 'coupon', '32357', '{\"params\": []}', '66.249.66.75', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33379, '2aXbCdo2xH', '2022-07-07 21:19:46', 668, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 5, '43288', 'coupon', '4079', '{\"params\": []}', '66.249.66.89', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33380, 'uALhc2hU1h', '2022-07-07 21:19:48', 668, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 5, '43288', 'coupon', '2674', '{\"params\": []}', '66.249.66.46', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33381, '53PcUp2y2v', '2022-07-07 21:22:33', 186, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '17713', 'store', '186', '{\"params\": []}', '114.119.145.169', 'Mozilla/5.0 (Linux; Android 7.0
AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+You must be logged in to see this link.)', 'You must be logged in to see this link.'),
(33382, 'NvjpcCQkKq', '2022-07-07 21:31:34', 875, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '26051', 'store', '875', '{\"params\": []}', '114.119.145.163', 'Mozilla/5.0 (Linux; Android 7.0 AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+You must be logged in to see this link.)', 'You must be logged in to see this link.'),
(33383, 'zDiolQwFsg', '2022-07-07 21:34:48', 882, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '25279', 'coupon', '26566', '{\"params\": []}', '66.249.66.131', 'Mozilla/5.0 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33384, 'xnKqe9FfK0', '2022-07-07 21:35:35', 171, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '17648', 'store', '171', '{\"params\": []}', '51.222.253.13', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +You must be logged in to see this link.)', NULL),
(33385, 'PkcDpQOgrH', '2022-07-07 21:40:43', 775, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 8, '22193', 'deal', '3', '{\"params\": []}', '114.119.145.163', 'Mozilla/5.0 (Linux; Android 7.0 AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+You must be logged in to see this link.)', 'You must be logged in to see this link.'),
(33386, 'VDN8xsoC6r', '2022-07-07 22:02:37', 905, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 3, '51495', 'store', '905', '{\"params\": []}', '51.222.253.15', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +You must be logged in to see this link.)', NULL),
INSERT INTO `campaigns` (`id`, `network_id`, `network_campaign_id`, `campaign_name`, `name`, `website`, `domains`, `domain_name`, `affiliate_link`, `deeplink_format`, `deeplink_allowed`, `offer_id`, `group_id`, `mapping_type`, `description`, `restriction`, `logo`, `categories`, `currency`, `country`, `countries`, `cr`, `epc`, `campaign_status`, `campaign_type`, `status`, `extra_information`, `raw_categories`, `raw_commission`, `rating`, `stats`, `start_date`, `end_date`, `ignored`, `initialize`, `found_batch_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(22432, 4, '29823', 'Awin Affiliation Programme', 'Awin Affiliation Programme', 'You must be logged in to see this link.', NULL, 'learntradeskills.co.uk', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GBP', 'GB', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-10 23:01:16', '2022-09-25 23:03:16', NULL),
(22433, 4, '26919', 'The Mountain UK', 'The Mountain UK', 'You must be logged in to see this link.', NULL, 'themountain.com', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GBP', 'GB', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-11 23:01:30', '2022-09-25 23:03:05', NULL),
(22434, 4, '26925', 'The Mountain EU', 'The Mountain EU', 'You must be logged in to see this link.', NULL, 'themountain.com', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EUR', 'IE', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-11 23:01:30', '2022-09-25 23:03:05', NULL),
(22435, 4, '28691', 'The Couture Club', 'The Couture Club', 'You must be logged in to see this link.', NULL, 'thecoutureclub.com', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GBP', 'GB', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-11 23:01:32', '2022-09-25 23:03:12', NULL),
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('yKO0AdFhvM4LurxdGwzLsGUPlR2HmP0Q52XUdydT', NULL, '185.191.171.36', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRFZxMDdlMnpYckhKZ3l1ZkRkREtEUmQwTHl1QlU0SmtxZk52YnM3MiI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjYxOiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9zdG9yZS1jYXRlZ29yeS9tb3RvcmJpa2UtaW5zdXJhbmNlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1624219071),
('YKo365ditsWEPni3AGlO0tdkmXEt9GFKzgMezdu7', NULL, '66.249.69.136', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.80 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib0VLUWxtM2E0N0oweUhYVHVRdnZRQmhaQWw4ZjBYUFU3emZDWW85YyI7czo2OiJsb2NhbGUiO3M6MjoicHQiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjIzOiJodHRwczovL21ldWNhc2hiYWNrLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1619068021),
('yKpdGfs2jx93Xo2LCFkVIw2zJsp8qKWWqem8faQi', NULL, '207.46.13.34', 'Mozilla/5.0 (compatible; bingbot/2.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaXJJandFdnhuY21DMjBId3FQbjUwM0J2S2U3aFdKUXJwdFIxN0kyUyI7czo2OiJsb2NhbGUiO3M6MjoicHQiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ4OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9jYXRlZ29yaWEtbG9qYS9lbi1jbGllbnQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1619649522),
('YKrXyk3Yqfdki6Kq6b0FrU99iEdpqeOQv5L029SE', NULL, '162.55.86.60', 'Mozilla/5.0 (compatible; BLEXBot/1.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMndlUlZrZXJ0Q3dscTVoeGxwVnFQSGUwT1ZxbnFCWE9sdEgycEhIdiI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU2OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9zdG9yZS1jYXRlZ29yeS9idXNpbmVzcy1sb2FucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1623544676),
('Yksve8ZIXtUCxoEiw9UHsfNfHWIW1Je8JurUrQ4M', NULL, '162.55.86.60', 'Mozilla/5.0 (compatible; BLEXBot/1.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOEF5dVh2d1hHOEpxY3E0VWFENGlNRHpXQUlFOWx5aEIyTGxtckhUcyI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU4OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9jb3Vwb24tY2F0ZWdvcnkvYm9va3MtbWFnYXppbmVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1623544080),
('YkTgTr5Uwqq7j76AK4y4PxlucbfIalzNOOrRAMlt', NULL, '185.191.171.2', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVjJGYjdZbWJkU01IMUNSZjk3ZVZ0S1NsQ1lGb21maUhVNzU0N0kySCI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU3OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9zdG9yZS1jYXRlZ29yeS9lbi1jcmVkaXQtY2FyZHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1624689998),
('yKuGTsxvedtg1Bef1sKo9CHSrQ2IFD1O83pKW9Ha', NULL, '185.191.171.5', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS0I0MkVPUkhxZnl4elNvUGlrcmsydWZZbUtWcUF0Y2l0V05VNlBCRSI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjcwOiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9jb3Vwb24tY2F0ZWdvcnkvY2FibGVzLXBhcnRzLXBvd2VyLXN1cHBsaWVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1621248870),
('YKwd49PKMN19xl7oWs9FWl5W9zOQEtHCjh814CRD', NULL, '207.46.13.63', 'Mozilla/5.0 (compatible; bingbot/2.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRXNOdm1NTWw4VnRVN0psRWFXc3F2ZEVCa1dDSFRMZW1XSVh4TlNaRyI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU4OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9jb3Vwb24tY2F0ZWdvcnkvZnJpZGdlLWZyZWV6ZXJzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1621430102),
INSERT INTO `sales` (`id`, `network_id`, `network_campaign_id`, `transaction_id`, `commission_id`, `order_id`, `click_date`, `sale_date`, `sale_amount`, `base_commission`, `commission_amount`, `currency`, `sale_status`, `status`, `sale_updated_time`, `aff_sub1`, `aff_sub2`, `aff_sub3`, `aff_sub4`, `aff_sub5`, `extra_information`, `found_batch_id`, `created_at`, `updated_at`) VALUES
(15667, 5, '39197', '8F5F10AFA5278486480FCF17BA256337', NULL, '620903682', NULL, '2021-03-11 00:00:00', '4.910', '0.737', '0.737', 'USD', 'pending', 'pending', NULL, '69696', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Curso Web Moderno Completo com JavaScript 2021 + Projetos\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(15668, 5, '39197', '5DC9A6A7D5514DFE7D54C419FF0B3B70', NULL, '620244692', NULL, '2021-03-11 00:00:00', '4.030', '0.605', '0.605', 'USD', 'pending', 'pending', NULL, 'CIADOSDESCONTOS', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Projeto painel el\\u00e9trico \\\"layout\\\"\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(15669, 5, '39197', 'C709262593E2E542549041A792EBC614', NULL, '621230560', NULL, '2021-03-11 00:00:00', '4.910', '0.737', '0.737', 'USD', 'pending', 'pending', NULL, 'CIADOSDESCONTOS', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"O Jornalismo e os Caminhos da Profiss\\u00e3o com Ricardo Boechat\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:02'),
(15670, 5, '39197', '36602AF9D156205DA3A745CB02495592', NULL, '620241182', NULL, '2021-03-11 00:00:00', '4.030', '0.605', '0.605', 'USD', 'pending', 'pending', NULL, 'CIADOSDESCONTOS', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Zabbix: construindo um ambiente de monitoramento\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(15671, 5, '39197', 'D660E3B86A06CDB269C3450DD7B5E852', NULL, '620251824', NULL, '2021-03-11 00:00:00', '4.910', '0.737', '0.737', 'USD', 'pending', 'pending', NULL, '299881', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Microsoft MS-600 and MS-700 Cert Exam : Practice Test 2021\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(6984, '{\"pt\": \"Kits Especiais de Dia Das Mães\"}', '{\"pt\": \"KITS Para Presentear com Descontos Exclusivos. Uma Seleção de Presentes para Você Surpreender nesse Dia das Mães!\"}', 103, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"344\", \"44\", \"51\", \"69\", \"70\", \"248\", \"246\", \"247\"]', 0, 'network', 4, '1252639', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6985, '{\"pt\": \"10% off no Site da Targus\"}', '{\"pt\": \"10% de Desconto no site da Targus utilizando o cupom. Uso único por CPF.,terms :Uso único por cpf válido para todo o site de 10% de desconto.\"}', 170, 'AFILIADOTARGUS', NULL, 'You must be logged in to see this link.', 1, '[\"106\"]', 0, 'network', 4, '1252629', '2021-04-28', '2021-12-31', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6986, '{\"pt\": \"Ofertas infantis para a Mamãe.\"}', '{\"pt\": \"Produtos com até 25% de desconto. + R$ 25 de desconto e Frete Grátis para todo o Brasil. Cupom: QUERO25. Aproveite!\"}', 118, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252613', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6987, '{\"pt\": \"Ser mãe: A beleza do cuidado.\"}', '{\"pt\": \"Produtos com descontos de até 50% + R$ 25 de desconto. Cupom: QUERO25 Aproveite!\"}', 118, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252611', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6988, '{\"pt\": \"Ser mãe: A beleza do cuidado.\"}', '{\"pt\": \"Produtos com descontos de até 50%. Aproveite!\"}', 122, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252607', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6990, '{\"pt\": \"Nossos livros favoritos na progressiva: 1 com 15% off, 2 ou mais com 20% off\"}', '{\"pt\": \"Nossos livros favoritos na progressiva: 1 com 15% off, 2 ou mais com 20% off no cupom MAISLIVROS,terms :Na compra de 1 item da seleção 15% off; 2 ou mais com 20% off no cupom MAISLIVROS. Válido para itens vendidos e entregues pela Americanas.com até às 23h59 do dia 02/05 ou para os primeiros 1000 pedidos.\"}', 140, 'MAISLIVROS', NULL, 'You must be logged in to see this link.', 1, '[\"164\"]', 0, 'network', 4, '1252201', '2021-04-28', NULL, 'publish', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6991, '{\"pt\": \"Especial Gama Dia das Mães.\"}', '{\"pt\": \"Descontos de até 50% + frete grátis para SP e RJ nas compras acima de R$ 199. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252145', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6992, '{\"pt\": \"Dia das Mãe com L\'occitane.\"}', '{\"pt\": \"Kits & Presentes a partir de R$29,00. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252143', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6993, '{\"pt\": \"Pharmaton Energy\"}', '{\"pt\": \"Pharmaton Energy com 70% de desconto na 2ª unidade\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252141', '2021-04-28', '2021-04-30', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6994, '{\"pt\": \"Ofertas infantis para a Mamãe\"}', '{\"pt\": \"Produtos com até 25% de desconto. + R$ 25 de desconto e Frete Grátis para todo o Brasil. Cupom: QUERO25. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252135', '2021-04-28', '2021-05-02', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6995, '{\"pt\": \"Ser mãe: A beleza do cuidado.\"}', '{\"pt\": \"Produtos com descontos de até 50% + R$ 25 de desconto Cupom: QUERO25. Aproveite!\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252133', '2021-04-28', '2021-05-09', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6996, '{\"pt\": \"Controle sua Diabetes.\"}', '{\"pt\": \"Produtos Accu Check com até 25% de desconto\"}', 72, NULL, NULL, 'You must be logged in to see this link.', 1, '[\"253\"]', 0, 'network', 4, '1252119', '2021-04-28', '2021-04-30', 'draft', 0, '2021-04-29 09:00:13', '2021-04-29 09:00:13'),
(6997, '{\"pt\": \"Zinzane - Frete Grátis acima de R$ 250,00 em compras para Sul e Sudeste. \"}', '{\"pt\": \"Frete Grátis acima de R$ 250,00 em compras para Sul e Sudeste. \"}', 302, 'SEUFRETE ', NULL, 'You must be logged in to see this link.{aid}&sskey={sskey}', 1, '[\"12\"]', 0, 'network', 3, '147234', '2021-04-28', '2021-04-30', 'draft', 0, '2021-04-29 12:00:17', '2021-04-29 12:00:17'),
(6998, '{\"pt\": \"TECHMANIA | $5 OFF em compras a partir de $50\"}', '{\"pt\": \"Válido até 30.04.2021\\r\\nRegras: Código promocional obrigatório.\\r\\nA oferta está disponível somente para entregas para o Brasil.\\r\\nO código promocional só se aplica aos itens da página do link.\\r\\nO código promocional pode ser usado uma vez em cada compra.\\r\\nOferta com tempo limitado. Quantidade limitada.\\r\\nEncontre mais informações sobre como usar o código promocional na página.\"}', 171, 'TECH5', NULL, 'You must be logged in to see this link.', 1, '[\"412\"]', 0, 'network', 2, '372212', '2021-04-29', '2021-05-01', 'draft', 0, '2021-04-29 09:00:30', '2021-04-29 09:00:30'),
(6999, '{\"pt\": \"TECHMANIA | $5 OFF em compras a partir de $30 para NOVOS COMPRADORES\"}', '{\"pt\": \"Válido até 30.04.2021\\r\\nRegras: Código promocional obrigatório.\\r\\nA oferta está disponível somente para entregas para o Brasil.\\r\\nO código promocional só se aplica aos itens da página do link.\\r\\nO código promocional pode ser usado uma vez em cada compra.\\r\\nOferta com tempo limitado. Quantidade limitada.\\r\\nEncontre mais informações sobre como usar o código promocional na página.\"}', 171, 'AETECH5NEW', NULL, 'You must be logged in to see this link.', 1, '[\"412\"]', 0, 'network', 2, '372211', '2021-04-29', '2021-05-01', 'draft', 0, '2021-04-29 09:00:30', '2021-04-29 09:00:30'),
(7000, '{\"pt\": \"TECHMANIA | $29 OFF em compras a partir de $199\"}', '{\"pt\": \"Válido até 30.04.2021\\r\\nRegras: Código promocional obrigatório.\\r\\nA oferta está disponível somente para entregas para o Brasil.\\r\\nO código promocional só se aplica aos itens da página do link.\\r\\nO código promocional pode ser usado uma vez em cada compra.\\r\\nOferta com tempo limitado. Quantidade limitada.\\r\\nEncontre mais informações sobre como usar o código promocional na página.\"}', 171, 'techgenbr', NULL, 'You must be logged in to see this link.', 1, '[\"406\", \"407\", \"408\", \"409\", \"410\", \"411\", \"412\"]', 0, 'network', 2, '372210', '2021-04-29', '2021-05-01', 'draft', 0, '2021-04-29 09:00:30', '2021-04-29 09:00:30'),
INSERT INTO `clicks` (`id`, `code`, `click_time`, `store_id`, `user_id`, `cashback_enabled`, `cashback_type`, `cashback_percent`, `referral_enabled`, `referral_percent`, `can_claim`, `confirm_duration`, `original_link`, `redirect_link`, `user_cashback_id`, `network_id`, `network_campaign_id`, `source_type`, `source_id`, `extra_info`, `ip_address`, `user_agent`, `http_referrer`) VALUES
(33378, 'bXvfUJ0byy', '2022-07-07 21:04:46', 986, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '30049', 'coupon', '32357', '{\"params\": []}', '66.249.66.75', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33379, '2aXbCdo2xH', '2022-07-07 21:19:46', 668, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 5, '43288', 'coupon', '4079', '{\"params\": []}', '66.249.66.89', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33380, 'uALhc2hU1h', '2022-07-07 21:19:48', 668, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 5, '43288', 'coupon', '2674', '{\"params\": []}', '66.249.66.46', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33381, '53PcUp2y2v', '2022-07-07 21:22:33', 186, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, NULL, 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '17713', 'store', '186', '{\"params\": []}', '114.119.145.169', 'Mozilla/5.0 (Linux; Android 7.0
AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+You must be logged in to see this link.)', 'You must be logged in to see this link.'),(33382, 'NvjpcCQkKq', '2022-07-07 21:31:34', 875, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '26051', 'store', '875', '{\"params\": []}', '114.119.145.163', 'Mozilla/5.0 (Linux; Android 7.0
AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+You must be logged in to see this link.)', 'You must be logged in to see this link.'),(33383, 'zDiolQwFsg', '2022-07-07 21:34:48', 882, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '25279', 'coupon', '26566', '{\"params\": []}', '66.249.66.131', 'Mozilla/5.0 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', NULL),
(33384, 'xnKqe9FfK0', '2022-07-07 21:35:35', 171, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 4, '17648', 'store', '171', '{\"params\": []}', '51.222.253.13', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +You must be logged in to see this link.)', NULL),
(33385, 'PkcDpQOgrH', '2022-07-07 21:40:43', 775, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 8, '22193', 'deal', '3', '{\"params\": []}', '114.119.145.163', 'Mozilla/5.0 (Linux; Android 7.0
AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+You must be logged in to see this link.)', 'You must be logged in to see this link.'),(33386, 'VDN8xsoC6r', '2022-07-07 22:02:37', 905, NULL, 1, 'cashback', '50.00', 0, '0.00', 1, '90 Days', 'You must be logged in to see this link.', 'You must be logged in to see this link.', NULL, 3, '51495', 'store', '905', '{\"params\": []}', '51.222.253.15', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +You must be logged in to see this link.)', NULL),
INSERT INTO `campaigns` (`id`, `network_id`, `network_campaign_id`, `campaign_name`, `name`, `website`, `domains`, `domain_name`, `affiliate_link`, `deeplink_format`, `deeplink_allowed`, `offer_id`, `group_id`, `mapping_type`, `description`, `restriction`, `logo`, `categories`, `currency`, `country`, `countries`, `cr`, `epc`, `campaign_status`, `campaign_type`, `status`, `extra_information`, `raw_categories`, `raw_commission`, `rating`, `stats`, `start_date`, `end_date`, `ignored`, `initialize`, `found_batch_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(22432, 4, '29823', 'Awin Affiliation Programme', 'Awin Affiliation Programme', 'You must be logged in to see this link.', NULL, 'learntradeskills.co.uk', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GBP', 'GB', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-10 23:01:16', '2022-09-25 23:03:16', NULL),
(22433, 4, '26919', 'The Mountain UK', 'The Mountain UK', 'You must be logged in to see this link.', NULL, 'themountain.com', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GBP', 'GB', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-11 23:01:30', '2022-09-25 23:03:05', NULL),
(22434, 4, '26925', 'The Mountain EU', 'The Mountain EU', 'You must be logged in to see this link.', NULL, 'themountain.com', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EUR', 'IE', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-11 23:01:30', '2022-09-25 23:03:05', NULL),
(22435, 4, '28691', 'The Couture Club', 'The Couture Club', 'You must be logged in to see this link.', NULL, 'thecoutureclub.com', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GBP', 'GB', NULL, NULL, NULL, 'notjoined', NULL, 'not_joined', '[]', NULL, NULL, NULL, '[]', NULL, NULL, 0, 0, 65998, '2022-05-11 23:01:32', '2022-09-25 23:03:12', NULL),
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('yKO0AdFhvM4LurxdGwzLsGUPlR2HmP0Q52XUdydT', NULL, '185.191.171.36', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRFZxMDdlMnpYckhKZ3l1ZkRkREtEUmQwTHl1QlU0SmtxZk52YnM3MiI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjYxOiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9zdG9yZS1jYXRlZ29yeS9tb3RvcmJpa2UtaW5zdXJhbmNlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1624219071),
('YKo365ditsWEPni3AGlO0tdkmXEt9GFKzgMezdu7', NULL, '66.249.69.136', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.80 Mobile Safari/537.36 (compatible; Googlebot/2.1; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib0VLUWxtM2E0N0oweUhYVHVRdnZRQmhaQWw4ZjBYUFU3emZDWW85YyI7czo2OiJsb2NhbGUiO3M6MjoicHQiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjIzOiJodHRwczovL21ldWNhc2hiYWNrLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1619068021),
('yKpdGfs2jx93Xo2LCFkVIw2zJsp8qKWWqem8faQi', NULL, '207.46.13.34', 'Mozilla/5.0 (compatible; bingbot/2.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaXJJandFdnhuY21DMjBId3FQbjUwM0J2S2U3aFdKUXJwdFIxN0kyUyI7czo2OiJsb2NhbGUiO3M6MjoicHQiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ4OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9jYXRlZ29yaWEtbG9qYS9lbi1jbGllbnQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1619649522),
('YKrXyk3Yqfdki6Kq6b0FrU99iEdpqeOQv5L029SE', NULL, '162.55.86.60', 'Mozilla/5.0 (compatible; BLEXBot/1.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMndlUlZrZXJ0Q3dscTVoeGxwVnFQSGUwT1ZxbnFCWE9sdEgycEhIdiI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU2OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9zdG9yZS1jYXRlZ29yeS9idXNpbmVzcy1sb2FucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1623544676),
('Yksve8ZIXtUCxoEiw9UHsfNfHWIW1Je8JurUrQ4M', NULL, '162.55.86.60', 'Mozilla/5.0 (compatible; BLEXBot/1.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOEF5dVh2d1hHOEpxY3E0VWFENGlNRHpXQUlFOWx5aEIyTGxtckhUcyI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU4OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9jb3Vwb24tY2F0ZWdvcnkvYm9va3MtbWFnYXppbmVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1623544080),
('YkTgTr5Uwqq7j76AK4y4PxlucbfIalzNOOrRAMlt', NULL, '185.191.171.2', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVjJGYjdZbWJkU01IMUNSZjk3ZVZ0S1NsQ1lGb21maUhVNzU0N0kySCI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU3OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9zdG9yZS1jYXRlZ29yeS9lbi1jcmVkaXQtY2FyZHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1624689998),
('yKuGTsxvedtg1Bef1sKo9CHSrQ2IFD1O83pKW9Ha', NULL, '185.191.171.5', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS0I0MkVPUkhxZnl4elNvUGlrcmsydWZZbUtWcUF0Y2l0V05VNlBCRSI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjcwOiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9jb3Vwb24tY2F0ZWdvcnkvY2FibGVzLXBhcnRzLXBvd2VyLXN1cHBsaWVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1621248870),
('YKwd49PKMN19xl7oWs9FWl5W9zOQEtHCjh814CRD', NULL, '207.46.13.63', 'Mozilla/5.0 (compatible; bingbot/2.0; +You must be logged in to see this link.)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRXNOdm1NTWw4VnRVN0psRWFXc3F2ZEVCa1dDSFRMZW1XSVh4TlNaRyI7czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjU4OiJodHRwczovL21ldWNhc2hiYWNrLmNvbS9lbi9jb3Vwb24tY2F0ZWdvcnkvZnJpZGdlLWZyZWV6ZXJzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1621430102),
INSERT INTO `sales` (`id`, `network_id`, `network_campaign_id`, `transaction_id`, `commission_id`, `order_id`, `click_date`, `sale_date`, `sale_amount`, `base_commission`, `commission_amount`, `currency`, `sale_status`, `status`, `sale_updated_time`, `aff_sub1`, `aff_sub2`, `aff_sub3`, `aff_sub4`, `aff_sub5`, `extra_information`, `found_batch_id`, `created_at`, `updated_at`) VALUES
(15667, 5, '39197', '8F5F10AFA5278486480FCF17BA256337', NULL, '620903682', NULL, '2021-03-11 00:00:00', '4.910', '0.737', '0.737', 'USD', 'pending', 'pending', NULL, '69696', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Curso Web Moderno Completo com JavaScript 2021 + Projetos\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(15668, 5, '39197', '5DC9A6A7D5514DFE7D54C419FF0B3B70', NULL, '620244692', NULL, '2021-03-11 00:00:00', '4.030', '0.605', '0.605', 'USD', 'pending', 'pending', NULL, 'CIADOSDESCONTOS', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Projeto painel el\\u00e9trico \\\"layout\\\"\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(15669, 5, '39197', 'C709262593E2E542549041A792EBC614', NULL, '621230560', NULL, '2021-03-11 00:00:00', '4.910', '0.737', '0.737', 'USD', 'pending', 'pending', NULL, 'CIADOSDESCONTOS', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"O Jornalismo e os Caminhos da Profiss\\u00e3o com Ricardo Boechat\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:02'),
(15670, 5, '39197', '36602AF9D156205DA3A745CB02495592', NULL, '620241182', NULL, '2021-03-11 00:00:00', '4.030', '0.605', '0.605', 'USD', 'pending', 'pending', NULL, 'CIADOSDESCONTOS', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Zabbix: construindo um ambiente de monitoramento\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
(15671, 5, '39197', 'D660E3B86A06CDB269C3450DD7B5E852', NULL, '620251824', NULL, '2021-03-11 00:00:00', '4.910', '0.737', '0.737', 'USD', 'pending', 'pending', NULL, '299881', NULL, NULL, NULL, NULL, '{\"OfItems\":\"1\",\"ProductName\":\"Microsoft MS-600 and MS-700 Cert Exam : Practice Test 2021\"}', 38483, '2021-03-15 03:00:24', '2021-07-09 04:03:01'),
