Skip to content

Instantly share code, notes, and snippets.

@damienvancouver

damienvancouver/gist:4261322

Created December 11, 2012 19:29
Show Gist options
  • Save damienvancouver/4261322 to your computer and use it in GitHub Desktop.
Save damienvancouver/4261322 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select fid, uid, filename, uri,type, from_unixtime(timestamp) from file_managed where uri like 'private:///%' order by fid desc;
+------+-----+------------------------------------------------+-----------------------------------------------------------+-------------+--------------------------+
| fid | uid | filename | uri | type | from_unixtime(timestamp) |
+------+-----+------------------------------------------------+-----------------------------------------------------------+-------------+--------------------------+
| 9479 | 8 | 9637444.zip | private:///9637444.zip | application | 2012-12-11 09:10:50 |
| 9476 | 1 | 8014436_1(1)(1).zip | private:///8014436_1(1)(1).zip | application | 2012-12-10 21:45:06 |
| 9474 | 8 | 9637454.zip | private:///9637454.zip | application | 2012-12-10 16:10:16 |
| 9473 | 8 | 9637390.zip | private:///9637390.zip | application | 2012-12-10 15:59:54 |
| 9467 | 8 | 9637389.zip | private:///9637389.zip | application | 2012-12-10 13:12:22 |
| 9463 | 8 | 9637443.zip | private:///9637443.zip | application | 2012-12-10 12:44:01 |
| 9462 | 8 | 9637458.zip | private:///9637458.zip | application | 2012-12-10 12:42:53 |
| 9446 | 8 | 9637441.zip | private:///9637441.zip | application | 2012-12-07 14:08:56 |
| 9443 | 8 | 9637385.zip | private:///9637385.zip | application | 2012-12-07 13:52:19 |
| 9442 | 8 | 9637446.zip | private:///9637446.zip | application | 2012-12-07 13:47:14 |
| 9441 | 8 | 9637445.zip | private:///9637445.zip | application | 2012-12-07 13:43:50 |
| 9440 | 8 | 9637455.zip | private:///9637455.zip | application | 2012-12-07 13:40:44 |
| 9439 | 8 | 9706147-A1.zip | private:///9706147-A1.zip | application | 2012-12-06 15:57:13 |
| 9438 | 8 | 9637270-R.zip | private:///9637270-R.zip | application | 2012-12-06 15:43:59 |
| 9437 | 8 | 9637303.zip | private:///9637303.zip | application | 2012-12-06 15:34:39 |
| 9394 | 8 | 80155-(82,90).zip | private:///80155-(82,90).zip | application | 2012-12-05 09:22:21 |
| 9384 | 8 | 8015584.zip | private:///8015584.zip | application | 2012-12-04 14:05:02 |
| 9383 | 8 | 8015240.zip | private:///8015240.zip | application | 2012-12-04 14:02:18 |
| 9382 | 8 | 8014650.zip | private:///8014650.zip | application | 2012-12-04 13:58:42 |
| 9374 | 8 | 9634553.zip | private:///9634553.zip | application | 2012-12-03 10:55:52 |
| 9373 | 8 | 9707176.zip | private:///9707176.zip | application | 2012-12-03 10:48:11 |
| 9372 | 8 | 9707090.zip | private:///9707090.zip | application | 2012-12-03 10:45:26 |
| 9371 | 8 | 9707088.zip | private:///9707088.zip | application | 2012-12-03 10:43:31 |
| 9370 | 8 | 9637353.zip | private:///9637353.zip | application | 2012-12-03 10:35:45 |
| 9369 | 8 | 96372(62-63).zip | private:///96372(62-63).zip | application | 2012-12-03 09:52:03 |
| 9367 | 8 | 9602491.zip | private:///9602491.zip | application | 2012-12-03 09:49:39 |
| 9366 | 8 | 9601468.zip | private:///9601468.zip | application | 2012-12-03 09:47:24 |
| 9358 | 8 | 8001327.zip | private:///8001327.zip | application | 2012-11-30 10:25:57 |
| 9357 | 8 | 8015604.zip | private:///8015604.zip | application | 2012-11-29 14:08:52 |
| 9356 | 8 | 8015599.zip | private:///8015599.zip | application | 2012-11-29 14:06:57 |
| 9355 | 8 | 8015598.zip | private:///8015598.zip | application | 2012-11-29 14:05:21 |
| 9348 | 8 | 8015563.zip | private:///8015563.zip | application | 2012-11-23 11:22:04 |
| 9346 | 8 | 8015494.zip | private:///8015494.zip | application | 2012-11-22 16:20:12 |
| 9324 | 8 | 9637274.zip | private:///9637274.zip | application | 2012-11-22 13:07:49 |
| 2596 | 1 | K??e_goden�tl�e_geh_Black_Shack.mp3 | private:///K??e_goden�tl�e_geh_Black_Shack.mp3 | audio | 2012-11-01 18:29:38 |
| 2595 | 1 | Neh_Kleh_Tsah_too_deh_sah.mp3 | private:///Neh_Kleh_Tsah_too_deh_sah.mp3 | audio | 2012-11-01 18:29:38 |
| 2594 | 1 | Nado_deh_Snake_River_0.mp3 | private:///Nado_deh_Snake_River_0.mp3 | audio | 2012-11-01 18:29:38 |
| 2593 | 1 | Neh_gon�_tthene_Earth's_Backbone.mp3 | private:///Neh_gon�_tthene_Earth's_Backbone.mp3 | audio | 2012-11-01 18:29:38 |
| 2592 | 1 | Tthek'eneh_Deeze_Muskwa_River.mp3 | private:///Tthek'eneh_Deeze_Muskwa_River.mp3 | audio | 2012-11-01 18:29:38 |
| 2591 | 1 | Dul�_deh_Burn_Island.mp3 | private:///Dul�_deh_Burn_Island.mp3 | audio | 2012-11-01 18:29:38 |
| 2590 | 1 | Gocho_k�_dah_d�l�_Mouth_of_Kotcho.mp3 | private:///Gocho_k�_dah_d�l�_Mouth_of_Kotcho.mp3 | audio | 2012-11-01 18:29:38 |
| 2589 | 1 | Kugocho_Fort_Simpson.mp3 | private:///Kugocho_Fort_Simpson.mp3 | audio | 2012-11-01 18:29:38 |
| 2588 | 1 | Tsia_River.mp3 | private:///Tsia_River.mp3 | audio | 2012-11-01 18:29:38 |
| 2587 | 1 | Tes_datthe_Cabin_Lake.mp3 | private:///Tes_datthe_Cabin_Lake.mp3 | audio | 2012-11-01 18:29:38 |
| 2586 | 1 | Katl'o_mie_Hay_Lakes.mp3 | private:///Katl'o_mie_Hay_Lakes.mp3 | audio | 2012-11-01 18:29:38 |
| 2585 | 1 | Hah_geh_Sandy_Lake.mp3 | private:///Hah_geh_Sandy_Lake.mp3 | audio | 2012-11-01 18:29:38 |
| 2584 | 1 | Sh�h_gaiy�_White_Mountain.mp3 | private:///Sh�h_gaiy�_White_Mountain.mp3 | audio | 2012-11-01 18:29:38 |
| 2582 | 1 | Eh_toh_shee_-_Plant_Mountain.mp3 | private:///Eh_toh_shee_-_Plant_Mountain.mp3 | audio | 2012-11-01 18:29:38 |
| 2581 | 1 | Eh_thah_tha_keh_deeha_Cabot_Blanc_Creek.mp3 | private:///Eh_thah_tha_keh_deeha_Cabot_Blanc_Creek.mp3 | audio | 2012-11-01 18:29:38 |
| 2580 | 1 | Mie_go_cho_Big_Lake.mp3 | private:///Mie_go_cho_Big_Lake.mp3 | audio | 2012-11-01 18:29:38 |
| 2578 | 1 | Nati_deeze_Dreamer's_River.mp3 | private:///Nati_deeze_Dreamer's_River.mp3 | audio | 2012-11-01 18:29:38 |
| 2576 | 1 | Tucho_Deeze_Big_Lake_Creek.mp3 | private:///Tucho_Deeze_Big_Lake_Creek.mp3 | audio | 2012-11-01 18:29:38 |
| 2575 | 1 | Katl'o_deze_Hay_River.mp3 | private:///Katl'o_deze_Hay_River.mp3 | audio | 2012-11-01 18:29:38 |
| 2574 | 1 | Gocho_k�_Kotcho_Lake.mp3 | private:///Gocho_k�_Kotcho_Lake.mp3 | audio | 2012-11-01 18:29:38 |
| 2573 | 1 | Lah_jeh_deh_dee_leh_lee_Box_Creek_0.mp3 | private:///Lah_jeh_deh_dee_leh_lee_Box_Creek_0.mp3 | audio | 2012-11-01 18:29:38 |
| 2572 | 1 | Tsa_chee_deeze_Beaver_Tail_Creek.mp3 | private:///Tsa_chee_deeze_Beaver_Tail_Creek.mp3 | audio | 2012-11-01 18:29:38 |
| 2570 | 1 | Ts'ah_Duthao.mp3 | private:///Ts'ah_Duthao.mp3 | audio | 2012-11-01 18:26:37 |
| 2568 | 1 | Tehtsa_deeze_Bug_River.mp3 | private:///Tehtsa_deeze_Bug_River.mp3 | audio | 2012-11-01 18:26:37 |
| 2567 | 1 | Fonda_dez�_Fontas_River.mp3 | private:///Fonda_dez�_Fontas_River.mp3 | audio | 2012-11-01 18:26:37 |
| 2566 | 1 | Elleh_dez�_Elleh_Creek.mp3 | private:///Elleh_dez�_Elleh_Creek.mp3 | audio | 2012-11-01 18:26:37 |
| 2565 | 1 | Neh_none_tthene_Earth's_Backbone.mp3 | private:///Neh_none_tthene_Earth's_Backbone.mp3 | audio | 2012-11-01 18:26:37 |
| 2564 | 1 | Goh_gochin�_dez�_Ekwan_Shoulderblade_Lake.mp3 | private:///Goh_gochin�_dez�_Ekwan_Shoulderblade_Lake.mp3 | audio | 2012-11-01 18:26:37 |
| 2563 | 1 | Ta-tehnah-Dea.mp3 | private:///Ta-tehnah-Dea.mp3 | audio | 2012-11-01 18:26:37 |
| 2562 | 1 | Sahcho_deeze_Grizzly_Creek.mp3 | private:///Sahcho_deeze_Grizzly_Creek.mp3 | audio | 2012-11-01 18:26:37 |
| 2561 | 1 | Ta-tehnah-Dea_0.mp3 | private:///Ta-tehnah-Dea_0.mp3 | audio | 2012-11-01 18:26:37 |
| 2560 | 1 | Tlicho_Deeze_Horse_Creek.mp3 | private:///Tlicho_Deeze_Horse_Creek.mp3 | audio | 2012-11-01 18:26:37 |
| 2559 | 1 | M?e_gocho.mp3 | private:///M?e_gocho.mp3 | audio | 2012-11-01 18:26:37 |
| 2558 | 1 | Kah-da-choh.mp3 | private:///Kah-da-choh.mp3 | audio | 2012-11-01 18:26:37 |
| 2557 | 1 | Mia_tl'ato_nilai.mp3 | private:///Mia_tl'ato_nilai.mp3 | audio | 2012-11-01 18:26:37 |
| 2556 | 1 | D�dah_tthe_Pretty_Hill.mp3 | private:///D�dah_tthe_Pretty_Hill.mp3 | audio | 2012-11-01 18:26:37 |
| 2555 | 1 | Ts'ah_ndue?_-_Hat_Island.mp3 | private:///Ts'ah_ndue?_-_Hat_Island.mp3 | audio | 2012-11-01 18:26:37 |
| 2554 | 1 | Broken_Arm_Creek_-_Gogo??_k'ei?to??_deeha.mp3 | private:///Broken_Arm_Creek_-_Gogo??_k'ei?to??_deeha.mp3 | audio | 2012-11-01 18:26:37 |
| 2553 | 1 | Mehcho_lahkui_Fort_Liard.mp3 | private:///Mehcho_lahkui_Fort_Liard.mp3 | audio | 2012-11-01 18:26:37 |
| 2552 | 1 | Eh_got�a_Ekwan_Lake.mp3 | private:///Eh_got�a_Ekwan_Lake.mp3 | audio | 2012-11-01 18:26:37 |
| 2551 | 1 | Eh_keh_tsee_moh_deh_zeh_Old_Lady_Creek.mp3 | private:///Eh_keh_tsee_moh_deh_zeh_Old_Lady_Creek.mp3 | audio | 2012-11-01 18:26:37 |
| 2550 | 1 | K'ijie_Mie_Saskatoon_Lake.mp3 | private:///K'ijie_Mie_Saskatoon_Lake.mp3 | audio | 2012-11-01 18:26:37 |
| 2549 | 1 | Tligo_che_Francois.mp3 | private:///Tligo_che_Francois.mp3 | audio | 2012-11-01 18:26:37 |
| 2548 | 1 | Udaaa_dezee_Jackfish_Creek.mp3 | private:///Udaaa_dezee_Jackfish_Creek.mp3 | audio | 2012-11-01 18:26:37 |
| 2547 | 1 | Chia_mie_Chia_Lake.mp3 | private:///Chia_mie_Chia_Lake.mp3 | audio | 2012-11-01 18:26:37 |
| 2546 | 1 | Chia_deeze_Chia_River.mp3 | private:///Chia_deeze_Chia_River.mp3 | audio | 2012-11-01 18:26:37 |
| 2545 | 1 | Lue_mie_Klua_Lake.mp3 | private:///Lue_mie_Klua_Lake.mp3 | audio | 2012-11-01 18:24:37 |
| 2544 | 1 | Meh_tsee_tseh_leh.mp3 | private:///Meh_tsee_tseh_leh.mp3 | audio | 2012-11-01 18:24:37 |
| 2543 | 1 | Lue_deze_Klua_Creek.mp3 | private:///Lue_deze_Klua_Creek.mp3 | audio | 2012-11-01 18:24:37 |
| 2542 | 1 | Leh-coo-tan-yeh_Trail_Turn_Off_0.mp3 | private:///Leh-coo-tan-yeh_Trail_Turn_Off_0.mp3 | audio | 2012-11-01 18:24:37 |
| 2541 | 1 | Tha_ke_Fish_Lake.mp3 | private:///Tha_ke_Fish_Lake.mp3 | audio | 2012-11-01 18:24:37 |
| 2540 | 1 | Keh-theh_go-tsee-eh.mp3 | private:///Keh-theh_go-tsee-eh.mp3 | audio | 2012-11-01 18:24:37 |
| 2539 | 1 | Goh_goh_neh_deh_Broken_Arm.mp3 | private:///Goh_goh_neh_deh_Broken_Arm.mp3 | audio | 2012-11-01 18:24:37 |
| 2538 | 1 | Nu_kaiya_ch�di_Two_Island_Lake.mp3 | private:///Nu_kaiya_ch�di_Two_Island_Lake.mp3 | audio | 2012-11-01 18:24:37 |
| 2537 | 1 | Outaanetdey.mp3 | private:///Outaanetdey.mp3 | audio | 2012-11-01 18:24:37 |
| 2536 | 1 | Lidli_Nelson_Forks_0.mp3 | private:///Lidli_Nelson_Forks_0.mp3 | audio | 2012-11-01 18:24:37 |
| 2535 | 1 | Goh_tah_deh_zeh.mp3 | private:///Goh_tah_deh_zeh.mp3 | audio | 2012-11-01 18:24:37 |
| 2534 | 1 | Medzih_deh_Deer_River.mp3 | private:///Medzih_deh_Deer_River.mp3 | audio | 2012-11-01 18:24:37 |
| 2533 | 1 | Mie_goh_elleh_Long_Skinny_Lake_0.mp3 | private:///Mie_goh_elleh_Long_Skinny_Lake_0.mp3 | audio | 2012-11-01 18:24:37 |
| 2532 | 1 | mee-eh_go_deh-tsee-eh.mp3 | private:///mee-eh_go_deh-tsee-eh.mp3 | audio | 2012-11-01 18:24:37 |
| 2531 | 1 | Ts'ah_Duthao_Hat_Creek.mp3 | private:///Ts'ah_Duthao_Hat_Creek.mp3 | audio | 2012-11-01 18:24:37 |
| 2530 | 1 | Goh_deh_kie_deeze_Steep_Hill_Creek.mp3 | private:///Goh_deh_kie_deeze_Steep_Hill_Creek.mp3 | audio | 2012-11-01 18:21:36 |
| 2529 | 1 | Shi_thetle_Lone_Mountain.mp3 | private:///Shi_thetle_Lone_Mountain.mp3 | audio | 2012-11-01 18:21:36 |
| 2528 | 1 | Klee_Cho_Keh.mp3 | private:///Klee_Cho_Keh.mp3 | audio | 2012-11-01 18:21:36 |
| 2527 | 1 | Sahtene_deze_Sahtanneh_River.mp3 | private:///Sahtene_deze_Sahtanneh_River.mp3 | audio | 2012-11-01 18:21:36 |
| 2526 | 1 | K�e_go_tsats�_deh�_Cabin_Creek.mp3 | private:///K�e_go_tsats�_deh�_Cabin_Creek.mp3 | audio | 2012-11-01 18:21:36 |
| 2525 | 1 | K'a_Deze_Diamond_Willow_Creek.mp3 | private:///K'a_Deze_Diamond_Willow_Creek.mp3 | audio | 2012-11-01 18:21:36 |
| 2524 | 1 | Meh_keh_tsee_eh_tah_Old_Man_Burke_Creek.mp3 | private:///Meh_keh_tsee_eh_tah_Old_Man_Burke_Creek.mp3 | audio | 2012-11-01 18:21:36 |
| 2523 | 1 | Goh_mie_Deze_Komie_River.mp3 | private:///Goh_mie_Deze_Komie_River.mp3 | audio | 2012-11-01 18:21:36 |
| 2522 | 1 | Et'o_sh�h_Leaves_Mountain.mp3 | private:///Et'o_sh�h_Leaves_Mountain.mp3 | audio | 2012-11-01 18:21:36 |
| 2521 | 1 | Eh-to-t_eh.mp3 | private:///Eh-to-t_eh.mp3 | audio | 2012-11-01 18:21:36 |
| 2520 | 1 | Goh_mie_Komie_Lake.mp3 | private:///Goh_mie_Komie_Lake.mp3 | audio | 2012-11-01 18:21:36 |
| 2519 | 1 | Sh�hdah_ehkahe_Pointed_Mountain.mp3 | private:///Sh�hdah_ehkahe_Pointed_Mountain.mp3 | audio | 2012-11-01 18:21:36 |
| 2518 | 1 | Yahka_Deeze_Sikanni_River.mp3 | private:///Yahka_Deeze_Sikanni_River.mp3 | audio | 2012-11-01 18:21:36 |
| 2517 | 1 | Neh_gon�_tthene_k�e_Earth's_Backbone_Cabin.mp3 | private:///Neh_gon�_tthene_k�e_Earth's_Backbone_Cabin.mp3 | audio | 2012-11-01 18:21:36 |
| 2516 | 1 | Tthek'eneh_kue_Old_Fort_0.mp3 | private:///Tthek'eneh_kue_Old_Fort_0.mp3 | audio | 2012-11-01 18:21:36 |
| 2515 | 1 | Kahntah.mp3 | private:///Kahntah.mp3 | audio | 2012-11-01 18:21:36 |
| 2514 | 1 | Natei_deeze_Prophet_River.mp3 | private:///Natei_deeze_Prophet_River.mp3 | audio | 2012-11-01 18:21:36 |
| 2513 | 1 | Eh_deh_keh_stee_deh_eh_Onion_Creek.mp3 | private:///Eh_deh_keh_stee_deh_eh_Onion_Creek.mp3 | audio | 2012-11-01 18:21:36 |
| 2512 | 1 | Meaoulie_Lake_0.mp3 | private:///Meaoulie_Lake_0.mp3 | audio | 2012-11-01 18:21:36 |
| 2511 | 1 | Tedhe_gohsa_deeha_-_Moonshine_Creek.mp3 | private:///Tedhe_gohsa_deeha_-_Moonshine_Creek.mp3 | audio | 2012-11-01 18:20:43 |
| 2510 | 1 | Shiheke_mie_Texaco_Lake.mp3 | private:///Shiheke_mie_Texaco_Lake.mp3 | audio | 2012-11-01 18:20:43 |
| 2509 | 1 | Chuatse_0.mp3 | private:///Chuatse_0.mp3 | audio | 2012-11-01 18:20:43 |
| 2508 | 1 | Di?gahi_deeha_-_Wolf_Creek_0.mp3 | private:///Di?gahi_deeha_-_Wolf_Creek_0.mp3 | audio | 2012-11-01 18:20:43 |
| 2497 | 1 | Willie_Whitehead_Oo'_gah.mp3 | private:///Willie_Whitehead_Oo'_gah.mp3 | audio | 2012-11-01 18:04:38 |
+------+-----+------------------------------------------------+-----------------------------------------------------------+-------------+--------------------------+
119 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment