Browsing the Slovenian vehicle database

Slovenian “National Interoperability Framework” (NIO) published a database with data on every registered vehicle in Slovenia, so I decided to do some fun queries. (Query results are in Slovene, but i will try to translate the most interesting ones)

How many registered vehicles are in Slovenia?

+----------+
| count(*) |
+----------+
|  1516719 |
+----------+

What about different vehicle types?

+-------------------------------------+----------+
| J-Kategorija in vrsta vozila (opis) | count(*) |
+-------------------------------------+----------+
| osebni avtomobil                    |  1148673 | #(personal) cars
| traktor                             |   109677 | #tractors
| tovorno vozilo                      |    86719 | #trucks
| motorno kolo                        |    54778 | #motorcycles
| priklopno vozilo                    |    37240 | #trailers
| kolo z motorjem                     |    32215 | #motorized bicycles
| vlečno vozilo                       |    12266 |
| moped-dvokolo                       |    10833 |
| traktorski priklopnik               |     7252 |
| delovno vozilo                      |     6394 |
| štirikolo                           |     5391 |
| avtobus                             |     2687 |
| trikolo                             |     1471 |
| lahko štirikolo                     |      828 |
| Neznana vrednost                    |      235 |
| moped-trikolo                       |       19 |
| motorno kolo z visoko močjo         |       19 |
| kolo na motorni pogon               |        7 |
| dvokolesni moped                    |        6 |
| motorno kolo z nizko močjo          |        4 |
| motorno kolo s srednjo močjo        |        2 |
| gosenični traktor                   |        2 |
| NULL                                |        1 |
+-------------------------------------+----------+

Common manufacturers (cars only):

+-----------------------------+----------+
| D1-Znamka                   | count(*) |
+-----------------------------+----------+
| RENAULT                     |   195620 |
| VOLKSWAGEN                  |   167546 |
| OPEL                        |    90443 |
| CITROEN                     |    80923 |
| PEUGEOT                     |    72295 |
| FORD                        |    60756 |
| FIAT                        |    47954 |
| AUDI                        |    46237 |
| ŠKODA                       |    43864 |
| BMW                         |    37414 |
| HYUNDAI                     |    36942 |
| TOYOTA                      |    33153 |
| SEAT                        |    27598 |
| KIA                         |    26660 |
| MERCEDES BENZ               |    22120 |
| NISSAN                      |    20200 |
| MAZDA                       |    17181 |
| HONDA                       |    16269 |
| CHEVROLET                   |    14401 |
| SUZUKI                      |    13145 |
| VOLVO                       |    11045 |
| MERCEDES-BENZ               |     8233 |
| ALFA ROMEO                  |     8202 |
| DACIA                       |     7578 |
| MITSUBISHI                  |     7189 |
| DAEWOO                      |     7088 |
| SUBARU                      |     3546 |
| LAND ROVER                  |     2256 |
| LANCIA                      |     2248 |
| MINI                        |     1986 |
| ZASTAVA                     |     1770 |
| JEEP                        |     1498 |
| ROVER                       |     1438 |
| CHRYSLER                    |     1277 |
| SAAB                        |     1070 |
| SMART                       |     1051 |
| PORSCHE                     |      980 |
| UNIS                        |      963 |
| DAIHATSU                    |      789 |
| LADA                        |      611 |
| JAGUAR                      |      608 |
| LEXUS                       |      570 |
| SSANGYONG                   |      567 |
| VOLKSWAGEN, VW              |      461 |
| PROTON                      |      408 |
| FIAT-ADRIA                  |      400 |
| IMV                         |      380 |
| MCC                         |      349 |
| ADRIA                       |      292 |
| DODGE                       |      251 |
| CIMOS                       |      202 |
| MARUTI                      |      183 |
| AUSTIN                      |      113 |
| MG                          |      100 |
| IVECO                       |       96 |
| HYMER                       |       77 |
| IDA                         |       68 |
| CADILLAC                    |       65 |
| STEYR DAIMLER PUCH          |       60 |
| PUCH                        |       53 |
| TRIUMPH                     |       53 |
| SUN LIVING                  |       52 |
| WILLYS                      |       51 |
| MASERATI                    |       50 |
| BMW I                       |       49 |
| HUMMER                      |       47 |
| MAHINDRA                    |       46 |
| PONTIAC                     |       43 |
| FERRARI                     |       42 |
| TRABANT                     |       40 |
| TESLA                       |       37 |
| FORD-CHALLENGER             |       36 |
| AUTOCARAVANS RIMOR          |       36 |
| UAZ                         |       35 |
| CAPRON                      |       34 |
| NSU                         |       33 |
| TAM                         |       32 |
| RENAULT-ADRIA               |       31 |
| FSM                         |       29 |
| QUATTRO                     |       29 |
| CARTHAGO                    |       28 |
| ELNAGH                      |       27 |
| WARTBURG                    |       27 |
| INFINITI                    |       27 |
| BENIMAR                     |       27 |
| DETHLEFFS                   |       24 |
| TRIGANO                     |       23 |
| CHALLENGER                  |       22 |
| SIMCA                       |       21 |
| LINCOLN                     |       21 |
| KNAUS                       |       19 |
| DS                          |       19 |
| STEYR-PUCH                  |       19 |
| AUTOBIANCHI                 |       17 |
| GM DAEWOO                   |       17 |
| BUICK                       |       16 |
| SEA                         |       16 |
| PIAGGIO                     |       15 |
| ASTON MARTIN                |       15 |
| FIAT-JOINT                  |       14 |
| DANGEL                      |       14 |
| LOTUS                       |       13 |
| TATA                        |       13 |
| LAIKA                       |       12 |
| ISUZU                       |       12 |
| MORRIS                      |       12 |
| BENTLEY                     |       12 |
| STEYR-DAIMLER               |       12 |
| VAUXHALL                    |       11 |
| DAIMLER-ADRIA               |       11 |
| SHUANGHUAN                  |       11 |
| GMC                         |       11 |
| ROLLS ROYCE                 |       11 |
| HYNDAI                      |       10 |
| FIAT-ADRIA MOBIL            |       10 |
| DKW                         |       10 |
| INNOCENTI                   |        9 |
| OLDSMOBILE                  |        9 |
| VAZ                         |        9 |
| TALBOT                      |        9 |
| MOBILVETTA                  |        9 |
| EURA MOBIL                  |        8 |
| DAIMLER BENZ                |        8 |
| DAIMLERCHRYSLER             |        8 |
| WEINSBERG                   |        8 |
| ROLLER TEAM                 |        8 |
| RAPIDO                      |        8 |
| GM DAEWOO AUTO&TECHN        |        7 |
| GIOTTILINE                  |        7 |
| MORGAN                      |        7 |
| BUERSTNER GMBH              |        7 |
| CARAVANS INTERNATIONAL      |        6 |
| BUERSTNER                   |        6 |
| STEYR-DAIMLER-PUCH          |        6 |
| MCLOUIS                     |        6 |
| FORD-CHAUSSON               |        6 |
| HOBBY                       |        5 |
| PLYMOUTH                    |        5 |
| DAF                         |        5 |
| WESTFALIA                   |        5 |
| FIAT-CARTHAGO               |        5 |
| SUN ROLLER                  |        5 |
| BURSTNER                    |        5 |
| FIAT-TRIGANO                |        5 |
| AUTO UNION-DKW              |        5 |
| LUAZ                        |        5 |
| BEDFORD                     |        5 |
| PLA                         |        5 |
| SUNBEAM                     |        5 |
| CARAVAN INTERNATIONAL       |        5 |
| ARO                         |        4 |
| PANTHER                     |        4 |
| TATRA                       |        4 |
| ROLLS-ROYCE                 |        4 |
| DAIMLER                     |        4 |
| BERTONE                     |        4 |
| LAMBORGHINI                 |        4 |
| RIMOR                       |        4 |
| MC LOUIS                    |        4 |
| ELNAGH MARLIN               |        4 |
| BRAVIA                      |        4 |
| T.E.C.                      |        4 |
| JOINT                       |        3 |
| FIAT-CHAUSSON               |        3 |
| ASIA                        |        3 |
| ABARTH                      |        3 |
| ARCA                        |        3 |
| AUSTIN HEALEY               |        3 |
| BMW ALPINA                  |        3 |
| ALFA- ROMEO                 |        3 |
| RELIANT                     |        2 |
| BORGWARD                    |        2 |
| SCION                       |        2 |
| ADRIA CARAVAN               |        2 |
| FIAT-LAIKA                  |        2 |
| AERO                        |        2 |
| FIAT ARCA                   |        2 |
| GREAT WALL                  |        2 |
| TOMOS-CITROEN               |        2 |
| HYMERMOBIL                  |        2 |
| AUTO-UNION                  |        2 |
| ZAZ                         |        2 |
| CONCORDE                    |        2 |
| MERCURY                     |        2 |
| BINZ                        |        2 |
| JBA                         |        2 |
| MATRA SIMCA                 |        2 |
| KTM                         |        2 |
| CHRYSLER-SIMCA              |        2 |
| FSO                         |        2 |
| A.C. CARS                   |        1 |
| ALFA-ROMEO                  |        1 |
| CHAUSSON                    |        1 |
| PHOENIX                     |        1 |
| DONNET ZEDEL                |        1 |
| FIAT-AUTOCARAVANS RIMOR     |        1 |
| STEYER-PUCH                 |        1 |
| CALVY MITCHEL               |        1 |
| LMC                         |        1 |
| GREAT WALL MOTOR            |        1 |
| HUPMOBILE                   |        1 |
| PORCSHE                     |        1 |
| AC COBRA LTD                |        1 |
| BSA                         |        1 |
| CATERHAM                    |        1 |
| TOMOS CITROEN               |        1 |
| LDV                         |        1 |
| FORD-GB                     |        1 |
| LAFER                       |        1 |
| ITASCA                      |        1 |
| KUTSENITS                   |        1 |
| SHELBY                      |        1 |
| IVECO-LAIKA                 |        1 |
| ACURA                       |        1 |
| VOLKSWAGWN                  |        1 |
| GLAS-ISARIA                 |        1 |
| IRENAULT                    |        1 |
| STEYR-FIAT                  |        1 |
| API                         |        1 |
| VOLKSVAGEN                  |        1 |
| DAIMLER-LA STRADA           |        1 |
| JEPP                        |        1 |
| K1                          |        1 |
| AMC                         |        1 |
| V0LKSWAGEN                  |        1 |
| BOMBARDIER                  |        1 |
| LASTNA IZDELAVA             |        1 |
| FERGUSON                    |        1 |
| AHORN                       |        1 |
| GAZELLE                     |        1 |
| ROSENGART                   |        1 |
| OVERLAND                    |        1 |
| FORD-D                      |        1 |
| MOSKVICH                    |        1 |
| WILLIS                      |        1 |
| CIMOS CITROEN               |        1 |
| ROVER RH(600)               |        1 |
| VOLKWAGEN                   |        1 |
| VOLSKWAGEN                  |        1 |
| BUGATTI                     |        1 |
| LEA-FRANCIS                 |        1 |
| STANDARD                    |        1 |
| MAN                         |        1 |
| MERCEDES  BENZ              |        1 |
| ARSENAL                     |        1 |
| M-R                         |        1 |
| FORD GPW                    |        1 |
| MERCEDES                    |        1 |
| ADLER                       |        1 |
| AUSTIN MORIS                |        1 |
| LTI                         |        1 |
| NSU-FIAT                    |        1 |
| ITINEO                      |        1 |
| TRIGANO CHAUSSON            |        1 |
| MITSUBISHI-NL               |        1 |
| PHILLIPS                    |        1 |
| FORD-USA                    |        1 |
| FRANKIA                     |        1 |
| ASTRA                       |        1 |
| GAZ                         |        1 |
| ESSEX                       |        1 |
| AUTOMIRAGE                  |        1 |
| POESSL                      |        1 |
| VOLGA                       |        1 |
| REUTER                      |        1 |
| MAYBACH                     |        1 |
| DAIMLERCHRYSLER-ADRIA MOBIL |        1 |
| BLUCAMP                     |        1 |
| FORD-BURSTNER               |        1 |
| TOMOS                       |        1 |
| AMILCAR                     |        1 |
| ZAPOROŽEC-ZAZ               |        1 |
| FIAT-MOOVEO                 |        1 |
| STEMMER                     |        1 |
| PILGRIM                     |        1 |
| FENDT                       |        1 |
| GERMAN E CARS               |        1 |
| IFA                         |        1 |
| VW                          |        1 |
| WOLSELEY                    |        1 |
| OLTCIT                      |        1 |
| IKOR-B                      |        1 |
| AUTOZODIACO                 |        1 |
| FOELLNER                    |        1 |
+-----------------------------+----------+

Since data entry is done at registration points by hand, you see “MERCEDES BENZ” and “MERCEDES-BENZ”  etc. as different manufacturers.

How many Lamborghinis (all vehicle types, all spellings)?

+----------------+----------+
| D1-Znamka      | count(*) |
+----------------+----------+
| LAMBORDINI     |        1 |
| LAMBORDŽINI    |        1 |
| LAMBORGHINI    |     2417 |
| LAMBORGINI     |        5 |
| S. LAMBORGHINI |        1 |
+----------------+----------+

Nice! Must be alot of rich people here.. but lets check the vehicle type first:

+-------------------------------------+----------+
| J-Kategorija in vrsta vozila (opis) | count(*) |
+-------------------------------------+----------+
| traktor                             |     2419 | #tractors
| osebni avtomobil                    |        4 | #cars
| Neznana vrednost                    |        2 | #unknown
+-------------------------------------+----------+

Okay, maybe not. Lets check the not-tractors:

+-------------+-----------------+------------------------+
| D1-Znamka   | D2-Tovar oznaka | D3-Komerc oznaka       |
+-------------+-----------------+------------------------+
| LAMBORGHINI | 140-R-45-A-P    | GALLARDO               |
| LAMBORGHINI | 140-R-45-A-P    | GALLARDO               |
| LAMBORGHINI | NULL            | R 235                  | #unknown type, actually a tractor
| LAMBORGHINI | L147            | LAMBORGHINI MURCIELAGO |
| LAMBORGHINI | NULL            | LDA 90                 | #unknown type, actually a bulldozer-like vehicle
| LAMBORGHINI | 147F-704S       | MURCIELAGO /           |
+-------------+-----------------+------------------------+

Nice, 4 actual Lamborhini cars.

What about some demographic data – how old are the owners (Starost == age)?

+----------------------------+----------+
| C2-Starost lastnika vozila | count(*) |
+----------------------------+----------+
| NULL                       |   319475 | #company owned cars
| 1                          |        1 |
| 2                          |        3 |
| 3                          |        1 |
| 4                          |        2 |
| 5                          |        6 |
| 6                          |        9 |
| 7                          |        9 |
| 8                          |        3 |
| 9                          |        2 |
| 10                         |        7 |
| 11                         |        9 |
| 12                         |       14 |
| 13                         |       17 |
| 14                         |       24 |
| 15                         |       70 |
| 16                         |      173 |
| 17                         |      434 |
| 18                         |      965 |
| 19                         |     2360 |
| 20                         |     3890 |
| 21                         |     5298 |
| 22                         |     6746 |
| 23                         |     8147 |
| 24                         |     9243 |
| 25                         |    11035 |
| 26                         |    12429 |
| 27                         |    14028 |
| 28                         |    16177 |
| 29                         |    17011 |
| 30                         |    17357 |
| 31                         |    18643 |
| 32                         |    19350 |
| 33                         |    20415 |
| 34                         |    21860 |
| 35                         |    22956 |
| 36                         |    23990 |
| 37                         |    24682 |
| 38                         |    25084 |
| 39                         |    25136 |
| 40                         |    26056 |
| 41                         |    25898 |
| 42                         |    25784 |
| 43                         |    26283 |
| 44                         |    26737 |
| 45                         |    26501 |
| 46                         |    25600 |
| 47                         |    26802 |
| 48                         |    27546 |
| 49                         |    28138 |
| 50                         |    29551 |
| 51                         |    29234 |
| 52                         |    28672 |
| 53                         |    28220 |
| 54                         |    27573 |
| 55                         |    27435 |
| 56                         |    26243 |
| 57                         |    25566 |
| 58                         |    25066 |
| 59                         |    25115 |
| 60                         |    24906 |
| 61                         |    24058 |
| 62                         |    22796 |
| 63                         |    22614 |
| 64                         |    21458 |
| 65                         |    19926 |
| 66                         |    19542 |
| 67                         |    17366 |
| 68                         |    16118 |
| 69                         |    14913 |
| 70                         |    13200 |
| 71                         |     9067 |
| 72                         |    10557 |
| 73                         |    11165 |
| 74                         |    10985 |
| 75                         |     9805 |
| 76                         |     9143 |
| 77                         |     8248 |
| 78                         |     7308 |
| 79                         |     6522 |
| 80                         |     5949 |
| 81                         |     5125 |
| 82                         |     4345 |
| 83                         |     3621 |
| 84                         |     3138 |
| 85                         |     2508 |
| 86                         |     2121 |
| 87                         |     1461 |
| 88                         |     1162 |
| 89                         |      811 |
| 90                         |      574 |
| 91                         |      441 |
| 92                         |      230 |
| 93                         |      173 |
| 94                         |      120 |
| 95                         |       73 |
| 96                         |       39 |
| 97                         |       27 |
| 98                         |        6 |
| 99                         |        4 |
| 100                        |        1 |
| 101                        |        2 |
| 102                        |        4 |
| 103                        |        1 |
| 105                        |        1 |
| 108                        |        3 |
| 109                        |        1 |
+----------------------------+----------+

In Slovenia it is legal for a minor to own or inherit a vehicle, but to register it, an adult “user” with the appropriate licence must be assigned.

Which car does to youngest car owner have? (not sure if it’s inherited or a data entry error – age:=1)

+------------+--------------------+----------------------------+
| D1-Znamka  | D3-Komerc oznaka   | C2-Starost lastnika vozila |
+------------+--------------------+----------------------------+
| VOLKSWAGEN | TOURAN / 2.0 / TDI | 1                          |
+------------+--------------------+----------------------------+

How many cars are registered per administrative unit (geographical)?

+----------+--------------------------------------------+
| count(*) | C13-Upravna enota uporabnika vozila (opis) |
+----------+--------------------------------------------+
|   203373 | LJUBLJANA                                  |
|    74347 | MARIBOR                                    |
|    45983 | KRANJ                                      |
|    37767 | CELJE                                      |
|    37697 | PTUJ                                       |
|    36522 | NOVA GORICA                                |
|    36510 | NOVO MESTO                                 |
|    34164 | DOMŽALE                                    |
|    33235 | KOPER                                      |
|    29689 | MURSKA SOBOTA                              |
|    23703 | ŽALEC                                      |
|    22915 | ŠKOFJA LOKA                                |
|    22661 | VELENJE                                    |
|    22344 | GROSUPLJE                                  |
|    19867 | SLOVENSKA BISTRICA                         |
|    19278 | RADOVLJICA                                 |
|    19103 | KAMNIK                                     |
|    17929 | ŠMARJE PRI JELŠAH                          |
|    16023 | KRŠKO                                      |
|    15804 | SEŽANA                                     |
|    15752 | JESENICE                                   |
|    14860 | AJDOVŠČINA                                 |
|    13762 | VRHNIKA                                    |
|    13339 | BREŽICE                                    |
|    13236 | POSTOJNA                                   |
|    13144 | RAVNE NA KOROŠKEM                          |
|    12830 | SLOVENSKE KONJICE                          |
|    11957 | TREBNJE                                    |
|    11811 | LENDAVA                                    |
|    11739 | SLOVENJ GRADEC                             |
|    11409 | GORNJA RADGONA                             |
|    11220 | LITIJA                                     |
|    11185 | ŠENTJUR PRI CELJU                          |
|    10816 | LENART                                     |
|    10691 | PESNICA                                    |
|    10550 | TOLMIN                                     |
|    10140 | SEVNICA                                    |
|     9860 | ČRNOMELJ                                   |
|     9687 | PIRAN                                      |
|     9571 | LAŠKO                                      |
|     9395 | CERKNICA                                   |
|     9316 | LJUTOMER                                   |
|     9163 | IDRIJA                                     |
|     8950 | MOZIRJE                                    |
|     8845 | IZOLA                                      |
|     8838 | ORMOŽ                                      |
|     8783 | ZAGORJE OB SAVI                            |
|     8605 | RADLJE OB DRAVI                            |
|     8347 | KOČEVJE                                    |
|     8318 | ILIRSKA BISTRICA                           |
|     8170 | TRBOVLJE                                   |
|     8127 | TRŽIČ                                      |
|     7908 | RUŠE                                       |
|     7407 | LOGATEC                                    |
|     7364 | RIBNICA                                    |
|     4936 | DRAVOGRAD                                  |
|     4534 | HRASTNIK                                   |
|     4493 | METLIKA                                    |
|      701 | Sistem                                     |
+----------+--------------------------------------------+

 

What about fuel type (gasoline vs diesel vs others)?

+----------+-----------------------------+
| count(*) | P13-Vrsta goriva (opis)     |
+----------+-----------------------------+
|   621159 | Bencin                      | #gasoline
|   517443 | Dizel                       | #diesel
|     8692 | Bencin/Utek. naft. plin     | #gasoline + LPG
|      662 | Utekočinjeni naftni plin    | #LPG
|      353 | Ni goriva                   | #no gas? maybe electric
|       97 | Dizel/Biodizel in komb.     |
|       94 | Komprimiran zemeljski plin  |
|       68 | Bencin/Komp. zem. plin      |
|       57 | Mešanica                    |
|       16 | Bencin/Etanol               |
|       14 | Dizel/Utek. naft. plin.     |
|       10 | Vodik                       | #hydrogen
|        5 | Utekočinjeni naftni plin*   |
|        3 | Diesel, nafta, plinsko olje |
+----------+-----------------------------+

Most common engine size/displacement (ccm):

+-------------------------+----------+
| P11-Delovna prostornina | count(*) |
+-------------------------+----------+
| 1598                    |   113932 | 
| 1896                    |    85995 |
| 1149                    |    71910 |
| 1968                    |    60370 |
| 1390                    |    49126 |
| 1560                    |    48783 |
| 1461                    |    47872 |
| 1997                    |    39966 |
| 1995                    |    38076 |
| 49                      |    34013 | #most common for mopeds
| -1                      |    31052 |
| 1360                    |    29413 |
| 1242                    |    22095 |
| 1870                    |    19239 |
| 1587                    |    19183 |
| 1998                    |    18516 |
| 1197                    |    18451 |
| 1910                    |    16872 |
| 1396                    |    14560 |
| 0                       |    14301 |
| 1364                    |    13973 |
| 1596                    |    13717 |
| 998                     |    12881 |
| 2500                    |    12685 |
| 1398                    |    12437 |
| 999                     |    11584 |
| 1595                    |    11523 |
| 1199                    |    10962 |
| 1686                    |    10720 |
| 1248                    |    10545 |
| 1198                    |     9736 |
| 1399                    |     9205 |
| 2198                    |     8630 |
| 1124                    |     8099 |
| 1368                    |     8067 |
| 1299                    |     7689 |
| 1397                    |     7653 |
| 1229                    |     7485 |
| 2148                    |     7377 |
| 2360                    |     7296 |
| 1796                    |     7276 |
| 1388                    |     6722 |
| 1781                    |     6601 |
| 1108                    |     6599 |
| 1991                    |     6406 |
| 1498                    |     6333 |
| 1298                    |     6236 |
| 2993                    |     6025 |
| 1591                    |     5859 |
| 1582                    |     5673 |
+-------------------------+----------+

 

And colors?

+---------------------------------+----------+
| R-Barva vozila (opis)           | count(*) |
+---------------------------------+----------+
| kovinski - SIVA - SVETLA        |   299205 | #metallic gray light
| navaden - BELA - SREDNJA        |   135132 | #white
| navaden - RDEČA - SREDNJA       |   104414 | #red
| kovinski - SIVA - TEMNA         |    97520 | #metallic gray dark
| kovinski - SIVA - SREDNJA       |    85646 | #metallic gray medium
| kovinski - ČRNA - SREDNJA       |    66214 | #metallic black medium
| navaden - BELA - TEMNA          |    64781 | #white dark (???)
| kovinski - ČRNA - TEMNA         |    61789 | #metallic black dark(?)
| kovinski - MODRA - TEMNA        |    60884 | #metallic blue dark
| kovinski - RDEČA - TEMNA        |    45224 | #metallic red dark
| kovinski - MODRA - SVETLA       |    41295 | 
| navaden - RDEČA - TEMNA         |    37676 |
| navaden - BELA - SVETLA         |    37414 |
| kovinski - MODRA - SREDNJA      |    31500 |
| kovinski - RJAVA - SVETLA       |    30638 |
| navaden - ČRNA - SREDNJA        |    27241 |
| kovinski - ZELENA - TEMNA       |    24184 |
| navaden - ZELENA - SREDNJA      |    20368 |
| kovinski - ZELENA - SVETLA      |    20096 |
| kovinski - RDEČA - SREDNJA      |    17849 |
| navaden - MODRA - TEMNA         |    17846 |
| navaden - MODRA - SREDNJA       |    16393 |
| navaden - ČRNA - TEMNA          |    13610 |
| navaden - ORANŽNA - SREDNJA     |    11157 |
| navaden - ZELENA - SVETLA       |     9743 |
| kovinski - RJAVA - TEMNA        |     9408 |
| navaden - RUMENA - SREDNJA      |     8159 |
| kovinski - ZELENA - SREDNJA     |     7212 |
| navaden - RDEČA - SVETLA        |     7122 |
| kovinski - RJAVA - SREDNJA      |     7018 |
| navaden - MODRA - SVETLA        |     6953 |
| kovinski - BELA - SVETLA        |     6755 |
| navaden - SIVA - SREDNJA        |     6530 |
| navaden - ZELENA - TEMNA        |     6384 |
| kovinski - BELA - SREDNJA       |     5737 |
| kovinski - RUMENA - TEMNA       |     5470 |
| navaden - SIVA - TEMNA          |     5014 |
| kovinski - ČRNA - SVETLA        |     4996 |
| kovinski - BELA - TEMNA         |     4836 |
| navaden - RUMENA - SVETLA       |     4758 |
| kovinski - ORANŽNA - SREDNJA    |     4345 |
| navaden - RUMENA - TEMNA        |     3938 |
| kovinski - VIJOLIČNA - TEMNA    |     3741 |
| navaden - RJAVA - SVETLA        |     3471 |
| kovinski - RUMENA - SVETLA      |     3392 |
| navaden - SIVA - SVETLA         |     3067 |
| navaden - ORANŽNA - TEMNA       |     3023 |
| kovinski - ORANŽNA - TEMNA      |     2529 |
| navaden - ORANŽNA - SVETLA      |     2525 |
| kovinski - RUMENA - SREDNJA     |     2300 |
| navaden - RJAVA - SREDNJA       |     2204 |
| kovinski - RDEČA - SVETLA       |     2067 |
| NULL                            |     1501 |
| kovinski - ORANŽNA - SVETLA     |      905 |
| navaden - RJAVA - TEMNA         |      827 |
| kovinski - VIJOLIČNA - SREDNJA  |      701 |
| navaden - VIJOLIČNA - TEMNA     |      696 |
| kovinski - VIJOLIČNA - SVETLA   |      635 |
| navaden - ČRNA - SVETLA         |      360 |
| navaden - VIJOLIČNA - SREDNJA   |      210 |
| navaden - VIJOLIČNA - SVETLA    |      111 |
+---------------------------------+----------+

kovinski = metallic
temna = dark
srednja = medium
svetla = light/bright
siva = gray
bela = white
črna = black
rdeča = red
modra = blue
zelena = green
oranžna = orange
rjava = brown

 

I will probably add more queries/results, when I get some new ideas and/or questions.

Leave a Reply

Your email address will not be published. Required fields are marked *