Victor Shepelev zverok
zverok
/ gist:7809838
Created
December 5, 2013 17:40
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 0,1,10,100,1000002,1000010,1000028,1000030,1000032,1000037,1000038,1000040,1000046,1000049,1000050,1000057,1000062,1000066,1000069,1000071,1000076,1000080,1000083,1000086,1000093,1000103,1000105,1000106,1000113,1000115,1000125,1000126,1000148,1000149,1000154,1000160,1000166,1000169,1000170,1000182,1000195,1000199,1000207,1000215,1000219,1000231,1000234,1000247,1000256,1000257,1000281,1000294,1000306,1000322,1000329,1000350,1000354,1000390,1000432,1000438,1000442,1000496,1000510,1000525,1000527,1000541,1000553,1000566,1000569,1000622,1000652,1000681,1000686,1000731,1000735,1000769,1000771,1000773,1000846,10009,1000924,1000934,1000970,1000987,1001007,1001012,1001054,1001066,1001082,1001091,1001095,1001153,1001201,1001266,1001270,1001326,1001340,1001393,10014,1001414,1001437,1001438,1001468,1001482,1001507,1001535,1001585,1001607,1001723,1001748,1001754,1001761,1001763,1001806,1001884,1001931,1001995,1002,1002088,1002139,1002153,1002180,1002181,1002195,1002196,10022,1002200,1002244,1002245,1002248,1002251,100229 |
zverok
/ gist:7757193
Created
December 2, 2013 19:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="windows-1251"?> | |
| <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> | |
| <xs:element name="message"> | |
| <xs:complexType> | |
| <xs:sequence> | |
| <xs:element name="author"> | |
| <xs:complexType> | |
| <xs:sequence> | |
| <xs:element name="nickname" type="xs:string" /> | |
| <xs:element name="fullname" type="xs:string" /> |
zverok
/ gist:7645959
Created
November 25, 2013 18:20
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> explain SELECT `mentions_client_549`.* FROM `mentions_client_549` INNER JOIN `mention_details` ON ((`mention_details`.`mention_id` = `mentions_client_549`.`id`) AND (`mention_details`.`client_id` = 549)) WHERE ((`created_at` >= '2013-01-24 20:00:00') AND (`url` LIKE BINARY '%vk.com%' ESCAPE '\\')) ORDER BY `created_at` DESC LIMIT 10 OFFSET 0\G | |
| *************************** 1. row *************************** | |
| id: 1 | |
| select_type: SIMPLE | |
| table: mention_details | |
| type: ref | |
| possible_keys: client_id,mention_details_client_id_label_id_index | |
| key: mention_details_client_id_label_id_index | |
| key_len: 4 | |
| ref: const |
zverok
/ gist:7216784
Created
October 29, 2013 15:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Popular ethnic cuisines | |
| Columns: Indian; Chinese; Japan; Mexican; Italian; Jewish | |
| Rows: Most prominent dishes; Main ingredients; Spices; Cooking methods; Healthness; Spread outside origin country | |
| 2. Fiction human futures | |
| Columns: Space; Robotic; New Middle Age; Alien Invasion; The Matrix; Post-Apocaliptic | |
| Rows: First described by; Most prominent novels; Social structure; Races and ethnoses; Civilisation problems; Real possibilities |
zverok
/ gist:7136704
Created
October 24, 2013 12:54
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| I, [2013-10-24T15:51:39.548194 #20420] INFO -- : (0.190697s) SELECT * FROM `clients` WHERE (`id` = 493) LIMIT 1 | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */ | |
| I, [2013-10-24T15:51:39.649928 #20420] INFO -- : (0.100140s) SELECT * FROM `seeds` WHERE (`id` = 6454) LIMIT 1 | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */ | |
| I, [2013-10-24T15:51:39.752148 #20420] INFO -- : (0.100764s) SELECT * FROM `fetches` WHERE (`id` = 105767189) ORDER BY `fetched_at` LIMIT 1 | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */ | |
| I, [2013-10-24T15:51:39.855099 #20420] INFO -- : (0.100289s) DESCRIBE `mentions_client_493` | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:34:in `block in make_class' */ | |
| I, [2013-10-24T15:51:39.957995 #20420] INFO -- : (0.093005s) SELECT * FROM `mentions_client_493` WHERE (`url` = 'http://facebook.com/640 |
zverok
/ gist:7136440
Created
October 24, 2013 12:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| I, [2013-10-24T15:35:15.907842 #19391] INFO -- : (0.167803s) SELECT * FROM `clients` WHERE (`id` = 4) LIMIT 1 | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */ | |
| I, [2013-10-24T15:35:16.111724 #19391] INFO -- : (0.202800s) SELECT * FROM `seeds` WHERE (`id` = 7) LIMIT 1 | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */ | |
| I, [2013-10-24T15:35:16.316790 #19391] INFO -- : (0.203984s) SELECT * FROM `fetches` WHERE (`id` = 3556821) ORDER BY `fetched_at` LIMIT 1 | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */ | |
| I, [2013-10-24T15:35:16.522125 #19391] INFO -- : (0.203088s) DESCRIBE `mentions_client_4` | |
| /* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:34:in `block in make_class' */ | |
| I, [2013-10-24T15:35:16.727251 #19391] INFO -- : (0.196742s) SELECT * FROM `mentions_client_4` WHERE (`url` = 'http://vk.com/wall-341229_11455_') |
zverok
/ gist:7008241
Created
October 16, 2013 14:02
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "@context":{ | |
| "schema":"http://schema.org/", | |
| "olo":"http://purl.org/ontology/olo/core#", | |
| "gbt":"http://grids.by/types/", | |
| "gbr":"http://grids.by/relations/", | |
| "name":"schema:name", | |
| "description":"schema:description", | |
| "Document":"gbt:Document", | |
| "Axis":"gbt:Axis", |
zverok
/ gist:7007471
Created
October 16, 2013 13:10
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "@graph": [ | |
| { | |
| "@id": "http://grids.by/zverok/doctor.who/documents/Episodes/cols", | |
| "@type": "http://grids.by/types/Axis", | |
| "http://purl.org/ontology/olo/core#length": 4, | |
| "http://purl.org/ontology/olo/core#slot": [ | |
| { | |
| "@id": "http://grids.by/zverok/doctor.who/documents/Episodes/cols/slot/1" | |
| }, |
zverok
/ gist:6881625
Created
October 8, 2013 08:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| id: 52541, | |
| title: "Сдаю 1 комнатную квартиру от собственника", | |
| body: "Сдаю 1комнатную квартиру на ДЛИТЕЛЬНЫЙ срок,семейной паре (желательно без детей) М.Каширская мкрн Сабурово (10 минут транспортом) общ пл.38 кв.м. кухня 9, комн.19 холл 6кв.м металл.дверь домофон 9 эт.17 эт.дома балкон в квартире есть все необходимое для проживания на кухне холодильник имп. эл.плита, микроволновка и т.д. ванная совмещенная имеется стиралка имп. ... Подробнее", | |
| url: "http://realtonews.livejournal.com/6233909.html", | |
| platform: { | |
| id: 3, | |
| name: "LiveJournal", | |
| url: "http://www.livejournal.com/" | |
| }, |
zverok
/ gist:6702650
Created
September 25, 2013 17:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "author" => { | |
| "guid" => "46970801", | |
| "name" => nil, | |
| "url" => "http://vk.com/club46970801" | |
| }, | |
| "body" => "В покушении на шехзадэ Селима виновата снова Махидевран? Может таким образом \"чистит\" дорогу в Манису Мустафе? Или кто-то другой замешан в этом?\nПодготовлено группой \" http://vk.com/muhtesem_public \"\nУважайте чужой труд. Если будет копирование без указания истояник грозит БАН\n\n", | |
| "created_at" => "2013-09-25T16:24:28+04:00", | |
| "fetch" => { | |
| "id" => "3242394" |