SQLExportServer.rdoc

@@ -8,7 +8,7 @@ Pred volanim musime nastavit vystup:
  .out 'stats.csv'
 ```
 
-Dotaz:
+Dotaz pro export ve formátu jako na webu:
 ```sql
 SELECT strftime('%d.%m.%Y', played.start_time) as Datum, strftime('%H:%M:%S', played.start_time) as Zacatek, CASE WHEN (strftime('%s', played.end_time) - strftime('%s', played.start_time) < 0) THEN 'nedohrano' ELSE cast(strftime('%s', played.end_time) - strftime('%s', played.start_time) as TEXT) || 's' END as Doba, game.name as Hra, played.difficulty as Obtiznost, played.counter as Counter, played.extra_int_1 as extra_int_1, played.extra_int_2 as extra_int_2, played.extra_int_3 as extra_int_3, played.extra_int_4 as extra_int_4, played.stars_number as stars_number, played.game_pauses as Pauzy, user.nick_name as Nick, CASE WHEN user.is_male = 1 THEN 'Muž' ELSE 'Žena' END as Pohlavi, user.age as Vek, user.device_id as device_id, user.remote_id as user_id FROM stats_gameplayed played JOIN stats_upload upload ON upload.id = played.upload_id JOIN stats_game game ON played.game_id = game.id JOIN stats_user user ON user.id = played.user_id;
 ```