mysql或者php 如何将日期转化成多列?

Question

CREATE TABLE `account_summary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Site` varchar(255) DEFAULT NULL,
  `mark` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `mark_name` varchar(255) DEFAULT NULL,
  `total` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of account_summary
-- ----------------------------
INSERT INTO `account_summary` VALUES ('1', 'Spain', '10112', '2019-03-22 00:00:00', 'racingdepotes(QZRES)', '1');
INSERT INTO `account_summary` VALUES ('2', 'Italy', '10111', '2019-03-22 00:00:00', 'racingdepotit(QZRIT-IT)', '4');
INSERT INTO `account_summary` VALUES ('3', 'Italy', '76', '2019-03-22 00:00:00', 'AutoModmall(IT)', '23');
INSERT INTO `account_summary` VALUES ('4', 'Italy', '10028', '2019-03-22 00:00:00', 'TopVehicleParts-IT(IT)', '3');
INSERT INTO `account_summary` VALUES ('5', 'France', '10065', '2019-03-22 00:00:00', 'autoexpertstore(FR)', '3');
INSERT INTO `account_summary` VALUES ('6', 'eBayMotors', '22', '2019-03-22 00:00:00', 'ConnectingRodMasters(US)', '1');
INSERT INTO `account_summary` VALUES ('7', 'Spain', '74', '2019-03-22 00:00:00', 'AutoModDiscount(ES)', '1');
INSERT INTO `account_summary` VALUES ('8', 'France', '10113', '2019-03-22 00:00:00', 'racingdepotfr(QZ-FR)', '1');
INSERT INTO `account_summary` VALUES ('9', 'France', '10105', '2019-03-22 00:00:00', 'TuningStudio-FR(LMTFR)', '7');
INSERT INTO `account_summary` VALUES ('10', 'France', '10025', '2019-03-22 00:00:00', 'Parfait-autoparts(FR)', '11');
INSERT INTO `account_summary` VALUES ('11', 'Italy', '10046', '2019-03-22 00:00:00', 'TopAutoTurning(IT)', '5');
INSERT INTO `account_summary` VALUES ('12', 'Italy', '46', '2019-03-22 00:00:00', 'AclassMotoring(IT)', '16');
INSERT INTO `account_summary` VALUES ('13', 'France', '81', '2019-03-22 00:00:00', 'tpg-autoteile(AT)', '11');
INSERT INTO `account_summary` VALUES ('14', 'Spain', '10027', '2019-03-22 00:00:00', 'TuningShop-ES(ES)', '10');
INSERT INTO `account_summary` VALUES ('15', 'Spain', '10045', '2019-03-22 00:00:00', 'worldcarsparts(ES)', '8');
INSERT INTO `account_summary` VALUES ('16', 'Spain', '10041', '2019-03-22 00:00:00', 'carreplacementshow(ES)', '15');
INSERT INTO `account_summary` VALUES ('17', 'Spain', '57', '2019-03-22 00:00:00', 'ATopTuning-ES(ES)', '7');
INSERT INTO `account_summary` VALUES ('18', 'Spain', '82', '2019-03-22 00:00:00', 'TopCarParts-PL', '23');
INSERT INTO `account_summary` VALUES ('19', 'Spain', '51', '2019-03-22 00:00:00', 'tuningsmarket-es(ES)', '12');
INSERT INTO `account_summary` VALUES ('20', 'Spain', '23', '2019-03-22 00:00:00', 'maXpeedingrods-es(ES)', '6');
INSERT INTO `account_summary` VALUES ('21', 'France', '44', '2019-03-22 00:00:00', 'SuperModification(FR)', '2');
INSERT INTO `account_summary` VALUES ('22', 'France', '59', '2019-03-22 00:00:00', 'ATopTuning-FR(FR)', '8');
INSERT INTO `account_summary` VALUES ('23', 'Italy', '10043', '2019-03-22 00:00:00', 'AutoPartsCenter-IT(IT)', '3');
INSERT INTO `account_summary` VALUES ('24', 'Italy', '25', '2019-03-22 00:00:00', 'maXpeedingrods-it(IT)', '20');
INSERT INTO `account_summary` VALUES ('25', 'Italy', '10066', '2019-03-22 00:00:00', 'autograndpa(IT)', '7');
INSERT INTO `account_summary` VALUES ('26', 'Italy', '10024', '2019-03-22 00:00:00', 'Negozio-di-corse(IT)', '4');
INSERT INTO `account_summary` VALUES ('27', 'Italy', '55', '2019-03-22 00:00:00', 'ATopTuning-IT(IT)', '16');
INSERT INTO `account_summary` VALUES ('28', 'France', '69', '2019-03-22 00:00:00', 'Tuningsmarket-FR(FR)', '8');
INSERT INTO `account_summary` VALUES ('29', 'France', '10040', '2019-03-22 00:00:00', 'Professionnel Parts(FR)', '5');
INSERT INTO `account_summary` VALUES ('30', 'France', '73', '2019-03-22 00:00:00', 'AutoModProfession(FR)', '7');
INSERT INTO `account_summary` VALUES ('31', 'France', '19', '2019-03-22 00:00:00', 'maXpeedingrods-fr(FR)', '13');
INSERT INTO `account_summary` VALUES ('32', 'France', '10044', '2019-03-22 00:00:00', 'MeilleurAutoPiece(FR)', '3');
INSERT INTO `account_summary` VALUES ('33', 'Italy', '52', '2019-03-22 00:00:00', 'tuningsoutlet-it(IT)', '39');
INSERT INTO `account_summary` VALUES ('34', 'UK', '10075', '2019-03-21 00:00:00', 'EaseReplacedParts(LMDV-UK)', '84');
INSERT INTO `account_summary` VALUES ('35', 'UK', '10076', '2019-03-21 00:00:00', 'Racinghavens(LMDV-UK)', '13');
INSERT INTO `account_summary` VALUES ('36', 'UK', '10048', '2019-03-21 00:00:00', 'TuningUrVehicles(QZ-UK)', '19');
INSERT INTO `account_summary` VALUES ('37', 'UK', '10073', '2019-03-21 00:00:00', 'UpgradeAutoParts(LMDV-UK)', '28');
INSERT INTO `account_summary` VALUES ('38', 'Italy', '10066', '2019-03-21 00:00:00', 'autograndpa(IT)', '16');
INSERT INTO `account_summary` VALUES ('39', 'UK', '10079', '2019-03-21 00:00:00', 'AutoSuspensionHouse(QZ-UK)', '17');
INSERT INTO `account_summary` VALUES ('40', 'UK', '10077', '2019-03-21 00:00:00', 'ProTuningTools(QZ-UK)', '81');
INSERT INTO `account_summary` VALUES ('41', 'UK', '10053', '2019-03-21 00:00:00', 'AutoKingCity(UK)', '20');
INSERT INTO `account_summary` VALUES ('42', 'UK', '10047', '2019-03-21 00:00:00', 'OhMyGarage(QZ-UK)', '32');
INSERT INTO `account_summary` VALUES ('43', 'UK', '10078', '2019-03-21 00:00:00', 'FuriousSpeedyParts(QZ-UK)', '10');
INSERT INTO `account_summary` VALUES ('44', 'UK', '28', '2019-03-21 00:00:00', 'ConnectingrodEclub(UK)', '71');
INSERT INTO `account_summary` VALUES ('45', 'UK', '24', '2019-03-21 00:00:00', 'AutoModMasters(UK)', '107');
INSERT INTO `account_summary` VALUES ('46', 'UK', '39', '2019-03-21 00:00:00', 'CoolAutoClub(UK)', '83');
INSERT INTO `account_summary` VALUES ('47', 'UK', '27', '2019-03-21 00:00:00', 'SuspensionEclub(UK)', '93');
INSERT INTO `account_summary` VALUES ('48', 'UK', '10085', '2019-03-21 00:00:00', 'PerformanceWareHouses(QZ-UK)', '18');
INSERT INTO `account_summary` VALUES ('49', 'UK', '10074', '2019-03-21 00:00:00', 'OnlyOneGarage(LMDV-UK)', '13');
INSERT INTO `account_summary` VALUES ('50', 'UK', '10052', '2019-03-21 00:00:00', 'kingstuningmarket(UK)', '41');
INSERT INTO `account_summary` VALUES ('51', 'Italy', '10109', '2019-03-21 00:00:00', 'Fittingcarparts-IT(ZJFIT)', '1');
INSERT INTO `account_summary` VALUES ('52', 'Germany', '10100', '2019-03-21 00:00:00', 'Spitze-Autoteile(YLDE-DE)', '3');
INSERT INTO `account_summary` VALUES ('53', 'Germany', '10068', '2019-03-21 00:00:00', 'Autosclub(LMDV-DE)', '6');
INSERT INTO `account_summary` VALUES ('54', 'Germany', '10101', '2019-03-21 00:00:00', 'Maxspeed-autoteile(YLDE-DE)', '4');
INSERT INTO `account_summary` VALUES ('55', 'UK', '10084', '2019-03-21 00:00:00', 'SpeedinGuys（ZJDV-UK)', '1');
INSERT INTO `account_summary` VALUES ('56', 'Germany', '10055', '2019-03-21 00:00:00', 'Maxpower-Autoteile(DE)', '72');
INSERT INTO `account_summary` VALUES ('57', 'Germany', '10054', '2019-03-21 00:00:00', 'Super-KFZ-Teile(DE)', '77');
INSERT INTO `account_summary` VALUES ('58', 'Germany', '10071', '2019-03-21 00:00:00', 'powersclub(ZJDV-DE)', '10');
INSERT INTO `account_summary` VALUES ('59', 'Germany', '10067', '2019-03-21 00:00:00', 'tuningsclub(LMDV-DE)', '17');
INSERT INTO `account_summary` VALUES ('60', 'Germany', '10070', '2019-03-21 00:00:00', 'AutoteileFabrik(LMDV-DE)', '8');
INSERT INTO `account_summary` VALUES ('61', 'Germany', '10095', '2019-03-21 00:00:00', 'Autoteilearena(YLADE-DE)', '2');
INSERT INTO `account_summary` VALUES ('62', 'Italy', '52', '2019-03-21 00:00:00', 'tuningsoutlet-it(IT)', '40');
INSERT INTO `account_summary` VALUES ('63', 'France', '10105', '2019-03-21 00:00:00', 'TuningStudio-FR(LMTFR)', '33');
INSERT INTO `account_summary` VALUES ('64', 'Germany', '10099', '2019-03-21 00:00:00', 'Pro-tuningparts(YLDE-DE)', '7');
INSERT INTO `account_summary` VALUES ('65', 'eBayMotors', '65', '2019-03-21 00:00:00', 'Autopartspeeding(US)', '1');
INSERT INTO `account_summary` VALUES ('66', 'US', '10061', '2019-03-21 00:00:00', 'TopCarParts(US)', '1');
INSERT INTO `account_summary` VALUES ('67', 'US', '10056', '2019-03-21 00:00:00', 'VehicalPartsLearder(QZ-US)', '1');
INSERT INTO `account_summary` VALUES ('68', 'Germany', '10062', '2019-03-21 00:00:00', 'Spitze-Speed(QZ-DE)', '32');
INSERT INTO `account_summary` VALUES ('69', 'Australia', '35', '2019-03-21 00:00:00', 'ConnectingrodIsland(AU)', '18');
INSERT INTO `account_summary` VALUES ('70', 'eBayMotors', '50', '2019-03-21 00:00:00', 'tuningscentertag(US)', '7');
INSERT INTO `account_summary` VALUES ('71', 'France', '10044', '2019-03-21 00:00:00', 'MeilleurAutoPiece(FR)', '91');
INSERT INTO `account_summary` VALUES ('72', 'France', '10040', '2019-03-21 00:00:00', 'Professionnel Parts(FR)', '44');
INSERT INTO `account_summary` VALUES ('73', 'France', '10025', '2019-03-21 00:00:00', 'Parfait-autoparts(FR)', '46');
INSERT INTO `account_summary` VALUES ('74', 'France', '81', '2019-03-21 00:00:00', 'tpg-autoteile(AT)', '46');
INSERT INTO `account_summary` VALUES ('75', 'Spain', '10090', '2019-03-21 00:00:00', 'Mejorautoparts(LMJDV-ES)', '3');
INSERT INTO `account_summary` VALUES ('76', 'Spain', '10107', '2019-03-21 00:00:00', 'TuningStudio-ES(LMTES)', '4');
INSERT INTO `account_summary` VALUES ('77', 'Spain', '10094', '2019-03-21 00:00:00', 'Vehiculepiece(ZJVDV-ES)', '30');
INSERT INTO `account_summary` VALUES ('78', 'France', '10102', '2019-03-21 00:00:00', 'Highspeedstore-FR(ZJHFR)', '1');
INSERT INTO `account_summary` VALUES ('79', 'Germany', '10088', '2019-03-21 00:00:00', 'Super-Auto-Welt(ZJDV-DE)', '4');
INSERT INTO `account_summary` VALUES ('80', 'Germany', '10087', '2019-03-21 00:00:00', 'speedclub(ZJDV-DE)', '4');
INSERT INTO `account_summary` VALUES ('81', 'Germany', '10072', '2019-03-21 00:00:00', 'torquesclub(ZJDV-DE)', '8');
INSERT INTO `account_summary` VALUES ('82', 'Germany', '10069', '2019-03-21 00:00:00', 'Motivecomponents(LMDV-DE)', '3');
INSERT INTO `account_summary` VALUES ('83', 'France', '10065', '2019-03-21 00:00:00', 'autoexpertstore(FR)', '28');
INSERT INTO `account_summary` VALUES ('84', 'France', '69', '2019-03-21 00:00:00', 'Tuningsmarket-FR(FR)', '44');
INSERT INTO `account_summary` VALUES ('85', 'Australia', '6', '2019-03-21 00:00:00', 'AutoPartsDepot(AU)', '17');
INSERT INTO `account_summary` VALUES ('86', 'Australia', '67', '2019-03-21 00:00:00', 'Aplusmarkets-AU(AU)', '19');
INSERT INTO `account_summary` VALUES ('87', 'Australia', '47', '2019-03-21 00:00:00', 'AutosFactory(AU)', '28');
INSERT INTO `account_summary` VALUES ('88', 'Australia', '30', '2019-03-21 00:00:00', 'TurboPlanet(AU)', '24');
INSERT INTO `account_summary` VALUES ('89', 'Australia', '5', '2019-03-21 00:00:00', 'TurbochargerDepot(AU)', '27');
INSERT INTO `account_summary` VALUES ('90', 'Germany', '10064', '2019-03-21 00:00:00', 'infinitive-tuning(QZ-DE)', '16');
INSERT INTO `account_summary` VALUES ('91', 'Germany', '10051', '2019-03-21 00:00:00', 'autoshop-de(QZ-DE)', '18');
INSERT INTO `account_summary` VALUES ('92', 'Germany', '10050', '2019-03-21 00:00:00', 'top-carsparts(QZ-DE)', '22');
INSERT INTO `account_summary` VALUES ('93', 'Germany', '10063', '2019-03-21 00:00:00', 'KFZ-tuning-online(QZ-DE)', '17');
INSERT INTO `account_summary` VALUES ('94', 'France', '10113', '2019-03-21 00:00:00', 'racingdepotfr(QZ-FR)', '54');
INSERT INTO `account_summary` VALUES ('95', 'France', '19', '2019-03-21 00:00:00', 'maXpeedingrods-fr(FR)', '24');
INSERT INTO `account_summary` VALUES ('96', 'Italy', '10111', '2019-03-21 00:00:00', 'racingdepotit(QZRIT-IT)', '13');
INSERT INTO `account_summary` VALUES ('97', 'France', '10096', '2019-03-21 00:00:00', 'Belovedautos(LMBDV-FR)', '2');
INSERT INTO `account_summary` VALUES ('98', 'eBayMotors', '20', '2019-03-21 00:00:00', 'TurbosMasters(US)', '18');
INSERT INTO `account_summary` VALUES ('99', 'Italy', '10092', '2019-03-21 00:00:00', 'Greatautopartsgo(ZJGDV-IT)', '2');
INSERT INTO `account_summary` VALUES ('100', 'Italy', '10093', '2019-03-21 00:00:00', 'Racingworld-it(LMSDV-IT)', '3');
INSERT INTO `account_summary` VALUES ('101', 'Italy', '10106', '2019-03-21 00:00:00', 'TuningStudio-IT(LMTIT)', '1');
INSERT INTO `account_summary` VALUES ('102', 'Italy', '10104', '2019-03-21 00:00:00', 'Powercarparts-IT(ZJPIT)', '105');
INSERT INTO `account_summary` VALUES ('103', 'Spain', '74', '2019-03-21 00:00:00', 'AutoModDiscount(ES)', '27');
INSERT INTO `account_summary` VALUES ('104', 'Germany', '10049', '2019-03-21 00:00:00', 'top-autosparts(QZ-DE)', '16');
INSERT INTO `account_summary` VALUES ('105', 'eBayMotors', '1', '2019-03-21 00:00:00', 'maxspeedingrods(us)', '46');
INSERT INTO `account_summary` VALUES ('106', 'US', '36', '2019-03-21 00:00:00', 'AutoModPlanet(US)', '2');
INSERT INTO `account_summary` VALUES ('107', 'eBayMotors', '10058', '2019-03-21 00:00:00', 'TuningPortal(QZ-US)', '8');
INSERT INTO `account_summary` VALUES ('108', 'US', '8', '2019-03-21 00:00:00', 'Racing Parts Warehouse(US)', '3');
INSERT INTO `account_summary` VALUES ('109', 'US', '48', '2019-03-21 00:00:00', 'tuningscenter(US)', '2');
INSERT INTO `account_summary` VALUES ('110', 'eBayMotors', '8', '2019-03-21 00:00:00', 'Racing Parts Warehouse(US)', '46');
INSERT INTO `account_summary` VALUES ('111', 'eBayMotors', '36', '2019-03-21 00:00:00', 'AutoModPlanet(US)', '40');
INSERT INTO `account_summary` VALUES ('112', 'US', '2', '2019-03-21 00:00:00', 'tuningpartsmaster(us)', '2');
INSERT INTO `account_summary` VALUES ('113', 'US', '10060', '2019-03-21 00:00:00', 'VehicalHeaven(QZ-US)', '2');
INSERT INTO `account_summary` VALUES ('114', 'US', '10058', '2019-03-21 00:00:00', 'TuningPortal(QZ-US)', '1');
INSERT INTO `account_summary` VALUES ('115', 'Australia', '31', '2019-03-21 00:00:00', 'SuspensionPlanet(AU)', '15');
INSERT INTO `account_summary` VALUES ('116', 'Australia', '34', '2019-03-21 00:00:00', 'SuspensionIsland(AU)', '23');
INSERT INTO `account_summary` VALUES ('117', 'Spain', '10112', '2019-03-21 00:00:00', 'racingdepotes(QZRES)', '5');
INSERT INTO `account_summary` VALUES ('118', 'US', '70', '2019-03-21 00:00:00', 'popracingparts(US)', '4');
INSERT INTO `account_summary` VALUES ('119', 'eBayMotors', '10014', '2019-03-21 00:00:00', 'TuningPartsKingdom(QX-US)', '2');
INSERT INTO `account_summary` VALUES ('120', 'US', '21', '2019-03-21 00:00:00', 'SuspensionMasters(US)', '7');
INSERT INTO `account_summary` VALUES ('121', 'US', '3', '2019-03-21 00:00:00', 'powerracings(US)', '5');
INSERT INTO `account_summary` VALUES ('122', 'US', '61', '2019-03-21 00:00:00', 'Aplusmarkets-US(US)', '7');
INSERT INTO `account_summary` VALUES ('123', 'US', '1', '2019-03-21 00:00:00', 'maxspeedingrods(us)', '3');
INSERT INTO `account_summary` VALUES ('124', 'US', '13', '2019-03-21 00:00:00', 'maxspeedingrods-ca(US)', '7');
INSERT INTO `account_summary` VALUES ('125', 'US', '22', '2019-03-21 00:00:00', 'ConnectingRodMasters(US)', '5');
INSERT INTO `account_summary` VALUES ('126', 'US', '77', '2019-03-21 00:00:00', 'AutoPartPart(US)', '6');
INSERT INTO `account_summary` VALUES ('127', 'Australia', '49', '2019-03-21 00:00:00', 'tuningscentertop(AU)', '9');
INSERT INTO `account_summary` VALUES ('128', 'US', '50', '2019-03-21 00:00:00', 'tuningscentertag(US)', '5');
INSERT INTO `account_summary` VALUES ('129', 'Australia', '10011', '2019-03-21 00:00:00', 'perfection_autofield(QX-AU)', '22');
INSERT INTO `account_summary` VALUES ('130', 'France', '44', '2019-03-21 00:00:00', 'SuperModification(FR)', '68');
INSERT INTO `account_summary` VALUES ('131', 'UK', '10080', '2019-03-21 00:00:00', 'WellsellAutoParts(QZ-UK)', '13');
INSERT INTO `account_summary` VALUES ('132', 'UK', '26', '2019-03-21 00:00:00', 'TurbosEclub(UK)', '19');
INSERT INTO `account_summary` VALUES ('133', 'UK', '29', '2019-03-21 00:00:00', 'PARacingParts-UK(UK)', '27');
INSERT INTO `account_summary` VALUES ('134', 'UK', '79', '2019-03-21 00:00:00', 'TuningFans-Feast(UK)', '22');
INSERT INTO `account_summary` VALUES ('135', 'eBayMotors', '85', '2019-03-21 00:00:00', 'AUTOTEILE-EXPERTS(US)', '9');
INSERT INTO `account_summary` VALUES ('136', 'eBayMotors', '9', '2019-03-21 00:00:00', 'ttechnik(US)', '10');
INSERT INTO `account_summary` VALUES ('137', 'UK', '37', '2019-03-21 00:00:00', 'AutoModIsland(UK)', '27');
INSERT INTO `account_summary` VALUES ('138', 'UK', '43', '2019-03-21 00:00:00', 'SpeedingParts(UK)', '24');
INSERT INTO `account_summary` VALUES ('139', 'UK', '80', '2019-03-21 00:00:00', 'AutoParts-UKingdom(UK)', '16');
INSERT INTO `account_summary` VALUES ('140', 'eBayMotors', '77', '2019-03-21 00:00:00', 'AutoPartPart(US)', '6');
INSERT INTO `account_summary` VALUES ('141', 'eBayMotors', '70', '2019-03-21 00:00:00', 'popracingparts(US)', '7');
INSERT INTO `account_summary` VALUES ('142', 'eBayMotors', '3', '2019-03-21 00:00:00', 'powerracings(US)', '26');
INSERT INTO `account_summary` VALUES ('143', 'Australia', '10010', '2019-03-21 00:00:00', '666autopartsonline(QX-AU)', '14');
INSERT INTO `account_summary` VALUES ('144', 'eBayMotors', '10013', '2019-03-21 00:00:00', 'AutoPartsSupermarket(QX-US)', '2');
INSERT INTO `account_summary` VALUES ('145', 'eBayMotors', '14', '2019-03-21 00:00:00', 'MaxAutoClub(US)', '6');
INSERT INTO `account_summary` VALUES ('146', 'eBayMotors', '10026', '2019-03-21 00:00:00', 'Speedingtech(QX-UK)', '2');
INSERT INTO `account_summary` VALUES ('147', 'eBayMotors', '10060', '2019-03-21 00:00:00', 'VehicalHeaven(QZ-US)', '16');
INSERT INTO `account_summary` VALUES ('148', 'eBayMotors', '10061', '2019-03-21 00:00:00', 'TopCarParts(US)', '15');
INSERT INTO `account_summary` VALUES ('149', 'Australia', '84', '2019-03-21 00:00:00', 'top_auto_field(AU)', '12');
INSERT INTO `account_summary` VALUES ('150', 'Australia', '12', '2019-03-21 00:00:00', '999aps(AU)', '22');
INSERT INTO `account_summary` VALUES ('151', 'Australia', '78', '2019-03-21 00:00:00', 'autopapa-au(AU)', '11');
INSERT INTO `account_summary` VALUES ('152', 'Australia', '11', '2019-03-21 00:00:00', 'tuningpartsdepot(AU)', '12');
INSERT INTO `account_summary` VALUES ('153', 'Australia', '32', '2019-03-21 00:00:00', 'ConnectingrodPlanet(AU)', '24');
INSERT INTO `account_summary` VALUES ('154', 'UK', '10083', '2019-03-21 00:00:00', 'MarvelousAutos(ZJDV-UK)', '3');
INSERT INTO `account_summary` VALUES ('155', 'eBayMotors', '13', '2019-03-21 00:00:00', 'maxspeedingrods-ca(US)', '26');
INSERT INTO `account_summary` VALUES ('156', 'eBayMotors', '10015', '2019-03-21 00:00:00', 'CarPartsParadise(QX-US)', '5');
INSERT INTO `account_summary` VALUES ('157', 'eBayMotors', '41', '2019-03-21 00:00:00', 'BestRacings(US)', '38');
INSERT INTO `account_summary` VALUES ('158', 'eBayMotors', '40', '2019-03-21 00:00:00', 'MotorBay(US)', '11');
INSERT INTO `account_summary` VALUES ('159', 'eBayMotors', '75', '2019-03-21 00:00:00', 'autopapa-us(US)', '15');
INSERT INTO `account_summary` VALUES ('160', 'eBayMotors', '45', '2019-03-21 00:00:00', 'ShockPort(US)', '26');
INSERT INTO `account_summary` VALUES ('161', 'eBayMotors', '33', '2019-03-21 00:00:00', 'TurbosIsland(US)', '4');
INSERT INTO `account_summary` VALUES ('162', 'eBayMotors', '61', '2019-03-21 00:00:00', 'Aplusmarkets-US(US)', '47');
INSERT INTO `account_summary` VALUES ('163', 'eBayMotors', '22', '2019-03-21 00:00:00', 'ConnectingRodMasters(US)', '51');
INSERT INTO `account_summary` VALUES ('164', 'eBayMotors', '21', '2019-03-21 00:00:00', 'SuspensionMasters(US)', '57');
INSERT INTO `account_summary` VALUES ('165', 'eBayMotors', '10056', '2019-03-21 00:00:00', 'VehicalPartsLearder(QZ-US)', '12');
INSERT INTO `account_summary` VALUES ('166', 'eBayMotors', '48', '2019-03-21 00:00:00', 'tuningscenter(US)', '27');
INSERT INTO `account_summary` VALUES ('167', 'eBayMotors', '10', '2019-03-21 00:00:00', 'crazyautogo(US)', '13');
INSERT INTO `account_summary` VALUES ('168', 'eBayMotors', '72', '2019-03-21 00:00:00', 'parautoecommerce(US)', '26');
INSERT INTO `account_summary` VALUES ('169', 'eBayMotors', '2', '2019-03-21 00:00:00', 'tuningpartsmaster(us)', '21');
INSERT INTO `account_summary` VALUES ('170', 'Australia', '71', '2019-03-21 00:00:00', 'RacingPartsWorld(AU)', '9');
INSERT INTO `account_summary` VALUES ('171', 'US', '10012', '2019-03-21 00:00:00', 'AutoPartsMaMa(QX-US)', '5');
INSERT INTO `account_summary` VALUES ('172', 'eBayMotors', '10012', '2019-03-21 00:00:00', 'AutoPartsMaMa(QX-US)', '15');
INSERT INTO `account_summary` VALUES ('173', 'Australia', '10008', '2019-03-21 00:00:00', 'QX-AUTOTEILE(QX-AU)', '15');
INSERT INTO `account_summary` VALUES ('174', 'Australia', '42', '2019-03-21 00:00:00', 'RacingsWorld(AU)', '22');
INSERT INTO `account_summary` VALUES ('175', 'Australia', '4', '2019-03-21 00:00:00', 'maXpeedingrods-au(AU)', '26');
INSERT INTO `account_summary` VALUES ('176', 'Australia', '38', '2019-03-21 00:00:00', 'ATopTuning(AU)', '13');
INSERT INTO `account_summary` VALUES ('177', 'Australia', '10009', '2019-03-21 00:00:00', '888perfectauto(QX-AU)', '15');
INSERT INTO `account_summary` VALUES ('178', 'Spain', '51', '2019-03-21 00:00:00', 'tuningsmarket-es(ES)', '27');
INSERT INTO `account_summary` VALUES ('179', 'Italy', '10043', '2019-03-21 00:00:00', 'AutoPartsCenter-IT(IT)', '31');
INSERT INTO `account_summary` VALUES ('180', 'Spain', '10045', '2019-03-21 00:00:00', 'worldcarsparts(ES)', '18');
INSERT INTO `account_summary` VALUES ('181', 'Italy', '10046', '2019-03-21 00:00:00', 'TopAutoTurning(IT)', '19');
INSERT INTO `account_summary` VALUES ('182', 'France', '73', '2019-03-21 00:00:00', 'AutoModProfession(FR)', '54');
INSERT INTO `account_summary` VALUES ('183', 'Italy', '10028', '2019-03-21 00:00:00', 'TopVehicleParts-IT(IT)', '31');
INSERT INTO `account_summary` VALUES ('184', 'Spain', '57', '2019-03-21 00:00:00', 'ATopTuning-ES(ES)', '48');
INSERT INTO `account_summary` VALUES ('185', 'France', '59', '2019-03-21 00:00:00', 'ATopTuning-FR(FR)', '46');
INSERT INTO `account_summary` VALUES ('186', 'Italy', '46', '2019-03-21 00:00:00', 'AclassMotoring(IT)', '31');
INSERT INTO `account_summary` VALUES ('187', 'Spain', '82', '2019-03-21 00:00:00', 'TopCarParts-PL', '33');
INSERT INTO `account_summary` VALUES ('188', 'Spain', '10041', '2019-03-21 00:00:00', 'carreplacementshow(ES)', '31');
INSERT INTO `account_summary` VALUES ('189', 'Spain', '23', '2019-03-21 00:00:00', 'maXpeedingrods-es(ES)', '55');
INSERT INTO `account_summary` VALUES ('190', 'Spain', '10027', '2019-03-21 00:00:00', 'TuningShop-ES(ES)', '34');
INSERT INTO `account_summary` VALUES ('191', 'Italy', '10024', '2019-03-21 00:00:00', 'Negozio-di-corse(IT)', '28');
INSERT INTO `account_summary` VALUES ('192', 'Italy', '76', '2019-03-21 00:00:00', 'AutoModmall(IT)', '49');
INSERT INTO `account_summary` VALUES ('193', 'Italy', '55', '2019-03-21 00:00:00', 'ATopTuning-IT(IT)', '58');
INSERT INTO `account_summary` VALUES ('194', 'Italy', '25', '2019-03-21 00:00:00', 'maXpeedingrods-it(IT)', '51');
INSERT INTO `account_summary` VALUES ('195', 'UK', '10077', '2019-03-20 00:00:00', 'ProTuningTools(QZ-UK)', '13');
INSERT INTO `account_summary` VALUES ('196', 'UK', '10048', '2019-03-20 00:00:00', 'TuningUrVehicles(QZ-UK)', '13');
INSERT INTO `account_summary` VALUES ('197', 'UK', '10053', '2019-03-20 00:00:00', 'AutoKingCity(UK)', '48');
INSERT INTO `account_summary` VALUES ('198', 'UK', '10075', '2019-03-20 00:00:00', 'EaseReplacedParts(LMDV-UK)', '28');
INSERT INTO `account_summary` VALUES ('199', 'eBayMotors', '65', '2019-03-20 00:00:00', 'Autopartspeeding(US)', '7');
INSERT INTO `account_summary` VALUES ('200', 'Spain', '10112', '2019-03-20 00:00:00', 'racingdepotes(QZRES)', '46');
INSERT INTO `account_summary` VALUES ('201', 'UK', '10037', '2019-03-20 00:00:00', 'MaxRacingTech(QY-UK)', '1');
INSERT INTO `account_summary` VALUES ('202', 'Germany', '10068', '2019-03-20 00:00:00', 'Autosclub(LMDV-DE)', '9');
INSERT INTO `account_summary` VALUES ('203', 'US', '61', '2019-03-20 00:00:00', 'Aplusmarkets-US(US)', '1');
INSERT INTO `account_summary` VALUES ('204', 'France', '19', '2019-03-20 00:00:00', 'maXpeedingrods-fr(FR)', '169');
INSERT INTO `account_summary` VALUES ('205', 'Australia', '49', '2019-03-20 00:00:00', 'tuningscentertop(AU)', '5');
INSERT INTO `account_summary` VALUES ('206', 'France', '10102', '2019-03-20 00:00:00', 'Highspeedstore-FR(ZJHFR)', '1');
INSERT INTO `account_summary` VALUES ('207', 'Germany', '10088', '2019-03-20 00:00:00', 'Super-Auto-Welt(ZJDV-DE)', '2');
INSERT INTO `account_summary` VALUES ('208', 'UK', '10080', '2019-03-20 00:00:00', 'WellsellAutoParts(QZ-UK)', '9');
INSERT INTO `account_summary` VALUES ('209', 'Germany', '10100', '2019-03-20 00:00:00', 'Spitze-Autoteile(YLDE-DE)', '4');
INSERT INTO `account_summary` VALUES ('210', 'eBayMotors', '10014', '2019-03-20 00:00:00', 'TuningPartsKingdom(QX-US)', '4');
INSERT INTO `account_summary` VALUES ('211', 'France', '44', '2019-03-20 00:00:00', 'SuperModification(FR)', '57');
INSERT INTO `account_summary` VALUES ('212', 'UK', '10076', '2019-03-20 00:00:00', 'Racinghavens(LMDV-UK)', '11');
INSERT INTO `account_summary` VALUES ('213', 'UK', '10079', '2019-03-20 00:00:00', 'AutoSuspensionHouse(QZ-UK)', '18');
INSERT INTO `account_summary` VALUES ('214', 'UK', '10085', '2019-03-20 00:00:00', 'PerformanceWareHouses(QZ-UK)', '11');
INSERT INTO `account_summary` VALUES ('215', 'UK', '10039', '2019-03-20 00:00:00', 'OverworldMotor(QY-UK)', '1');
INSERT INTO `account_summary` VALUES ('216', 'UK', '10073', '2019-03-20 00:00:00', 'UpgradeAutoParts(LMDV-UK)', '62');
INSERT INTO `account_summary` VALUES ('217', 'UK', '10078', '2019-03-20 00:00:00', 'FuriousSpeedyParts(QZ-UK)', '103');
INSERT INTO `account_summary` VALUES ('218', 'UK', '10052', '2019-03-20 00:00:00', 'kingstuningmarket(UK)', '35');
INSERT INTO `account_summary` VALUES ('219', 'UK', '10083', '2019-03-20 00:00:00', 'MarvelousAutos(ZJDV-UK)', '1');
INSERT INTO `account_summary` VALUES ('220', 'UK', '10074', '2019-03-20 00:00:00', 'OnlyOneGarage(LMDV-UK)', '15');
INSERT INTO `account_summary` VALUES ('221', 'Italy', '10028', '2019-03-20 00:00:00', 'TopVehicleParts-IT(IT)', '28');
INSERT INTO `account_summary` VALUES ('222', 'Italy', '52', '2019-03-20 00:00:00', 'tuningsoutlet-it(IT)', '12');
INSERT INTO `account_summary` VALUES ('223', 'Italy', '10066', '2019-03-20 00:00:00', 'autograndpa(IT)', '36');
INSERT INTO `account_summary` VALUES ('224', 'Germany', '10072', '2019-03-20 00:00:00', 'torquesclub(ZJDV-DE)', '14');
INSERT INTO `account_summary` VALUES ('225', 'Germany', '10099', '2019-03-20 00:00:00', 'Pro-tuningparts(YLDE-DE)', '2');
INSERT INTO `account_summary` VALUES ('226', 'Germany', '10087', '2019-03-20 00:00:00', 'speedclub(ZJDV-DE)', '5');
INSERT INTO `account_summary` VALUES ('227', 'Germany', '10070', '2019-03-20 00:00:00', 'AutoteileFabrik(LMDV-DE)', '9');
INSERT INTO `account_summary` VALUES ('228', 'Germany', '10069', '2019-03-20 00:00:00', 'Motivecomponents(LMDV-DE)', '13');
INSERT INTO `account_summary` VALUES ('229', 'Germany', '10095', '2019-03-20 00:00:00', 'Autoteilearena(YLADE-DE)', '8');
INSERT INTO `account_summary` VALUES ('230', 'Germany', '10054', '2019-03-20 00:00:00', 'Super-KFZ-Teile(DE)', '103');
INSERT INTO `account_summary` VALUES ('231', 'Germany', '10101', '2019-03-20 00:00:00', 'Maxspeed-autoteile(YLDE-DE)', '1');
INSERT INTO `account_summary` VALUES ('232', 'Germany', '10067', '2019-03-20 00:00:00', 'tuningsclub(LMDV-DE)', '14');
INSERT INTO `account_summary` VALUES ('233', 'France', '10113', '2019-03-20 00:00:00', 'racingdepotfr(QZ-FR)', '2');
INSERT INTO `account_summary` VALUES ('234', 'eBayMotors', '75', '2019-03-20 00:00:00', 'autopapa-us(US)', '3');
INSERT INTO `account_summary` VALUES ('235', 'Australia', '31', '2019-03-20 00:00:00', 'SuspensionPlanet(AU)', '16');
INSERT INTO `account_summary` VALUES ('236', 'US', '10029', '2019-03-20 00:00:00', 'AUTOTEILE-PROFESSOR(QY-US)', '1');
INSERT INTO `account_summary` VALUES ('237', 'US', '33', '2019-03-20 00:00:00', 'TurbosIsland(US)', '1');
INSERT INTO `account_summary` VALUES ('238', 'US', '45', '2019-03-20 00:00:00', 'ShockPort(US)', '1');
INSERT INTO `account_summary` VALUES ('239', 'Italy', '10111', '2019-03-20 00:00:00', 'racingdepotit(QZRIT-IT)', '1');
INSERT INTO `account_summary` VALUES ('240', 'Germany', '10050', '2019-03-20 00:00:00', 'top-carsparts(QZ-DE)', '30');
INSERT INTO `account_summary` VALUES ('241', 'US', '10014', '2019-03-20 00:00:00', 'TuningPartsKingdom(QX-US)', '1');
INSERT INTO `account_summary` VALUES ('242', 'US', '10026', '2019-03-20 00:00:00', 'Speedingtech(QX-UK)', '1');
INSERT INTO `account_summary` VALUES ('243', 'eBayMotors', '14', '2019-03-20 00:00:00', 'MaxAutoClub(US)', '4');
INSERT INTO `account_summary` VALUES ('244', 'Australia', '4', '2019-03-20 00:00:00', 'maXpeedingrods-au(AU)', '20');
INSERT INTO `account_summary` VALUES ('245', 'eBayMotors', '10026', '2019-03-20 00:00:00', 'Speedingtech(QX-UK)', '1');
INSERT INTO `account_summary` VALUES ('246', 'Germany', '10055', '2019-03-20 00:00:00', 'Maxpower-Autoteile(DE)', '111');
INSERT INTO `account_summary` VALUES ('247', 'Germany', '10062', '2019-03-20 00:00:00', 'Spitze-Speed(QZ-DE)', '29');
INSERT INTO `account_summary` VALUES ('248', 'Australia', '10008', '2019-03-20 00:00:00', 'QX-AUTOTEILE(QX-AU)', '7');
INSERT INTO `account_summary` VALUES ('249', 'Australia', '10011', '2019-03-20 00:00:00', 'perfection_autofield(QX-AU)', '15');
INSERT INTO `account_summary` VALUES ('250', 'Australia', '6', '2019-03-20 00:00:00', 'AutoPartsDepot(AU)', '6');
INSERT INTO `account_summary` VALUES ('251', 'Australia', '42', '2019-03-20 00:00:00', 'RacingsWorld(AU)', '29');
INSERT INTO `account_summary` VALUES ('252', 'eBayMotors', '33', '2019-03-20 00:00:00', 'TurbosIsland(US)', '5');
INSERT INTO `account_summary` VALUES ('253', 'Italy', '46', '2019-03-20 00:00:00', 'AclassMotoring(IT)', '52');
INSERT INTO `account_summary` VALUES ('254', 'Australia', '67', '2019-03-20 00:00:00', 'Aplusmarkets-AU(AU)', '20');
INSERT INTO `account_summary` VALUES ('255', 'Australia', '47', '2019-03-20 00:00:00', 'AutosFactory(AU)', '24');
INSERT INTO `account_summary` VALUES ('256', 'Australia', '38', '2019-03-20 00:00:00', 'ATopTuning(AU)', '20');
INSERT INTO `account_summary` VALUES ('257', 'Australia', '30', '2019-03-20 00:00:00', 'TurboPlanet(AU)', '22');
INSERT INTO `account_summary` VALUES ('258', 'Germany', '10049', '2019-03-20 00:00:00', 'top-autosparts(QZ-DE)', '9');
INSERT INTO `account_summary` VALUES ('259', 'Germany', '10051', '2019-03-20 00:00:00', 'autoshop-de(QZ-DE)', '15');
INSERT INTO `account_summary` VALUES ('260', 'Australia', '10010', '2019-03-20 00:00:00', '666autopartsonline(QX-AU)', '9');
INSERT INTO `account_summary` VALUES ('261', 'Germany', '10064', '2019-03-20 00:00:00', 'infinitive-tuning(QZ-DE)', '17');
INSERT INTO `account_summary` VALUES ('262', 'Australia', '71', '2019-03-20 00:00:00', 'RacingPartsWorld(AU)', '8');
INSERT INTO `account_summary` VALUES ('263', 'Australia', '5', '2019-03-20 00:00:00', 'TurbochargerDepot(AU)', '20');
INSERT INTO `account_summary` VALUES ('264', 'Germany', '10063', '2019-03-20 00:00:00', 'KFZ-tuning-online(QZ-DE)', '29');
INSERT INTO `account_summary` VALUES ('265', 'Australia', '34', '2019-03-20 00:00:00', 'SuspensionIsland(AU)', '20');
INSERT INTO `account_summary` VALUES ('266', 'Germany', '10071', '2019-03-20 00:00:00', 'powersclub(ZJDV-DE)', '25');
INSERT INTO `account_summary` VALUES ('267', 'eBayMotors', '10013', '2019-03-20 00:00:00', 'AutoPartsSupermarket(QX-US)', '9');
INSERT INTO `account_summary` VALUES ('268', 'eBayMotors', '10029', '2019-03-20 00:00:00', 'AUTOTEILE-PROFESSOR(QY-US)', '2');
INSERT INTO `account_summary` VALUES ('269', 'eBayMotors', '70', '2019-03-20 00:00:00', 'popracingparts(US)', '10');
INSERT INTO `account_summary` VALUES ('270', 'eBayMotors', '77', '2019-03-20 00:00:00', 'AutoPartPart(US)', '9');
INSERT INTO `account_summary` VALUES ('271', 'eBayMotors', '10058', '2019-03-20 00:00:00', 'TuningPortal(QZ-US)', '17');
INSERT INTO `account_summary` VALUES ('272', 'US', '21', '2019-03-20 00:00:00', 'SuspensionMasters(US)', '1');
INSERT INTO `account_summary` VALUES ('273', 'eBayMotors', '10015', '2019-03-20 00:00:00', 'CarPartsParadise(QX-US)', '7');
INSERT INTO `account_summary` VALUES ('274', 'eBayMotors', '10060', '2019-03-20 00:00:00', 'VehicalHeaven(QZ-US)', '10');
INSERT INTO `account_summary` VALUES ('275', 'UK', '10047', '2019-03-20 00:00:00', 'OhMyGarage(QZ-UK)', '36');
INSERT INTO `account_summary` VALUES ('276', 'UK', '80', '2019-03-20 00:00:00', 'AutoParts-UKingdom(UK)', '14');
INSERT INTO `account_summary` VALUES ('277', 'UK', '79', '2019-03-20 00:00:00', 'TuningFans-Feast(UK)', '18');
INSERT INTO `account_summary` VALUES ('278', 'UK', '43', '2019-03-20 00:00:00', 'SpeedingParts(UK)', '20');
INSERT INTO `account_summary` VALUES ('279', 'UK', '26', '2019-03-20 00:00:00', 'TurbosEclub(UK)', '7');
INSERT INTO `account_summary` VALUES ('280', 'UK', '28', '2019-03-20 00:00:00', 'ConnectingrodEclub(UK)', '56');
INSERT INTO `account_summary` VALUES ('281', 'UK', '29', '2019-03-20 00:00:00', 'PARacingParts-UK(UK)', '15');
INSERT INTO `account_summary` VALUES ('282', 'UK', '39', '2019-03-20 00:00:00', 'CoolAutoClub(UK)', '66');
INSERT INTO `account_summary` VALUES ('283', 'UK', '27', '2019-03-20 00:00:00', 'SuspensionEclub(UK)', '57');
INSERT INTO `account_summary` VALUES ('284', 'eBayMotors', '50', '2019-03-20 00:00:00', 'tuningscentertag(US)', '11');
INSERT INTO `account_summary` VALUES ('285', 'UK', '24', '2019-03-20 00:00:00', 'AutoModMasters(UK)', '100');
INSERT INTO `account_summary` VALUES ('286', 'eBayMotors', '10056', '2019-03-20 00:00:00', 'VehicalPartsLearder(QZ-US)', '12');
INSERT INTO `account_summary` VALUES ('287', 'Italy', '10104', '2019-03-20 00:00:00', 'Powercarparts-IT(ZJPIT)', '6');
INSERT INTO `account_summary` VALUES ('288', 'Italy', '10046', '2019-03-20 00:00:00', 'TopAutoTurning(IT)', '18');
INSERT INTO `account_summary` VALUES ('289', 'eBayMotors', '48', '2019-03-20 00:00:00', 'tuningscenter(US)', '21');
INSERT INTO `account_summary` VALUES ('290', 'eBayMotors', '40', '2019-03-20 00:00:00', 'MotorBay(US)', '41');
INSERT INTO `account_summary` VALUES ('291', 'UK', '37', '2019-03-20 00:00:00', 'AutoModIsland(UK)', '11');
INSERT INTO `account_summary` VALUES ('292', 'eBayMotors', '85', '2019-03-20 00:00:00', 'AUTOTEILE-EXPERTS(US)', '9');
INSERT INTO `account_summary` VALUES ('293', 'eBayMotors', '3', '2019-03-20 00:00:00', 'powerracings(US)', '20');
INSERT INTO `account_summary` VALUES ('294', 'eBayMotors', '9', '2019-03-20 00:00:00', 'ttechnik(US)', '3');
INSERT INTO `account_summary` VALUES ('295', 'eBayMotors', '10061', '2019-03-20 00:00:00', 'TopCarParts(US)', '21');
INSERT INTO `account_summary` VALUES ('296', 'Australia', '11', '2019-03-20 00:00:00', 'tuningpartsdepot(AU)', '8');
INSERT INTO `account_summary` VALUES ('297', 'Australia', '12', '2019-03-20 00:00:00', '999aps(AU)', '28');
INSERT INTO `account_summary` VALUES ('298', 'Australia', '78', '2019-03-20 00:00:00', 'autopapa-au(AU)', '10');
INSERT INTO `account_summary` VALUES ('299', 'eBayMotors', '21', '2019-03-20 00:00:00', 'SuspensionMasters(US)', '31');
INSERT INTO `account_summary` VALUES ('300', 'eBayMotors', '10', '2019-03-20 00:00:00', 'crazyautogo(US)', '12');
INSERT INTO `account_summary` VALUES ('301', 'eBayMotors', '1', '2019-03-20 00:00:00', 'maxspeedingrods(us)', '32');
INSERT INTO `account_summary` VALUES ('302', 'eBayMotors', '72', '2019-03-20 00:00:00', 'parautoecommerce(US)', '24');
INSERT INTO `account_summary` VALUES ('303', 'eBayMotors', '41', '2019-03-20 00:00:00', 'BestRacings(US)', '29');
INSERT INTO `account_summary` VALUES ('304', 'eBayMotors', '83', '2019-03-20 00:00:00', 'Super-Autoteile(US)', '1');
INSERT INTO `account_summary` VALUES ('305', 'eBayMotors', '2', '2019-03-20 00:00:00', 'tuningpartsmaster(us)', '30');
INSERT INTO `account_summary` VALUES ('306', 'eBayMotors', '45', '2019-03-20 00:00:00', 'ShockPort(US)', '32');
INSERT INTO `account_summary` VALUES ('307', 'eBayMotors', '20', '2019-03-20 00:00:00', 'TurbosMasters(US)', '23');
INSERT INTO `account_summary` VALUES ('308', 'eBayMotors', '10012', '2019-03-20 00:00:00', 'AutoPartsMaMa(QX-US)', '25');
INSERT INTO `account_summary` VALUES ('309', 'eBayMotors', '36', '2019-03-20 00:00:00', 'AutoModPlanet(US)', '34');
INSERT INTO `account_summary` VALUES ('310', 'eBayMotors', '22', '2019-03-20 00:00:00', 'ConnectingRodMasters(US)', '47');
INSERT INTO `account_summary` VALUES ('311', 'eBayMotors', '13', '2019-03-20 00:00:00', 'maxspeedingrods-ca(US)', '41');
INSERT INTO `account_summary` VALUES ('312', 'eBayMotors', '8', '2019-03-20 00:00:00', 'Racing Parts Warehouse(US)', '48');
INSERT INTO `account_summary` VALUES ('313', 'US', '22', '2019-03-20 00:00:00', 'ConnectingRodMasters(US)', '2');
INSERT INTO `account_summary` VALUES ('314', 'US', '36', '2019-03-20 00:00:00', 'AutoModPlanet(US)', '1');
INSERT INTO `account_summary` VALUES ('315', 'eBayMotors', '61', '2019-03-20 00:00:00', 'Aplusmarkets-US(US)', '47');
INSERT INTO `account_summary` VALUES ('316', 'Australia', '84', '2019-03-20 00:00:00', 'top_auto_field(AU)', '7');
INSERT INTO `account_summary` VALUES ('317', 'Australia', '35', '2019-03-20 00:00:00', 'ConnectingrodIsland(AU)', '36');
INSERT INTO `account_summary` VALUES ('318', 'Australia', '10009', '2019-03-20 00:00:00', '888perfectauto(QX-AU)', '8');
INSERT INTO `account_summary` VALUES ('319', 'Australia', '32', '2019-03-20 00:00:00', 'ConnectingrodPlanet(AU)', '25');
INSERT INTO `account_summary` VALUES ('320', 'Spain', '23', '2019-03-20 00:00:00', 'maXpeedingrods-es(ES)', '51');
INSERT INTO `account_summary` VALUES ('321', 'France', '59', '2019-03-20 00:00:00', 'ATopTuning-FR(FR)', '52');
INSERT INTO `account_summary` VALUES ('322', 'France', '10065', '2019-03-20 00:00:00', 'autoexpertstore(FR)', '78');
INSERT INTO `account_summary` VALUES ('323', 'France', '10025', '2019-03-20 00:00:00', 'Parfait-autoparts(FR)', '33');
INSERT INTO `account_summary` VALUES ('324', 'France', '10105', '2019-03-20 00:00:00', 'TuningStudio-FR(LMTFR)', '13');
INSERT INTO `account_summary` VALUES ('325', 'Spain', '57', '2019-03-20 00:00:00', 'ATopTuning-ES(ES)', '39');
INSERT INTO `account_summary` VALUES ('326', 'France', '81', '2019-03-20 00:00:00', 'tpg-autoteile(AT)', '33');
INSERT INTO `account_summary` VALUES ('327', 'France', '73', '2019-03-20 00:00:00', 'AutoModProfession(FR)', '36');
INSERT INTO `account_summary` VALUES ('328', 'Spain', '10027', '2019-03-20 00:00:00', 'TuningShop-ES(ES)', '31');
INSERT INTO `account_summary` VALUES ('329', 'Italy', '76', '2019-03-20 00:00:00', 'AutoModmall(IT)', '37');
INSERT INTO `account_summary` VALUES ('330', 'Spain', '82', '2019-03-20 00:00:00', 'TopCarParts-PL', '42');
INSERT INTO `account_summary` VALUES ('331', 'Spain', '10045', '2019-03-20 00:00:00', 'worldcarsparts(ES)', '20');
INSERT INTO `account_summary` VALUES ('332', 'Spain', '51', '2019-03-20 00:00:00', 'tuningsmarket-es(ES)', '43');
INSERT INTO `account_summary` VALUES ('333', 'Spain', '10041', '2019-03-20 00:00:00', 'carreplacementshow(ES)', '25');
INSERT INTO `account_summary` VALUES ('334', 'France', '10040', '2019-03-20 00:00:00', 'Professionnel Parts(FR)', '37');
INSERT INTO `account_summary` VALUES ('335', 'France', '10044', '2019-03-20 00:00:00', 'MeilleurAutoPiece(FR)', '41');
INSERT INTO `account_summary` VALUES ('336', 'France', '69', '2019-03-20 00:00:00', 'Tuningsmarket-FR(FR)', '45');
INSERT INTO `account_summary` VALUES ('337', 'Italy', '25', '2019-03-20 00:00:00', 'maXpeedingrods-it(IT)', '51');
INSERT INTO `account_summary` VALUES ('338', 'Italy', '10043', '2019-03-20 00:00:00', 'AutoPartsCenter-IT(IT)', '32');
INSERT INTO `account_summary` VALUES ('339', 'Italy', '55', '2019-03-20 00:00:00', 'ATopTuning-IT(IT)', '34');
INSERT INTO `account_summary` VALUES ('340', 'Italy', '10092', '2019-03-20 00:00:00', 'Greatautopartsgo(ZJGDV-IT)', '1');
INSERT INTO `account_summary` VALUES ('341', 'Italy', '10024', '2019-03-20 00:00:00', 'Negozio-di-corse(IT)', '47');
INSERT INTO `account_summary` VALUES ('342', 'Spain', '74', '2019-03-20 00:00:00', 'AutoModDiscount(ES)', '17');


以上是通过几张表连接查询出来的数据

现在要实现的数据展示为:

Answer 1

使用MySQL的DATE_FORMAT()函数进行日期/时间格式化

语法格式如下

DATE_FORMAT(date,format)

DATE_FORMAT()函数用于格式化MySQL的日期时间显示。date 参数是要格式的日期/时间。format 日期/时间的输出格式。

针对你写的举个例子：SELECT DATE_FORMAT(createdOn, '%Y%m%e') AS day, COUNT(DATE_FORMAT(createdOn, '%Y%m%e')) AS times FROM userLogs WHERE userId=15 GROUP BY DATE_FORMAT(createdOn, '%Y%m%e');

format对应具体参数如下
格式 描述
%a 缩写星期名
%b 缩写月名
%c 月，数值
%D 带有英文前缀的月中的天
%d 月的天，数值(00-31)
%e 月的天，数值(0-31)
%f 微秒
%H 小时 (00-23)
%h 小时 (01-12)
%I 小时 (01-12)
%i 分钟，数值(00-59)
%j 年的天 (001-366)
%k 小时 (0-23)
%l 小时 (1-12)
%M 月名
%m 月，数值(00-12)
%p AM 或 PM
%r 时间，12-小时（hh:mm:ss AM 或 PM）
%S 秒(00-59)
%s 秒(00-59)
%T 时间, 24-小时 (hh:mm:ss)
%U 周 (00-53) 星期日是一周的第一天
%u 周 (00-53) 星期一是一周的第一天
%V 周 (01-53) 星期日是一周的第一天，与 %X 使用
%v 周 (01-53) 星期一是一周的第一天，与 %x 使用
%W 星期名
%w 周的天 （0=星期日, 6=星期六）
%X 年，其中的星期日是周的第一天，4 位，与 %V 使用
%x 年，其中的星期一是周的第一天，4 位，与 %v 使用
%Y 年，4 位
%y 年，2 位