Skip to content

Instantly share code, notes, and snippets.

@pratik60

pratik60/gist:1b49481481c6bb2ad745

Created September 17, 2014 09:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pratik60/1b49481481c6bb2ad745 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pratik60/1b49481481c6bb2ad745 to your computer and use it in GitHub Desktop.
Download ZIP
Gist
Raw
gistfile1.txt
INSERT INTO `partner_dashboard_report` (`partner_code`, `job_id`, `created`, `units`, `service`, `subject_area`, `country`, `journal`, `revenue`, `discount_amount`, `job_status`, `client_type`, `currency`, `client_code`, `referral_fee`, `education_service_allocation`)
VALUES
('WR83235', 'AACD_1', 1410518636, 3000, 'Translation', 'Physics', 'Japan', 'ABC', 300, 0, 'QA', 'Existing', 'Dollar', 'NX1243', 30, 6),
('WR83235', 'ABCC_1', 1410518636, 5000, 'Advanced Editing', 'Medicine', 'China', 'ABC', 350, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 35, 7),
('WR83235', 'ABCD_1', 1410518636, 2500, 'Advanced Editing', 'Medicine', 'China', 'ABC', 300, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 25, 6),
('WR83235', 'ABCE_1', 1410518636, 4500, 'Premium Editing', 'Medicine', 'China', 'ABC', 450, 0, 'QA', 'NEW', 'Dollar', 'NX1242', 45, 9),
('WR83235', 'ABCE_2', 1407004200, 4500, 'Premium Editing', 'Medicine', 'China', 'ABC', 450, 0, 'QA', 'NEW', 'Dollar', 'NX1242', 45, 9),
('WR83235', 'ABCE_3', 1377628200, 4500, 'Premium Editing', 'Medicine', 'China', 'ABC', 450, 0, 'QA', 'NEW', 'Dollar', 'NX1242', 45, 9),
('WR83235', 'ABCF_1', 1410518636, 6000, 'Advanced Editing', 'Medicine', 'Brazil', 'ABC', 250, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 15, 5),
('WR83235', 'ABCF_2', 1407004200, 6000, 'Advanced Editing', 'Medicine', 'Brazil', 'ABC', 250, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 15, 5),
('WR83235', 'ABDD_2', 1410518636, 2000, 'Advanced Editing', 'Nursing', 'USA', 'ABC', 350, 0, 'QA', 'Existing', 'Dollar', 'NX1243', 35, 7),
('WR83235', 'ABDD_3', 1407004200, 2000, 'Advanced Editing', 'Nursing', 'USA', 'ABC', 350, 0, 'QA', 'Existing', 'Dollar', 'NX1243', 35, 7),
('WR83235', 'ABSS_1', 1410518636, 5000, 'Advanced Editing', 'Nursing', 'China', 'ABC', 450, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 45, 9),
('WR83235', 'ABSS_2', 1407004200, 5000, 'Advanced Editing', 'Nursing', 'China', 'ABC', 450, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 45, 9),
('WR83235', 'ABSS_3', 1377628200, 5000, 'Advanced Editing', 'Nursing', 'China', 'ABC', 450, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 45, 9),
('WR83235', 'ACFT_1', 1410518636, 5700, 'Translation', 'Art', 'Japan', 'ABC', 400, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 40, 8),
('E183235', 'BACD_1', 1410518636, 3000, 'Translation', 'Physics', 'Japan', 'ABC', 300, 0, 'QA', 'Existing', 'Dollar', 'NX1243', 30, 6),
('E183235', 'BBCC_1', 1410518636, 5000, 'Advanced Editing', 'Medicine', 'China', 'ABC', 350, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 35, 7),
('E183235', 'BBCD_1', 1410518636, 2500, 'Advanced Editing', 'Medicine', 'China', 'ABC', 300, 0, 'QA', 'NEW', 'Dollar', 'NX1243', 30, 6),
('E183235', 'BBCF_1', 1410518636, 6000, 'Advanced Editing', 'Medicine', 'Brazil', 'ABC', 250, 0, 'NE', 'NEW', 'Dollar', 'NX1243', 25, 5),
('E183235', 'BBDD_2', 1410518636, 2000, 'Advanced Editing', 'Nursing', 'USA', 'ABC', 350, 0, 'QA', 'Existing', 'Dollar', 'NX1243', 35, 7),
('WR83235', 'HGFD_3', 1410518636, 3100, 'Advanced Editing', 'Chemistry', 'Taiwan', 'ABC', 500, 0, 'QA', 'Existing', 'Dollar', 'NX1243', 50, 10),
('WR83235', 'SEDR_2', 1410518636, 4800, 'Premium Editng', 'Physics', 'Japan', 'ABC', 450, 0, 'NE', 'Existing', 'Dollar', 'NX1243', 45, 9);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment