Snippets.PRO

Tag "MySQL" (11)

PHP: doctrine sample

18.10.2013 11:51 col PHP 0 Comments

debug doctrine count querys ... Reveal Code

 'pdo_mysql',
    'user'     => 'root',
    'password' => 'test',
    'dbname'   => 'test',
);

$config = Setup::createAnnotationMetadataConfiguration($paths, $isDevMode);
$logger = new \Doctrine\DBAL\Logging\DebugStack();
$config->setSQLLogger($logger);
$entityManager = EntityManager::create($dbParams, $config);


/**
 * @Entity
 * @Table(name="shop")
 */
class Shop {

  /** @Id @GeneratedValue @Column(type="integer") */
  public $id;

  /** @Column(type="string") */
  public $name;

  /**
   * @OneToMany(targetEntity="Goods", mappedBy="shop")
   */
  public $goods;


  public function __construct() {
  }
}

/**
 * @Entity
 * @Table(name="goods")
 */
class Goods {

  /** @Id @GeneratedValue @Column(type="integer") */
  public $id;

  /** @Column(name="id_shop")*/
  public $idShop;

  /**
   * @ManyToOne(targetEntity="Shop", inversedBy="goods", fetch="EAGER")
   * @JoinColumn(name="id_shop", referencedColumnName="id")
   **/
  public $shop;

  /** @Column */
  public $name;

}

$shopRepository = $entityManager->getRepository('\Shop');
$shops = $shopRepository->findAll();

echo "\n";
//print_r($shops);

foreach ($shops as $shop) {
  //$shop->goods = null;
  //print_r($shop);


  echo $shop->id."-";
  echo count($shop->goods)."\n";
  foreach ($shop->goods as $goods) {
    echo $goods->name.";";
  }
  echo "\n";

}

foreach ($logger->queries as $q) {
  echo SqlFormatter::format($q['sql'])."
\r\n";
}

?>

865

MySQL: Vehicles (cars) database

24.06.2013 01:56 RedOctober MySQL 0 Comments

Vehicles database, two tables with vehicle's models and its marks ... Reveal Code

CREATE TABLE IF NOT EXISTS `list_vehicle_marks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mark` (`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=128 ;


INSERT INTO `list_vehicle_marks` (`id`, `value`) VALUES
(114, 'ZX'),
(113, 'Xin Kai'),
(112, 'Wiesmann'),
(111, 'Wartburg'),
(110, 'Volvo'),
(109, 'Volkswagen'),
(108, 'Vector'),
(107, 'TVR'),
(106, 'Trabant'),
(105, 'Toyota'),
(104, 'Tianye'),
(103, 'Tianma'),
(102, 'Tatra'),
(101, 'Suzuki'),
(100, 'Subaru'),
(99, 'SsangYong'),
(98, 'Spyker'),
(97, 'Smart'),
(96, 'Skoda'),
(95, 'ShuangHuan'),
(94, 'SEAT'),
(93, 'Scion'),
(92, 'Saturn'),
(91, 'Saleen'),
(90, 'Saab'),
(89, 'Rover'),
(88, 'Rolls-Royce'),
(87, 'Renault'),
(86, 'PUCH'),
(85, 'Proton'),
(84, 'Porsche'),
(83, 'Pontiac'),
(82, 'Plymouth'),
(81, 'Peugeot'),
(80, 'Pagani'),
(79, 'Opel'),
(78, 'Oldsmobile'),
(77, 'Nissan'),
(76, 'Morgan'),
(75, 'Mitsuoka'),
(74, 'Mitsubishi'),
(73, 'Mini'),
(72, 'Microcar'),
(71, 'MG'),
(70, 'Metrocab'),
(69, 'Mercury'),
(68, 'Mercedes-Benz'),
(67, 'Mazda'),
(66, 'Maybach'),
(65, 'Maserati'),
(64, 'Maruti'),
(63, 'Mahindra'),
(62, 'Lotus'),
(61, 'Lincoln'),
(60, 'Lifan'),
(59, 'Lexus'),
(58, 'Landwind'),
(57, 'Land Rover'),
(56, 'Lancia'),
(55, 'Lamborghini'),
(54, 'Koenigsegg'),
(53, 'Kia'),
(52, 'Jeep'),
(51, 'Jaguar'),
(50, 'JAC'),
(49, 'Isuzu'),
(48, 'Iran Khodro'),
(47, 'Infiniti'),
(46, 'Hyundai'),
(45, 'Hummer'),
(44, 'HuangHai'),
(43, 'Honda'),
(42, 'Hafei'),
(41, 'Great Wall'),
(40, 'GMC'),
(39, 'Geo'),
(38, 'Geely'),
(37, 'Ford'),
(36, 'Fiat'),
(35, 'Ferrari'),
(34, 'FAW'),
(33, 'Eagle'),
(32, 'Donkervoort'),
(31, 'Doninvest'),
(30, 'Dong Feng'),
(29, 'Dodge'),
(28, 'Derways'),
(27, 'Daimler'),
(26, 'Daihatsu'),
(25, 'Daewoo'),
(24, 'Dadi'),
(23, 'Dacia'),
(22, 'Coggiola'),
(21, 'Citroen'),
(20, 'Chrysler'),
(19, 'Chevrolet'),
(18, 'Chery'),
(17, 'ChangFeng'),
(16, 'Caterham'),
(15, 'Cadillac'),
(14, 'BYD'),
(13, 'Buick'),
(12, 'Bugatti'),
(11, 'Brilliance'),
(10, 'BMW'),
(9, 'Bentley'),
(8, 'Austin'),
(7, 'Audi'),
(6, 'Aston Martin'),
(5, 'Asia'),
(4, 'Aro'),
(3, 'Alpina'),
(2, 'Alfa Romeo'),
(1, 'Acura');

CREATE TABLE IF NOT EXISTS `list_vehicle_models` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mark_id` int(11) DEFAULT NULL COMMENT 'Link to `list_vehicle_marks`.`id`',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mark_id` (`mark_id`,`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1546 ;


INSERT INTO `list_vehicle_models` (`id`, `mark_id`, `value`) VALUES
(1402, 114, 'Landmark'),
(1401, 114, 'GrandTiger'),
(1400, 113, 'SUV X3'),
(1399, 113, 'SR-V X3'),
(1398, 113, 'PICKUP X3'),
(1397, 112, 'Roadster'),
(1396, 112, 'GT'),
(1395, 111, '353'),
(1394, 110, 'XC90'),
(1393, 110, 'XC70'),
(1392, 110, 'V70'),
(1391, 110, 'V50'),
(1390, 110, 'V40 Kombi'),
(1389, 110, 'S90'),
(1388, 110, 'S80'),
(1387, 110, 'S70'),
(1386, 110, 'S60'),
(1385, 110, 'S40'),
(1384, 110, 'C70'),
(1383, 110, 'C30'),
(1382, 110, '960'),
(1381, 110, '940'),
(1380, 110, '850'),
(1379, 110, '780 Bertone'),
(1378, 110, '760'),
(1377, 110, '740'),
(1376, 110, '480 E'),
(1375, 110, '460 L'),
(1374, 110, '440 K'),
(1373, 110, '340-360'),
(1372, 110, '240'),
(1371, 110, '164'),
(1370, 109, 'Vento'),
(1369, 109, 'Touran'),
(1368, 109, 'Touareg'),
(1367, 109, 'Tiguan'),
(1366, 109, 'Taro'),
(1365, 109, 'Sharan'),
(1364, 109, 'Scirocco'),
(1363, 109, 'Santana'),
(1362, 109, 'Polo'),
(1361, 109, 'Pointer'),
(1360, 109, 'Phaeton'),
(1359, 109, 'Passat'),
(1358, 109, 'NEW Beetle'),
(1357, 109, 'Multivan'),
(1356, 109, 'Lupo'),
(1355, 109, 'Kaefer'),
(1354, 109, 'Jetta'),
(1353, 109, 'Golf Plus'),
(1352, 109, 'Golf'),
(1351, 109, 'Fox'),
(1350, 109, 'Eos'),
(1349, 109, 'Corrado'),
(1348, 109, 'Caddy'),
(1347, 109, 'Bora'),
(1346, 108, 'W8 Twin Turbo'),
(1345, 107, 'Griffith'),
(1344, 106, 'P 601'),
(1343, 105, 'Yaris Verso'),
(1342, 105, 'Yaris'),
(1341, 105, 'Wish'),
(1340, 105, 'Windom'),
(1339, 105, 'Will'),
(1338, 105, 'Voxy'),
(1337, 105, 'Voltz'),
(1336, 105, 'Vitz'),
(1335, 105, 'Vista'),
(1334, 105, 'Verossa'),
(1333, 105, 'Venza'),
(1332, 105, 'Vellfire'),
(1331, 105, 'Tundra'),
(1330, 105, 'Tercel'),
(1329, 105, 'Tacoma'),
(1328, 105, 'Supra'),
(1327, 105, 'Succeed'),
(1326, 105, 'Starlet'),
(1325, 105, 'Sprinter'),
(1324, 105, 'Sparky'),
(1323, 105, 'Solara'),
(1322, 105, 'Soarer'),
(1321, 105, 'Sienta'),
(1320, 105, 'Sienna'),
(1319, 105, 'Sera'),
(1318, 105, 'Sequoia'),
(1317, 105, 'Scepter'),
(1316, 105, 'Regius Ace'),
(1315, 105, 'Regius'),
(1314, 105, 'Regius'),
(1313, 105, 'Raum'),
(1312, 105, 'Ractis'),
(1311, 105, 'RAV 4'),
(1310, 105, 'Pronard'),
(1309, 105, 'Progres'),
(1308, 105, 'Probox'),
(1307, 105, 'Prius'),
(1306, 105, 'Previa'),
(1305, 105, 'Premio'),
(1304, 105, 'Porte'),
(1303, 105, 'Platz'),
(1302, 105, 'Picnic'),
(1301, 105, 'Passo'),
(1300, 105, 'Paseo'),
(1299, 105, 'Origin'),
(1298, 105, 'Opa'),
(1297, 105, 'Noah'),
(1296, 105, 'Nadia'),
(1295, 105, 'Matrix'),
(1294, 105, 'MasterAce'),
(1293, 105, 'Mark X'),
(1292, 105, 'Mark II'),
(1291, 105, 'MR-S'),
(1290, 105, 'MR 2'),
(1289, 105, 'Lite Ace'),
(1288, 105, 'Land Cruiser 80'),
(1287, 105, 'Land Cruiser 70'),
(1286, 105, 'Land Cruiser 200'),
(1285, 105, 'Land Cruiser 100'),
(1284, 105, 'Land Cruiser (90) Prado'),
(1283, 105, 'Land Cruiser (120) Prado'),
(1282, 105, 'Land Cruiser'),
(1281, 105, 'Kluger'),
(1280, 105, 'Ist'),
(1279, 105, 'Ipsum'),
(1278, 105, 'ISis'),
(1277, 105, 'Hilux Surf'),
(1276, 105, 'Hilux Pick Up'),
(1275, 105, 'Highlander'),
(1274, 105, 'Hiace'),
(1273, 105, 'Harrier'),
(1272, 105, 'Granvia'),
(1271, 105, 'Grand Hiace'),
(1270, 105, 'Gaia'),
(1269, 105, 'Funcargo'),
(1268, 105, 'Fortuner'),
(1267, 105, 'FJ Cruiser'),
(1266, 105, 'Estima'),
(1265, 105, 'Echo'),
(1264, 105, 'Duet'),
(1263, 105, 'Cynos'),
(1262, 105, 'Curren'),
(1261, 105, 'Crown Majesta'),
(1260, 105, 'Crown Athlete'),
(1259, 105, 'Crown'),
(1258, 105, 'Crown'),
(1257, 105, 'Cresta'),
(1256, 105, 'Cressida'),
(1255, 105, 'Corsa'),
(1254, 105, 'Corona'),
(1253, 105, 'Corolla Verso'),
(1252, 105, 'Corolla Spacio'),
(1251, 105, 'Corolla RunX'),
(1250, 105, 'Corolla Rumion'),
(1249, 105, 'Corolla Levin'),
(1248, 105, 'Corolla Fielder'),
(1247, 105, 'Corolla FX'),
(1246, 105, 'Corolla Ceres'),
(1245, 105, 'Corolla'),
(1244, 105, 'Corolla'),
(1243, 105, 'Chaser'),
(1242, 105, 'Celica'),
(1241, 105, 'Cavalier'),
(1240, 105, 'Carina ED'),
(1239, 105, 'Carina E'),
(1238, 105, 'Carina'),
(1237, 105, 'Carib'),
(1236, 105, 'Camry Solara'),
(1235, 105, 'Camry'),
(1234, 105, 'Cami'),
(1233, 105, 'Caldina'),
(1232, 105, 'Brevis'),
(1231, 105, 'BB'),
(1230, 105, 'Avensis Verso'),
(1229, 105, 'Avensis'),
(1228, 105, 'Avalon'),
(1227, 105, 'Auris'),
(1226, 105, 'Aurion'),
(1225, 105, 'Aristo'),
(1224, 105, 'Altezza'),
(1223, 105, 'Alphard'),
(1222, 105, 'Allion'),
(1221, 105, 'Allex'),
(1220, 105, '4runner'),
(1219, 104, 'Admiral'),
(1218, 103, 'Century'),
(1217, 102, 'T613'),
(1216, 101, 'XL7'),
(1215, 101, 'X-90'),
(1214, 101, 'Wagon R+'),
(1213, 101, 'Vitara'),
(1212, 101, 'Verona'),
(1211, 101, 'Swift'),
(1210, 101, 'Sidekick'),
(1209, 101, 'Samurai'),
(1208, 101, 'SX4'),
(1207, 101, 'MR Wagon'),
(1206, 101, 'Liana'),
(1205, 101, 'Kei'),
(1204, 101, 'Jimny'),
(1203, 101, 'Ignis'),
(1202, 101, 'Grand Vitara'),
(1201, 101, 'Forenza'),
(1200, 101, 'Every Landy'),
(1199, 101, 'Every'),
(1198, 101, 'Escudo'),
(1197, 101, 'Cultus Wagon'),
(1196, 101, 'Baleno'),
(1195, 101, 'Alto'),
(1194, 101, 'Aerio'),
(1193, 100, 'XT'),
(1192, 100, 'Vivio'),
(1191, 100, 'Tribeca'),
(1190, 100, 'Traviq'),
(1189, 100, 'Stella'),
(1188, 100, 'SVX'),
(1187, 100, 'R2'),
(1186, 100, 'Pleo'),
(1185, 100, 'Outback'),
(1184, 100, 'Libero'),
(1183, 100, 'Leone'),
(1182, 100, 'Legacy'),
(1181, 100, 'Justy'),
(1180, 100, 'Impreza WRX'),
(1179, 100, 'Impreza'),
(1178, 100, 'Forester'),
(1177, 100, 'Baja'),
(1176, 99, 'Tager'),
(1175, 99, 'Rodius'),
(1174, 99, 'Rexton'),
(1173, 99, 'Musso'),
(1172, 99, 'Kyron'),
(1171, 99, 'Korando'),
(1170, 99, 'Istana'),
(1169, 99, 'Family'),
(1168, 99, 'Chairman'),
(1167, 99, 'Actyon'),
(1166, 98, 'C8'),
(1165, 97, 'Roadster'),
(1164, 97, 'Fortwo'),
(1163, 97, 'Forfour'),
(1162, 97, 'Crossblade'),
(1161, 96, 'Superb'),
(1160, 96, 'Roomster'),
(1159, 96, 'Octavia Scout'),
(1158, 96, 'Octavia'),
(1157, 96, 'Felicia'),
(1156, 96, 'Favorit'),
(1155, 96, 'Fabia'),
(1154, 95, 'Sceo'),
(1153, 94, 'Toledo'),
(1152, 94, 'Ronda'),
(1151, 94, 'Malaga'),
(1150, 94, 'Leon'),
(1149, 94, 'Ibiza'),
(1148, 94, 'Cordoba'),
(1147, 94, 'Arosa'),
(1146, 94, 'Altea'),
(1145, 94, 'Alhambra'),
(1144, 93, 'xB'),
(1143, 93, 'xA'),
(1142, 93, 'tC'),
(1141, 92, 'VUE'),
(1140, 92, 'SL'),
(1139, 92, 'SC'),
(1138, 92, 'LS'),
(1137, 92, 'ION'),
(1136, 91, 'S7'),
(1135, 90, '9000'),
(1134, 90, '900'),
(1133, 90, '99'),
(1132, 90, '9-7X'),
(1131, 90, '9-5'),
(1130, 90, '9-3'),
(1129, 90, '9-2X'),
(1128, 89, 'Montego'),
(1127, 89, 'Mini MK'),
(1126, 89, 'Maestro'),
(1125, 89, '800'),
(1124, 89, '600'),
(1123, 89, '400'),
(1122, 89, '200'),
(1121, 89, '75'),
(1120, 89, '45'),
(1119, 89, '25'),
(1118, 88, 'Silver Spur'),
(1117, 88, 'Silver Seraph'),
(1116, 88, 'Phantom Drophead Coupe'),
(1115, 88, 'Phantom'),
(1114, 88, 'Corniche Cabrio'),
(1113, 87, 'Vel Satis'),
(1112, 87, 'Twingo'),
(1111, 87, 'Trafic'),
(1110, 87, 'Symbol'),
(1109, 87, 'Super 5'),
(1108, 87, 'Scenic RX'),
(1107, 87, 'Scenic'),
(1106, 87, 'Safrane'),
(1105, 87, 'Rapid'),
(1104, 87, 'Modus'),
(1103, 87, 'Megane'),
(1102, 87, 'Master'),
(1101, 87, 'Logan'),
(1100, 87, 'Laguna'),
(1099, 87, 'Kangoo Passenger'),
(1098, 87, 'Kangoo Express'),
(1097, 87, 'Grand Scenic'),
(1096, 87, 'Fuego'),
(1095, 87, 'Espace'),
(1094, 87, 'Clio Symbol'),
(1093, 87, 'Clio'),
(1092, 87, 'Avantime'),
(1091, 87, '25'),
(1090, 87, '21'),
(1089, 87, '20'),
(1088, 87, '19'),
(1087, 87, '18'),
(1086, 87, '11'),
(1085, 87, '9'),
(1084, 87, '5'),
(1083, 86, 'Pinzgauer'),
(1082, 86, 'G-modell'),
(1081, 85, 'Persona 400'),
(1080, 85, 'Persona 300 Compact'),
(1079, 84, 'Cayman'),
(1078, 84, 'Cayenne'),
(1077, 84, 'Carrera GT'),
(1076, 84, 'Boxster'),
(1075, 84, '968'),
(1074, 84, '944'),
(1073, 84, '928'),
(1072, 84, '924'),
(1071, 84, '911'),
(1070, 83, 'Vibe'),
(1069, 83, 'Trans Sport'),
(1068, 83, 'Sunfire'),
(1067, 83, 'Sunbird'),
(1066, 83, 'Solstige'),
(1065, 83, 'Phoenix'),
(1064, 83, 'Grand Prix'),
(1063, 83, 'Grand AM'),
(1062, 83, 'GTO'),
(1061, 83, 'Firebird'),
(1060, 83, 'Bonneville'),
(1059, 83, 'Aztec'),
(1058, 83, '6000'),
(1057, 82, 'Voyager'),
(1056, 82, 'Sundance'),
(1055, 82, 'Prowler'),
(1054, 82, 'Neon'),
(1053, 82, 'Laser'),
(1052, 82, 'Grand Voyager'),
(1051, 82, 'Breeze'),
(1050, 82, 'Acclaim'),
(1049, 81, '4007'),
(1048, 81, '1007'),
(1047, 81, '807'),
(1046, 81, '806'),
(1045, 81, '607'),
(1044, 81, '605'),
(1043, 81, '407'),
(1042, 81, '406'),
(1041, 81, '405'),
(1040, 81, '309'),
(1039, 81, '308'),
(1038, 81, '307'),
(1037, 81, '306'),
(1036, 81, '305'),
(1035, 81, '207'),
(1034, 81, '206'),
(1033, 81, '205'),
(1032, 81, '107'),
(1031, 81, '106'),
(1030, 80, 'Zonda C12'),
(1029, 79, 'Zafira'),
(1028, 79, 'Vita'),
(1027, 79, 'Vectra'),
(1026, 79, 'Tigra'),
(1025, 79, 'Speedster'),
(1024, 79, 'Sintra'),
(1023, 79, 'Signum'),
(1022, 79, 'Senator'),
(1021, 79, 'Rekord'),
(1020, 79, 'Omega'),
(1019, 79, 'Movano'),
(1018, 79, 'Monterey'),
(1017, 79, 'Meriva'),
(1016, 79, 'Manta'),
(1015, 79, 'Kadett'),
(1014, 79, 'GT'),
(1013, 79, 'Frontera'),
(1012, 79, 'Corsa OPC'),
(1011, 79, 'Corsa'),
(1010, 79, 'Commodore'),
(1009, 79, 'Combo'),
(1008, 79, 'Campo'),
(1007, 79, 'Calibra'),
(1006, 79, 'Astra OPC'),
(1005, 79, 'Astra'),
(1004, 79, 'Ascona'),
(1003, 79, 'Antara'),
(1002, 79, 'Agila'),
(1001, 78, 'Silhouette'),
(1000, 78, 'Cutlass'),
(999, 78, 'Bravada'),
(998, 78, 'Aurora'),
(997, 78, 'Alero'),
(996, 78, 'Achieva'),
(995, 77, 'X-Trail'),
(994, 77, 'X-Terra'),
(993, 77, 'Wingroad'),
(992, 77, 'Vanette'),
(991, 77, 'Urvan'),
(990, 77, 'Titan'),
(989, 77, 'Tino'),
(988, 77, 'Tiida'),
(987, 77, 'Terrano'),
(986, 77, 'Teana'),
(985, 77, 'Sunny'),
(984, 77, 'Stanza'),
(983, 77, 'Stagea'),
(982, 77, 'Skyline'),
(981, 77, 'Silvia'),
(980, 77, 'Serena'),
(979, 77, 'Sentra'),
(978, 77, 'Safari'),
(977, 77, 'Rogue'),
(976, 77, 'Rasheen'),
(975, 77, 'R Nessa'),
(974, 77, 'Quest'),
(973, 77, 'Qashqai'),
(972, 77, 'Pulsar'),
(971, 77, 'Primera'),
(970, 77, 'Presea'),
(969, 77, 'Presage'),
(968, 77, 'Prairie'),
(967, 77, 'Pick UP'),
(966, 77, 'Patrol'),
(965, 77, 'Pathfinder'),
(964, 77, 'Note'),
(963, 77, 'Navara'),
(962, 77, 'Murano'),
(961, 77, 'Moco'),
(960, 77, 'Mistral'),
(959, 77, 'Micra'),
(958, 77, 'Maxima'),
(957, 77, 'March'),
(956, 77, 'Lucino'),
(955, 77, 'Liberty'),
(954, 77, 'Leopard'),
(953, 77, 'Laurel'),
(952, 77, 'Largo'),
(951, 77, 'Lafesta'),
(950, 77, 'King Cab'),
(949, 77, 'Gloria'),
(948, 77, 'GT-R'),
(947, 77, 'Fuga'),
(946, 77, 'Frontier'),
(945, 77, 'Fairlady'),
(944, 77, 'Expert'),
(943, 77, 'Elgrand'),
(942, 77, 'Datsun'),
(941, 77, 'Cube'),
(940, 77, 'Cima'),
(939, 77, 'Cherry'),
(938, 77, 'Cefiro'),
(937, 77, 'Cedric'),
(936, 77, 'Bluebird'),
(935, 77, 'Bassara'),
(934, 77, 'Avenir'),
(933, 77, 'Armada'),
(932, 77, 'Altima'),
(931, 77, 'Almera Tino'),
(930, 77, 'Almera Classic'),
(929, 77, 'Almera'),
(928, 77, 'AD'),
(927, 77, '350Z'),
(926, 77, '300 ZX'),
(925, 77, '200 SX'),
(924, 77, '100 NX'),
(923, 76, 'Aero 8'),
(922, 75, 'Le-Seyde'),
(921, 75, 'Le-Sayde'),
(920, 75, 'Galue'),
(919, 74, 'i'),
(918, 74, 'Town BOX'),
(917, 74, 'Starion'),
(916, 74, 'Space Wagon'),
(915, 74, 'Space Star'),
(914, 74, 'Space Runner'),
(913, 74, 'Space Gear'),
(912, 74, 'Sigma'),
(911, 74, 'Sapporo'),
(910, 74, 'RVR'),
(909, 74, 'Pajero Sport'),
(908, 74, 'Pajero'),
(907, 74, 'Outlander'),
(906, 74, 'Montero Sport'),
(905, 74, 'Montero'),
(904, 74, 'Mirage'),
(903, 74, 'Minica'),
(902, 74, 'Libero'),
(901, 74, 'Legnum'),
(900, 74, 'Lancer Evolution'),
(899, 74, 'Lancer Cedia'),
(898, 74, 'Lancer'),
(897, 74, 'Lancer'),
(896, 74, 'L 200'),
(895, 74, 'Grandis'),
(894, 74, 'Galant'),
(893, 74, 'GTO'),
(892, 74, 'FTO'),
(891, 74, 'Endeavor'),
(890, 74, 'Emeraude'),
(889, 74, 'Eclipse'),
(888, 74, 'EK Wagon'),
(887, 74, 'Dion'),
(886, 74, 'Dingo'),
(885, 74, 'Diamante'),
(884, 74, 'Delica'),
(883, 74, 'Debonair'),
(882, 74, 'Colt'),
(881, 74, 'Chariot'),
(880, 74, 'Challenger'),
(879, 74, 'Carisma'),
(878, 74, 'Aspire'),
(877, 74, 'Airtrek'),
(876, 74, '3000 GT'),
(875, 73, 'One'),
(874, 73, 'Cooper'),
(873, 73, 'Clubman'),
(872, 72, 'MC1'),
(871, 71, 'ZT'),
(870, 71, 'ZR'),
(869, 71, 'TF'),
(868, 71, 'MGF'),
(867, 71, 'MGB'),
(866, 70, 'Taxi  (II -series)'),
(865, 69, 'Villager'),
(864, 69, 'Tracer'),
(863, 69, 'Topaz'),
(862, 69, 'Sable'),
(861, 69, 'Mystique'),
(860, 69, 'Mountaineer'),
(859, 69, 'Montego'),
(858, 69, 'Mariner'),
(857, 69, 'Grand Marquis'),
(856, 69, 'Cougar'),
(855, 69, 'Capri'),
(854, 68, 'Viano'),
(853, 68, 'Vaneo'),
(852, 68, 'V-klasse V 280'),
(851, 68, 'V-klasse V 230'),
(850, 68, 'V-klasse V 220'),
(849, 68, 'V-klasse V 200'),
(848, 68, 'SLR McLaren'),
(847, 68, 'SLK-klasse SLK 55 AMG'),
(846, 68, 'SLK-klasse SLK 350'),
(845, 68, 'SLK-klasse SLK 320'),
(844, 68, 'SLK-klasse SLK 32 AMG'),
(843, 68, 'SLK-klasse SLK 280'),
(842, 68, 'SLK-klasse SLK 230'),
(841, 68, 'SLK-klasse SLK 200'),
(840, 68, 'SL-klasse SL 65 AMG'),
(839, 68, 'SL-klasse SL 63 AMG'),
(838, 68, 'SL-klasse SL 600'),
(837, 68, 'SL-klasse SL 55 AMG'),
(836, 68, 'SL-klasse SL 500'),
(835, 68, 'SL-klasse SL 450'),
(834, 68, 'SL-klasse SL 420'),
(833, 68, 'SL-klasse SL 380'),
(832, 68, 'SL-klasse SL 350'),
(831, 68, 'SL-klasse SL 320'),
(830, 68, 'SL-klasse SL 300'),
(829, 68, 'SL-klasse SL 280'),
(828, 68, 'S-klasse S 65 AMG'),
(827, 68, 'S-klasse S 600'),
(826, 68, 'S-klasse S 560'),
(825, 68, 'S-klasse S 550'),
(824, 68, 'S-klasse S 55 AMG'),
(823, 68, 'S-klasse S 500'),
(822, 68, 'S-klasse S 450'),
(821, 68, 'S-klasse S 430'),
(820, 68, 'S-klasse S 420'),
(819, 68, 'S-klasse S 400'),
(818, 68, 'S-klasse S 380'),
(817, 68, 'S-klasse S 350'),
(816, 68, 'S-klasse S 320'),
(815, 68, 'S-klasse S 300'),
(814, 68, 'S-klasse S 280'),
(813, 68, 'S-klasse S 260'),
(812, 68, 'R-klasse R 500'),
(811, 68, 'R-klasse R 350'),
(810, 68, 'R-klasse R 320'),
(809, 68, 'R-klasse'),
(808, 68, 'Pullmann'),
(807, 68, 'M-klasse ML 63 AMG'),
(806, 68, 'M-klasse ML 55 AMG'),
(805, 68, 'M-klasse ML 500'),
(804, 68, 'M-klasse ML 430'),
(803, 68, 'M-klasse ML 400'),
(802, 68, 'M-klasse ML 350'),
(801, 68, 'M-klasse ML 320'),
(800, 68, 'M-klasse ML 280'),
(799, 68, 'M-klasse ML 270'),
(798, 68, 'M-klasse ML 230'),
(797, 68, 'GL-klasse GL 550'),
(796, 68, 'GL-klasse GL 500'),
(795, 68, 'GL-klasse GL 450'),
(794, 68, 'GL-klasse GL 420'),
(793, 68, 'GL-klasse GL 320'),
(792, 68, 'G-Klasse G 55 AMG'),
(791, 68, 'G-Klasse G 500'),
(790, 68, 'G-Klasse G 400'),
(789, 68, 'G-Klasse G 350'),
(788, 68, 'G-Klasse G 320'),
(787, 68, 'G-Klasse G 300'),
(786, 68, 'G-Klasse G 290'),
(785, 68, 'G-Klasse G 280'),
(784, 68, 'G-Klasse G 270'),
(783, 68, 'G-Klasse G 250'),
(782, 68, 'G-Klasse G 230'),
(781, 68, 'E-klasse E 63 AMG'),
(780, 68, 'E-klasse E 55 AMG'),
(779, 68, 'E-klasse E 500'),
(778, 68, 'E-klasse E 50 AMG'),
(777, 68, 'E-klasse E 430'),
(776, 68, 'E-klasse E 420'),
(775, 68, 'E-klasse E 400'),
(774, 68, 'E-klasse E 350'),
(773, 68, 'E-klasse E 320'),
(772, 68, 'E-klasse E 300'),
(771, 68, 'E-klasse E 290'),
(770, 68, 'E-klasse E 280'),
(769, 68, 'E-klasse E 270'),
(768, 68, 'E-klasse E 250'),
(767, 68, 'E-klasse E 240'),
(766, 68, 'E-klasse E 230'),
(765, 68, 'E-klasse E 220'),
(764, 68, 'E-klasse E 200'),
(763, 68, 'CLS-klasse CLS 63 AMG'),
(762, 68, 'CLS-klasse CLS 55 AMG'),
(761, 68, 'CLS-klasse CLS 500'),
(760, 68, 'CLS-klasse CLS 350'),
(759, 68, 'CLS-klasse CLS 320'),
(758, 68, 'CLK-klasse CLK 63 AMG'),
(757, 68, 'CLK-klasse CLK 55 AMG'),
(756, 68, 'CLK-klasse CLK 500'),
(755, 68, 'CLK-klasse CLK 430'),
(754, 68, 'CLK-klasse CLK 350'),
(753, 68, 'CLK-klasse CLK 320'),
(752, 68, 'CLK-klasse CLK 270'),
(751, 68, 'CLK-klasse CLK 240'),
(750, 68, 'CLK-klasse CLK 230'),
(749, 68, 'CLK-klasse CLK 220'),
(748, 68, 'CLK-klasse CLK 200'),
(747, 68, 'CLC-klasse CLC 220 CDI'),
(746, 68, 'CL-Klasse CL 65 AMG'),
(745, 68, 'CL-Klasse CL 63 AMG'),
(744, 68, 'CL-Klasse CL 600'),
(743, 68, 'CL-Klasse CL 55 AMG'),
(742, 68, 'CL-Klasse CL 500'),
(741, 68, 'CL-Klasse CL 420'),
(740, 68, 'C-klasse C 63 AMG'),
(739, 68, 'C-klasse C 55 AMG'),
(738, 68, 'C-klasse C 36 AMG'),
(737, 68, 'C-klasse C 350'),
(736, 68, 'C-klasse C 320'),
(735, 68, 'C-klasse C 32 AMG'),
(734, 68, 'C-klasse C 280'),
(733, 68, 'C-klasse C 270'),
(732, 68, 'C-klasse C 250'),
(731, 68, 'C-klasse C 240'),
(730, 68, 'C-klasse C 230'),
(729, 68, 'C-klasse C 220'),
(728, 68, 'C-klasse C 200'),
(727, 68, 'C-klasse C 180'),
(726, 68, 'B-klasse B 200'),
(725, 68, 'B-klasse B 180'),
(724, 68, 'B-klasse B 170'),
(723, 68, 'A-klasse A 210'),
(722, 68, 'A-klasse A 200'),
(721, 68, 'A-klasse A 190'),
(720, 68, 'A-klasse A 180'),
(719, 68, 'A-klasse A 170'),
(718, 68, 'A-klasse A 160'),
(717, 68, 'A-klasse A 150'),
(716, 68, 'A-klasse A 140'),
(715, 68, '500'),
(714, 68, '300'),
(713, 68, '280'),
(712, 68, '260'),
(711, 68, '250'),
(710, 68, '240'),
(709, 68, '230'),
(708, 68, '220'),
(707, 68, '200'),
(706, 68, '190'),
(705, 68, '/8'),
(704, 68, ' T-mod.'),
(703, 68, ' Coupe'),
(702, 68, ' Cabrio'),
(701, 67, 'Xedos 9'),
(700, 67, 'Xedos 6'),
(699, 67, 'Verisa'),
(698, 67, 'Tribute'),
(697, 67, 'Rx-8'),
(696, 67, 'Roadster'),
(695, 67, 'RX 7'),
(694, 67, 'Protege'),
(693, 67, 'Premacy'),
(692, 67, 'Mx-6'),
(691, 67, 'Mx-5'),
(690, 67, 'Mx-3'),
(689, 67, 'Millenia'),
(688, 67, 'Mazda 6 MPS'),
(687, 67, 'Mazda 6'),
(686, 67, 'Mazda 5'),
(685, 67, 'Mazda 3 MPS'),
(684, 67, 'Mazda 3'),
(683, 67, 'Mazda 2'),
(682, 67, 'MPV'),
(681, 67, 'Luce'),
(680, 67, 'Levante'),
(679, 67, 'Lantis'),
(678, 67, 'Familia'),
(677, 67, 'Eunos Cosmo'),
(676, 67, 'Eunos 500'),
(675, 67, 'E 2000,2200 Bus'),
(674, 67, 'Demio'),
(673, 67, 'Carol'),
(672, 67, 'Capella'),
(671, 67, 'CX-9'),
(670, 67, 'CX-7'),
(669, 67, 'Bongo'),
(668, 67, 'BT-50'),
(667, 67, 'B-serie'),
(666, 67, 'Az-wagon'),
(665, 67, 'Axela'),
(664, 67, 'Atenza'),
(663, 67, '929'),
(662, 67, '626'),
(661, 67, '323'),
(660, 67, '121'),
(659, 66, 'Maybach 57 и Maybach 62'),
(658, 66, 'Maybach 57 S и Maybach 62 S'),
(657, 65, 'Spyder'),
(656, 65, 'Quattroporte'),
(655, 65, 'GranTurismo'),
(654, 65, 'GranSport'),
(653, 65, 'Coupe'),
(652, 65, 'Biturbo'),
(651, 65, '4300 GT Coupe'),
(650, 65, '3200 GT'),
(649, 65, '228'),
(648, 64, 'Alto'),
(647, 63, 'Marshal'),
(646, 62, 'Super 7'),
(645, 62, 'Exige'),
(644, 62, 'Elise'),
(643, 61, 'Zephyr'),
(642, 61, 'Town Car'),
(641, 61, 'Navigator'),
(640, 61, 'Mark LT'),
(639, 61, 'Mark'),
(638, 61, 'MKZ'),
(637, 61, 'MKX'),
(636, 61, 'LS'),
(635, 61, 'Continental'),
(634, 61, 'Aviator'),
(633, 60, 'Breez (520)'),
(632, 59, 'SC 430'),
(631, 59, 'SC 400'),
(630, 59, 'SC 300'),
(629, 59, 'RX 400h'),
(628, 59, 'RX 350'),
(627, 59, 'RX 330'),
(626, 59, 'RX 300'),
(625, 59, 'LX 570'),
(624, 59, 'LX 470'),
(623, 59, 'LX 450'),
(622, 59, 'LS 600'),
(621, 59, 'LS 460'),
(620, 59, 'LS 430'),
(619, 59, 'LS 400'),
(618, 59, 'IS-F'),
(617, 59, 'IS 350'),
(616, 59, 'IS 300'),
(615, 59, 'IS 250'),
(614, 59, 'IS 200'),
(613, 59, 'GX'),
(612, 59, 'GS 460'),
(611, 59, 'GS 450h'),
(610, 59, 'GS 430'),
(609, 59, 'GS 400'),
(608, 59, 'GS 350'),
(607, 59, 'GS 300'),
(606, 59, 'ES 350'),
(605, 59, 'ES 330'),
(604, 59, 'ES 300'),
(603, 58, 'SUV'),
(602, 58, 'Double Gate'),
(601, 57, 'Range Rover Sport'),
(600, 57, 'Range Rover'),
(599, 57, 'Land Rover'),
(598, 57, 'Freelander'),
(597, 57, 'Discovery'),
(596, 57, 'Defender'),
(595, 57, '90/110'),
(594, 56, 'Y'),
(593, 56, 'Thesis'),
(592, 56, 'Thema'),
(591, 56, 'Phedra'),
(590, 56, 'Lybra'),
(589, 56, 'Kappa'),
(588, 56, 'Delta'),
(587, 56, 'Dedra'),
(586, 56, 'Beta'),
(585, 55, 'Murcielago'),
(584, 55, 'Gallardo'),
(583, 55, 'Espada'),
(582, 55, 'Diablo'),
(581, 54, 'CC'),
(580, 53, 'Visto'),
(579, 53, 'Sportage'),
(578, 53, 'Spectra'),
(577, 53, 'Sorento'),
(576, 53, 'Shuma'),
(575, 53, 'Sephia'),
(574, 53, 'Sedona'),
(573, 53, 'Rio'),
(572, 53, 'Retona'),
(571, 53, 'Pride'),
(570, 53, 'Pregio'),
(569, 53, 'Potentia'),
(568, 53, 'Picanto'),
(567, 53, 'Optima'),
(566, 53, 'Opirus'),
(565, 53, 'Magentis'),
(564, 53, 'Joice'),
(563, 53, 'Clarus'),
(562, 53, 'Cerato'),
(561, 53, 'Cee\'d'),
(560, 53, 'Carnival'),
(559, 53, 'Carens'),
(558, 53, 'Capital'),
(557, 53, 'Borrego'),
(556, 53, 'Besta'),
(555, 53, 'Avella'),
(554, 52, 'Wrangler'),
(553, 52, 'Patriot'),
(552, 52, 'Liberty'),
(551, 52, 'Grand Cherokee'),
(550, 52, 'Compass'),
(549, 52, 'Commander'),
(548, 52, 'Cherokee'),
(547, 52, 'CJ5 - CJ8'),
(546, 51, 'XKR'),
(545, 51, 'XK 8'),
(544, 51, 'XJSc Convertible'),
(543, 51, 'XJS Coupe'),
(542, 51, 'XJR'),
(541, 51, 'XJ'),
(540, 51, 'XF'),
(539, 51, 'X-type'),
(538, 51, 'S-type'),
(537, 51, 'E-type'),
(536, 50, 'Rein'),
(535, 50, 'Refine'),
(534, 49, 'Wizard'),
(533, 49, 'VehiCross'),
(532, 49, 'Trooper'),
(531, 49, 'Rodeo'),
(530, 49, 'Impulse'),
(529, 49, 'Gemini'),
(528, 49, 'Bighorn'),
(527, 49, 'Axiom'),
(526, 49, 'Aska'),
(525, 49, 'Ascender'),
(524, 48, 'Samand'),
(523, 47, 'QX56'),
(522, 47, 'QX4'),
(521, 47, 'Q45'),
(520, 47, 'M45'),
(519, 47, 'M35'),
(518, 47, 'J30'),
(517, 47, 'I35'),
(516, 47, 'I30'),
(515, 47, 'G37'),
(514, 47, 'G35'),
(513, 47, 'FX 50'),
(512, 47, 'FX 45'),
(511, 47, 'FX 35'),
(510, 47, 'EX'),
(509, 46, 'XG'),
(508, 46, 'Verna'),
(507, 46, 'Veracruz'),
(506, 46, 'Tuscani'),
(505, 46, 'Tucson'),
(504, 46, 'Trajet'),
(503, 46, 'Tiburon'),
(502, 46, 'Terracan'),
(501, 46, 'Sonata'),
(500, 46, 'Santamo'),
(499, 46, 'Santa FE'),
(498, 46, 'S-Coupe'),
(497, 46, 'Pony'),
(496, 46, 'NF'),
(495, 46, 'Matrix'),
(494, 46, 'Marcia'),
(493, 46, 'Lavita'),
(492, 46, 'H100'),
(491, 46, 'H-1 Starex'),
(490, 46, 'Grandeur'),
(489, 46, 'Getz'),
(488, 46, 'Galloper'),
(487, 46, 'Elantra'),
(486, 46, 'Coupe'),
(485, 46, 'Atos'),
(484, 46, 'Accent'),
(483, 45, 'Hummer H3'),
(482, 45, 'Hummer H2'),
(481, 45, 'Hummer H1'),
(480, 45, 'Hummer'),
(479, 44, 'Antelope'),
(478, 43, 'Z'),
(477, 43, 'Vigor'),
(476, 43, 'Vamos'),
(475, 43, 'Torneo'),
(474, 43, 'Stream'),
(473, 43, 'Stepwgn'),
(472, 43, 'Sm-x'),
(471, 43, 'Shuttle'),
(470, 43, 'Saber'),
(469, 43, 'S2000'),
(468, 43, 'Ridgeline'),
(467, 43, 'Rafaga'),
(466, 43, 'Prelude'),
(465, 43, 'Pilot'),
(464, 43, 'Passport'),
(463, 43, 'Partner'),
(462, 43, 'Orthia'),
(461, 43, 'Odyssey'),
(460, 43, 'NSX'),
(459, 43, 'Mobilio'),
(458, 43, 'Logo'),
(457, 43, 'Life'),
(456, 43, 'Legend'),
(455, 43, 'Jazz'),
(454, 43, 'Integra'),
(453, 43, 'Inspire'),
(452, 43, 'Insight'),
(451, 43, 'Hr-v'),
(450, 43, 'Fit Aria'),
(449, 43, 'FR-V'),
(448, 43, 'FIT'),
(447, 43, 'Element'),
(446, 43, 'Edix'),
(445, 43, 'Domani'),
(444, 43, 'Concerto'),
(443, 43, 'Civic Shuttle'),
(442, 43, 'Civic'),
(441, 43, 'City'),
(440, 43, 'Capa'),
(439, 43, 'CRX'),
(438, 43, 'CR-V'),
(437, 43, 'Avancier'),
(436, 43, 'Airwave'),
(435, 43, 'Accord'),
(434, 42, 'Simbo'),
(433, 42, 'Princip'),
(432, 42, 'Brio'),
(431, 41, 'Wingle'),
(430, 41, 'Socool'),
(429, 41, 'Sailor'),
(428, 41, 'Safe'),
(427, 41, 'SUV'),
(426, 41, 'Hover'),
(425, 41, 'Deer'),
(424, 40, 'suburban'),
(423, 40, 'Yukon'),
(422, 40, 'Sonoma'),
(421, 40, 'Sierra'),
(420, 40, 'Savana'),
(419, 40, 'Safari'),
(418, 40, 'Jimmy'),
(417, 40, 'Envoy'),
(416, 40, 'Acadia'),
(415, 39, 'Tracker'),
(414, 39, 'Storm'),
(413, 39, 'Prizm'),
(412, 39, 'Metro'),
(411, 38, 'Otaka'),
(410, 38, 'MK'),
(409, 37, 'Windstar'),
(408, 37, 'Tourneo Connect'),
(407, 37, 'Thunderbird'),
(406, 37, 'Tempo'),
(405, 37, 'Taurus'),
(404, 37, 'Taunus'),
(403, 37, 'Sierra'),
(402, 37, 'Shelby'),
(401, 37, 'Scorpio'),
(400, 37, 'S-MAX'),
(399, 37, 'Ranger'),
(398, 37, 'Puma'),
(397, 37, 'Probe'),
(396, 37, 'Orion'),
(395, 37, 'Mustang'),
(394, 37, 'Mondeo'),
(393, 37, 'Maverick'),
(392, 37, 'Kuga'),
(391, 37, 'KA'),
(390, 37, 'Granada (USA)'),
(389, 37, 'Granada'),
(388, 37, 'Galaxy'),
(387, 37, 'GT'),
(386, 37, 'Fusion (USA)'),
(385, 37, 'Fusion'),
(384, 37, 'Freestyle'),
(383, 37, 'Focus ST'),
(382, 37, 'Focus'),
(381, 37, 'Five Hundred'),
(380, 37, 'Fiesta ST'),
(379, 37, 'Fiesta'),
(378, 37, 'F-150'),
(377, 37, 'Explorer'),
(376, 37, 'Expedition'),
(375, 37, 'Excursion'),
(374, 37, 'Escort'),
(373, 37, 'Escape'),
(372, 37, 'Edge'),
(371, 37, 'Econoline'),
(370, 37, 'Crown Victoria'),
(369, 37, 'Cougar'),
(368, 37, 'Contour'),
(367, 37, 'Capri'),
(366, 37, 'C-MAX'),
(365, 37, 'Bronco'),
(364, 37, 'Aerostar'),
(363, 36, 'X 1/9'),
(362, 36, 'Ulysse'),
(361, 36, 'UNO'),
(360, 36, 'Tipo'),
(359, 36, 'Tempra'),
(358, 36, 'Stilo'),
(357, 36, 'Seicento'),
(356, 36, 'Sedici'),
(355, 36, 'Ritmo'),
(354, 36, 'Regata'),
(353, 36, 'Punto'),
(352, 36, 'Panda'),
(351, 36, 'Palio'),
(350, 36, 'New 500'),
(349, 36, 'Multipla'),
(348, 36, 'Marea'),
(347, 36, 'Fiorino'),
(346, 36, 'Doblo'),
(345, 36, 'Croma'),
(344, 36, 'Coupe'),
(343, 36, 'Cinquecento'),
(342, 36, 'Bravo'),
(341, 36, 'Brava'),
(340, 36, 'Barchetta'),
(339, 36, 'Albea'),
(338, 36, '131'),
(337, 35, 'Testarossa'),
(336, 35, 'Mondial'),
(335, 35, 'Maranello'),
(334, 35, 'F355'),
(333, 35, 'Enzo'),
(332, 35, 'California'),
(331, 35, '612 Scaglietti'),
(330, 35, '599'),
(329, 35, '430'),
(328, 35, '360'),
(327, 34, 'Vita'),
(326, 34, 'Jinn'),
(325, 34, 'Admiral'),
(324, 33, 'Vision'),
(323, 33, 'Talon'),
(322, 32, 'D8'),
(321, 31, 'Orion'),
(320, 31, 'Kondor'),
(319, 31, 'Assol'),
(318, 30, 'MPV'),
(317, 29, 'Viper'),
(316, 29, 'Stratus'),
(315, 29, 'Stealth'),
(314, 29, 'Spirit'),
(313, 29, 'Shadow'),
(312, 29, 'Ramcharger'),
(311, 29, 'RAM'),
(310, 29, 'Nitro'),
(309, 29, 'Neon'),
(308, 29, 'Magnum'),
(307, 29, 'Intrepid'),
(306, 29, 'Grand Caravan'),
(305, 29, 'Durango'),
(304, 29, 'Dakota'),
(303, 29, 'Charger'),
(302, 29, 'Challenger'),
(301, 29, 'Caravan'),
(300, 29, 'Caliber'),
(299, 29, 'Avenger'),
(298, 28, 'Shuttle'),
(297, 28, 'Plutus'),
(296, 28, 'Cowboy'),
(295, 28, 'Aurora'),
(294, 27, 'Limousine'),
(293, 27, '2.8 - 5.3'),
(292, 26, 'YRV'),
(291, 26, 'Terios'),
(290, 26, 'Storia'),
(289, 26, 'Sirion'),
(288, 26, 'Rocky'),
(287, 26, 'Pyzar'),
(286, 26, 'Move'),
(285, 26, 'Mira'),
(284, 26, 'Materia'),
(283, 26, 'Feroza'),
(282, 26, 'Esse'),
(281, 26, 'Cuore'),
(280, 26, 'Copen'),
(279, 26, 'Charade'),
(278, 26, 'Boon'),
(277, 26, 'Be-go'),
(276, 26, 'Atrai/extol'),
(275, 26, 'Applause'),
(274, 26, 'Altis'),
(273, 25, 'Tico'),
(272, 25, 'Tacuma'),
(271, 25, 'Rezzo'),
(270, 25, 'Racer'),
(269, 25, 'Prince'),
(268, 25, 'Nubira'),
(267, 25, 'Nexia'),
(266, 25, 'Matiz'),
(265, 25, 'Magnus'),
(264, 25, 'Leganza'),
(263, 25, 'Lanos'),
(262, 25, 'Lacetti'),
(261, 25, 'LE Mans'),
(260, 25, 'Kalos'),
(259, 25, 'Evanda'),
(258, 25, 'Espero'),
(257, 25, 'Damas'),
(256, 24, 'Shuttle'),
(255, 24, 'City Leading'),
(254, 23, '1410'),
(253, 22, 'T-Rex'),
(252, 21, 'ZX'),
(251, 21, 'Xsara Picasso'),
(250, 21, 'Xsara'),
(249, 21, 'Xantia'),
(248, 21, 'XM'),
(247, 21, 'Visa'),
(246, 21, 'Saxo'),
(245, 21, 'LNA'),
(244, 21, 'Jumpy'),
(243, 21, 'Jumper'),
(242, 21, 'Evasion'),
(241, 21, 'C8'),
(240, 21, 'C6'),
(239, 21, 'C5'),
(238, 21, 'C4 Picasso'),
(237, 21, 'C4'),
(236, 21, 'C3'),
(235, 21, 'C25'),
(234, 21, 'C2'),
(233, 21, 'Berlingo'),
(232, 21, 'BX'),
(231, 21, 'AX'),
(230, 20, 'Voyager'),
(229, 20, 'Vision'),
(228, 20, 'Tracker'),
(227, 20, 'Town & Country'),
(226, 20, 'Stratus'),
(225, 20, 'Sebring'),
(224, 20, 'Saratoga'),
(223, 20, 'Prowler'),
(222, 20, 'Pacifica'),
(221, 20, 'PT Cruiser'),
(220, 20, 'Neon'),
(219, 20, 'NEW Yorker'),
(218, 20, 'LHS'),
(217, 20, 'LE Baron'),
(216, 20, 'Intrepid'),
(215, 20, 'Grand Voyager'),
(214, 20, 'Fifth Avenue'),
(213, 20, 'Crossfire'),
(212, 20, 'Concorde'),
(211, 20, 'Cirrus'),
(210, 20, 'Aspen'),
(209, 20, '300M'),
(208, 20, '300C'),
(207, 19, 'Viva'),
(206, 19, 'Venture'),
(205, 19, 'Van'),
(204, 19, 'Uplander'),
(203, 19, 'Trailblazer'),
(202, 19, 'Tracker'),
(201, 19, 'Tahoe'),
(200, 19, 'Suburban'),
(199, 19, 'Starcraft'),
(198, 19, 'Spark'),
(197, 19, 'Silverado'),
(196, 19, 'Savana'),
(195, 19, 'SSR'),
(194, 19, 'Rezzo'),
(193, 19, 'Prizm'),
(192, 19, 'Niva'),
(191, 19, 'Metro'),
(190, 19, 'Lumina'),
(189, 19, 'Lanos'),
(188, 19, 'Lacetti'),
(187, 19, 'Impala'),
(186, 19, 'HHR'),
(185, 19, 'Geo Storm'),
(184, 19, 'Express'),
(183, 19, 'Evanda'),
(182, 19, 'Equinox'),
(181, 19, 'Epica'),
(180, 19, 'Corvette'),
(179, 19, 'Corsica'),
(178, 19, 'Colorado'),
(177, 19, 'Cobalt'),
(176, 19, 'Cavalier'),
(175, 19, 'Captiva'),
(174, 19, 'Caprice'),
(173, 19, 'Camaro'),
(172, 19, 'C-10'),
(171, 19, 'Blazer'),
(170, 19, 'Beretta'),
(169, 19, 'Aveo'),
(168, 19, 'Avalanche'),
(167, 19, 'Astro'),
(166, 19, 'Alero'),
(165, 18, 'Tiggo'),
(164, 18, 'Sweet (QQ)'),
(163, 18, 'QQ6 (S21)'),
(162, 18, 'Oriental Son'),
(161, 18, 'Kimo (A1)'),
(160, 18, 'Fora'),
(159, 18, 'Flagcloud'),
(158, 18, 'Amulet'),
(157, 17, 'SUV'),
(156, 17, 'Flying'),
(155, 16, 'Super Seven'),
(154, 15, 'XLR'),
(153, 15, 'Seville'),
(152, 15, 'STS'),
(151, 15, 'SRX'),
(150, 15, 'Fleetwood'),
(149, 15, 'Escalade'),
(148, 15, 'Eldorado'),
(147, 15, 'DE Ville'),
(146, 15, 'Catera'),
(145, 15, 'CTS'),
(144, 15, 'BLS'),
(143, 14, 'FLYER II'),
(142, 14, 'F3'),
(141, 13, 'Skylark'),
(140, 13, 'Roadmaster'),
(139, 13, 'Riviera'),
(138, 13, 'Rendezvous'),
(137, 13, 'Reatta'),
(136, 13, 'Park Avenue'),
(135, 13, 'LE Sabre'),
(134, 13, 'Enclave'),
(133, 13, 'Century'),
(132, 12, 'EB 16.4'),
(131, 12, '57 SC Atlantic'),
(130, 11, 'M2'),
(129, 11, 'M1'),
(128, 10, 'Z8'),
(127, 10, 'Z4 M'),
(126, 10, 'Z4'),
(125, 10, 'Z3 M'),
(124, 10, 'Z3'),
(123, 10, 'Z1'),
(122, 10, 'X6'),
(121, 10, 'X5'),
(120, 10, 'X3'),
(119, 10, 'M6'),
(118, 10, 'M5'),
(117, 10, 'M3'),
(116, 10, '8er 850'),
(115, 10, '7er 760'),
(114, 10, '7er 750'),
(113, 10, '7er 745'),
(112, 10, '7er 740'),
(111, 10, '7er 735'),
(110, 10, '7er 732'),
(109, 10, '7er 730'),
(108, 10, '7er 728'),
(107, 10, '7er 725'),
(106, 10, '6er 650'),
(105, 10, '6er 645'),
(104, 10, '6er 635'),
(103, 10, '6er 630'),
(102, 10, '6er 628'),
(101, 10, '5er 550'),
(100, 10, '5er 545'),
(99, 10, '5er 540'),
(98, 10, '5er 535'),
(97, 10, '5er 530'),
(96, 10, '5er 528'),
(95, 10, '5er 525'),
(94, 10, '5er 524'),
(93, 10, '5er 523'),
(92, 10, '5er 520'),
(91, 10, '5er 518'),
(90, 10, '3er 335'),
(89, 10, '3er 330'),
(88, 10, '3er 328'),
(87, 10, '3er 325'),
(86, 10, '3er 324'),
(85, 10, '3er 323'),
(84, 10, '3er 320'),
(83, 10, '3er 318'),
(82, 10, '3er 316'),
(81, 10, '3er 315'),
(80, 10, '1er 130'),
(79, 10, '1er 120'),
(78, 10, '1er 118'),
(77, 10, '1er 116'),
(76, 10, '02 (E10)'),
(75, 9, 'Turbo R'),
(74, 9, 'Mulsanne'),
(73, 9, 'Continental'),
(72, 9, 'Brooklands'),
(71, 9, 'Azure'),
(70, 9, 'Arnage'),
(69, 8, 'Montego'),
(68, 8, 'Mini MK'),
(67, 8, 'Metro'),
(66, 7, 'V8 (D11)'),
(65, 7, 'TT'),
(64, 7, 'S8'),
(63, 7, 'S6'),
(62, 7, 'S5'),
(61, 7, 'S4'),
(60, 7, 'S3'),
(59, 7, 'S2'),
(58, 7, 'RS6'),
(57, 7, 'RS4'),
(56, 7, 'R8'),
(55, 7, 'Quattro'),
(54, 7, 'Q7'),
(53, 7, 'Coupe'),
(52, 7, 'Cabriolet'),
(51, 7, 'Allroad'),
(50, 7, 'A8'),
(49, 7, 'A6'),
(48, 7, 'A5'),
(47, 7, 'A4'),
(46, 7, 'A3'),
(45, 7, 'A2'),
(44, 7, '200'),
(43, 7, '100'),
(42, 7, '90'),
(41, 7, '80'),
(40, 6, 'V8'),
(39, 6, 'V12 Vanquish'),
(38, 6, 'DBS'),
(37, 6, 'DB9'),
(36, 6, 'DB7'),
(35, 5, 'Rocsta'),
(34, 4, '24'),
(33, 4, '10'),
(32, 3, 'Roadster S'),
(31, 3, 'B7'),
(30, 3, 'B6'),
(29, 3, 'B3'),
(28, 3, 'B12'),
(27, 3, 'B11'),
(26, 2, 'Spider'),
(25, 2, 'Giulietta'),
(24, 2, 'GTV'),
(23, 2, 'GT'),
(22, 2, 'Brera'),
(21, 2, 'Alfetta'),
(20, 2, '166'),
(19, 2, '164'),
(18, 2, '159'),
(17, 2, '156'),
(16, 2, '155'),
(15, 2, '147'),
(14, 2, '146'),
(13, 2, '145'),
(12, 2, '75'),
(11, 2, '33'),
(10, 1, 'TSX'),
(9, 1, 'TL'),
(8, 1, 'RSX'),
(7, 1, 'RL'),
(6, 1, 'RDX'),
(5, 1, 'NSX'),
(4, 1, 'MDX'),
(3, 1, 'Integra'),
(2, 1, 'EL'),
(1, 1, 'CL');

1884

MySQL: Removing of duplicates

20.06.2013 16:28 RedOctober MySQL 0 Comments

Removing of duplicates in a table ... Reveal Code

DELETE t1 FROM `my_table` t1, `my_table` t2 
WHERE t1.`my_field` = t2.`my_field` AND t1.`id` > t2.`id`

1365

MySQL: World countries database

20.06.2013 11:02 RedOctober MySQL 0 Comments

World countries and their ISO 3166-1 codes ... Reveal Code

DROP TABLE IF EXISTS `list_countries`;
CREATE TABLE `list_countries` (
  `id` int(11) NOT NULL auto_increment,
  `country_short_name` varchar(2) NOT NULL,
  `country_name` varchar(24) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Afghanistan', 'AF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Aland Islands', 'AX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Albania', 'AL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Algeria', 'DZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('American Samoa', 'AS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Andorra', 'AD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Angola', 'AO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Anguilla', 'AI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Antarctica', 'AQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Antigua and Barbuda', 'AG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Argentina', 'AR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Armenia', 'AM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Aruba', 'AW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Australia', 'AU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Austria', 'AT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Azerbaijan', 'AZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bahamas', 'BS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bahrain', 'BH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bangladesh', 'BD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Barbados', 'BB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Belarus', 'BY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Belgium', 'BE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Belize', 'BZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Benin', 'BJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bermuda', 'BM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bhutan', 'BT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bolivia', 'BO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bonaire Sint Eustatius and Saba', 'BQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bosnia and Herzegovina', 'BA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Botswana', 'BW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bouvet Island', 'BV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Brazil', 'BR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('British Indian Ocean Territory', 'IO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Brunei Darussalam', 'BN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bulgaria', 'BG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Burkina Faso', 'BF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Burundi', 'BI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cambodia', 'KH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cameroon', 'CM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Canada', 'CA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cape Verde', 'CV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cayman Islands', 'KY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Central African Republic', 'CF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Chad', 'TD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Chile', 'CL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('China', 'CN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Christmas Island', 'CX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cocos Islands', 'CC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Colombia', 'CO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Comoros', 'KM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Congo', 'CG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Congo', 'CD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cook Islands', 'CK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Costa Rica', 'CR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cote d\'Ivoire', 'CI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Croatia', 'HR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cuba', 'CU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Curacao', 'CW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cyprus', 'CY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Czech Republic', 'CZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Denmark', 'DK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Djibouti', 'DJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Dominica', 'DM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Dominican Republic', 'DO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ecuador', 'EC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Egypt', 'EG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('El Salvador', 'SV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Equatorial Guinea', 'GQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Eritrea', 'ER');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Estonia', 'EE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ethiopia', 'ET');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Falkland Islands', 'FK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Faroe Islands', 'FO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Fiji', 'FJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Finland', 'FI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('France', 'FR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('French Guiana', 'GF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('French Polynesia', 'PF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('French Southern Territories', 'TF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Gabon', 'GA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Gambia', 'GM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Georgia', 'GE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Germany', 'DE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ghana', 'GH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Gibraltar', 'GI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Greece', 'GR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Greenland', 'GL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Grenada', 'GD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guadeloupe', 'GP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guam', 'GU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guatemala', 'GT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guernsey', 'GG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guinea', 'GN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guinea-Bissau', 'GW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guyana', 'GY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Haiti', 'HT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Heard Island and McDonald Islands', 'HM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Vatican City', 'VA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Honduras', 'HN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Hong Kong', 'HK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Hungary', 'HU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Iceland', 'IS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('India', 'IN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Indonesia', 'ID');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Iran', 'IR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Iraq', 'IQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ireland', 'IE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Isle of Man', 'IM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Israel', 'IL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Italy', 'IT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Jamaica', 'JM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Japan', 'JP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Jersey', 'JE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Jordan', 'JO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kazakhstan', 'KZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kenya', 'KE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kiribati', 'KI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Korea', 'KP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Korea', 'KR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kuwait', 'KW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kyrgyzstan', 'KG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lao', 'LA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Latvia', 'LV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lebanon', 'LB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lesotho', 'LS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Liberia', 'LR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Libya', 'LY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Liechtenstein', 'LI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lithuania', 'LT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Luxembourg', 'LU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Macao', 'MO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Macedonia', 'MK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Madagascar', 'MG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Malawi', 'MW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Malaysia', 'MY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Maldives', 'MV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mali', 'ML');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Malta', 'MT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Marshall Islands', 'MH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Martinique', 'MQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mauritania', 'MR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mauritius', 'MU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mayotte', 'YT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mexico', 'MX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Micronesia', 'FM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Moldova', 'MD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Monaco', 'MC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mongolia', 'MN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Montenegro', 'ME');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Montserrat', 'MS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Morocco', 'MA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mozambique', 'MZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Myanmar', 'MM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Namibia', 'NA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nauru', 'NR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nepal', 'NP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Netherlands', 'NL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('New Caledonia', 'NC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('New Zealand', 'NZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nicaragua', 'NI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Niger', 'NE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nigeria', 'NG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Niue', 'NU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Norfolk Island', 'NF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Northern Mariana Islands', 'MP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Norway', 'NO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Oman', 'OM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Pakistan', 'PK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Palau', 'PW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Palestine', 'PS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Panama', 'PA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Papua New Guinea', 'PG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Paraguay', 'PY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Peru', 'PE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Philippines', 'PH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Pitcairn', 'PN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Poland', 'PL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Portugal', 'PT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Puerto Rico', 'PR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Qatar', 'QA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Reunion', 'RE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Romania', 'RO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Russian Federation', 'RU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Rwanda', 'RW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Barthelemy', 'BL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Helena Ascension and Tristan da Cunha', 'SH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Kitts and Nevis', 'KN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Lucia', 'LC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Martin (French part)', 'MF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Pierre and Miquelon', 'PM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Vincent and the Grenadines', 'VC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Samoa', 'WS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('San Marino', 'SM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sao Tome and Principe', 'ST');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saudi Arabia', 'SA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Senegal', 'SN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Serbia', 'RS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Seychelles', 'SC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sierra Leone', 'SL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Singapore', 'SG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sint Maarten (Dutch part)', 'SX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Slovakia', 'SK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Slovenia', 'SI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Solomon Islands', 'SB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Somalia', 'SO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Africa', 'ZA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Georgia and the South Sandwich Islands', 'GS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Sudan', 'SS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Spain', 'ES');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sri Lanka', 'LK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sudan', 'SD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Suriname', 'SR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Svalbard and Jan Mayen', 'SJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Swaziland', 'SZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sweden', 'SE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Switzerland', 'CH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Syrian Arab Republic', 'SY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Taiwan Province of China', 'TW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tajikistan', 'TJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tanzania', 'TZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Thailand', 'TH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Timor-Leste', 'TL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Togo', 'TG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tokelau', 'TK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tonga', 'TO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Trinidad and Tobago', 'TT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tunisia', 'TN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Turkey', 'TR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Turkmenistan', 'TM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Turks and Caicos Islands', 'TC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tuvalu', 'TV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Uganda', 'UG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ukraine', 'UA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United Arab Emirates', 'AE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United Kingdom', 'GB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United States', 'US');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United States Minor Outlying Islands', 'UM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Uruguay', 'UY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Uzbekistan', 'UZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Vanuatu', 'VU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Venezuela', 'VE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Viet Nam', 'VN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Virgin Islands British', 'VG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Virgin Islands U.S.', 'VI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Wallis and Futuna', 'WF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Western Sahara', 'EH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Yemen', 'YE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Zambia', 'ZM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Zimbabwe', 'ZW');

1287

PHP: Format a date received from MySQL

06.05.2013 14:58 RedOctober PHP 0 Comments

Format a date/time received from MySQL in a more readable (user-friendly) form. ... Reveal Code

//$row[create_datetime] == '2013-05-06 03:14:43';
//$formatted_datetime == '06.05.2013 03:14';

define('SHORTDATETIME', 'd.m.Y H:i');
$formatted_datetime = date_format(date_create($row[create_datetime]), SHORTDATETIME);

396

PHP: Get a single value from DB

06.05.2013 02:40 RedOctober PHP 0 Comments

Get a single value from DB as a variable. ... Reveal Code

$my_variable = mysql_result(mysql_query("SELECT COUNT(id) FROM my_table"), 0);

346

MySQL: The number of records for yesterday

05.05.2013 16:19 RedOctober MySQL 0 Comments

The number of records in the table for yesterday ... Reveal Code

SELECT COUNT(id) FROM my_table WHERE created_datetime >= (DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 DAY), '%Y-%m-%d')) AND created_datetime < (DATE_FORMAT(NOW(), '%Y-%m-%d'))

356

MySQL: The number of records for the current month

05.05.2013 15:09 RedOctober MySQL 0 Comments

The number of records in a table for the current month (from 1st to current day) ... Reveal Code

SELECT COUNT(id) FROM my_table WHERE date_format(created_datetime, '%Y%m') = date_format(now(), '%Y%m')

395

RedOctober	69
mdbm	11
NeonLost	10
stalin	9
grun	7
v.danylo	5
Shara	4
228vit	4
nikita	3
KARPOLAN	3

Have a Snippet?

Tag "MySQL" (11)