Reply to thread

Message

<blockquote data-quote="ajs" data-source="post: 1010516" data-attributes="member: 68833">For MyVideo:[CODE]SELECT imdbid, strTitle, m.idMovie, m.mpaa, a.[videoResolution], a.[videoCodec], a.[audioCodec], a.[audioChannels] from movieinfo m LEFT JOIN (SELECT f.[idMovie], i.[videoResolution], i.[videoCodec], i.[audioCodec], i.[audioChannels] FROM files f, filesmediainfo i WHERE f.[idFile] = i.[idFile]) a ON m.[idMovie]=a.[idMovie][/CODE]Result:[CODE]IMDBID&nbsp; &nbsp; strTitle&nbsp; &nbsp; idMovie&nbsp; &nbsp; mpaa&nbsp; &nbsp; videoResolution&nbsp; &nbsp; videoCodec&nbsp; &nbsp; audioCodec&nbsp; &nbsp; audioChannelstt0443272&nbsp; &nbsp; Lincoln&nbsp; &nbsp; 1&nbsp; &nbsp; PG-13&nbsp; &nbsp; 1080I&nbsp; &nbsp; MPEG VIDEO VERSION 2 MAIN@HIGH&nbsp; &nbsp; PCM&nbsp; &nbsp; stereott2261719&nbsp; &nbsp; Джунгли&nbsp; &nbsp; 4&nbsp; &nbsp; 6&nbsp; &nbsp; SD&nbsp; &nbsp; DX50&nbsp; &nbsp; PCM&nbsp; &nbsp; stereott1782568&nbsp; &nbsp; Ёлки&nbsp; &nbsp; 5&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt2124096&nbsp; &nbsp; Ёлки 2&nbsp; &nbsp; 6&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt2593290&nbsp; &nbsp; Дублёр&nbsp; &nbsp; 7&nbsp; &nbsp; 16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt0186566&nbsp; &nbsp; Space Cowboys&nbsp; &nbsp; 3&nbsp; &nbsp; PG-13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1449283&nbsp; &nbsp; Winnie the Pooh&nbsp; &nbsp; 9&nbsp; &nbsp; G&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1649419&nbsp; &nbsp; Lo imposible&nbsp; &nbsp; 10&nbsp; &nbsp; PG-13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt0084787&nbsp; &nbsp; The Thing&nbsp; &nbsp; 11&nbsp; &nbsp; R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt0905372&nbsp; &nbsp; The Thing&nbsp; &nbsp; 12&nbsp; &nbsp; R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1595366&nbsp; &nbsp; О чём говорят мужчины&nbsp; &nbsp; 13&nbsp; &nbsp; 16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1863347&nbsp; &nbsp; О чём ещё говорят мужчины&nbsp; &nbsp; 14&nbsp; &nbsp; 16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; unknown&nbsp; &nbsp; Верёвка из песка&nbsp; &nbsp; 17&nbsp; &nbsp; 12&nbsp; &nbsp; 1080I&nbsp; &nbsp; MPEG VIDEO VERSION 2 MAIN@HIGH&nbsp; &nbsp; PCM&nbsp; &nbsp; stereott1826660&nbsp; &nbsp; ДухLess&nbsp; &nbsp; 8&nbsp; &nbsp; 18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1343727&nbsp; &nbsp; Dredd&nbsp; &nbsp; 15&nbsp; &nbsp; R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt0903624&nbsp; &nbsp; The Hobbit: An Unexpected Journey&nbsp; &nbsp; 16&nbsp; &nbsp; PG-13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1597522&nbsp; &nbsp; Astérix et Obélix: Au service de Sa Majesté&nbsp; &nbsp; 19&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt0119116&nbsp; &nbsp; The Fifth Element&nbsp; &nbsp; 21&nbsp; &nbsp; PG-13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt0213149&nbsp; &nbsp; Pearl Harbor&nbsp; &nbsp; 22&nbsp; &nbsp; PG-13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; tt1245526&nbsp; &nbsp; Red&nbsp; &nbsp; 23&nbsp; &nbsp; PG-13&nbsp; &nbsp; 1080I&nbsp; &nbsp; MPEG VIDEO VERSION 2 MAIN@HIGH&nbsp; &nbsp; PCM&nbsp; &nbsp; stereo[/CODE]&nbsp;For MovingPictures:[CODE]SELECT distinct imdb_id, title, id, certification, a.[videoresolution], a.[videocodec], a.[audiocodec], a.[audiochannels] FROM movie_info m LEFT JOIN(SELECT f.[movie_info_id], i.[videoresolution], i.[videocodec], i.[audiocodec], i.[audiochannels] FROM local_media__movie_info f, local_media i WHERE f.[local_media_id] = i.[id]) a ON m.[id]=a.[movie_info_id][/CODE]Result:[CODE]imdb_id&nbsp; &nbsp; title&nbsp; &nbsp; id&nbsp; &nbsp; certification&nbsp; &nbsp; videoresolution&nbsp; &nbsp; videocodec&nbsp; &nbsp; audiocodec&nbsp; &nbsp; audiochannelstt1782568&nbsp; &nbsp; Ёлки&nbsp; &nbsp; 1&nbsp; &nbsp; 12&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt1863347&nbsp; &nbsp; О чём ещё говорят мужчины&nbsp; &nbsp; 2&nbsp; &nbsp; 16&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt0905372&nbsp; &nbsp; The Thing&nbsp; &nbsp; 3&nbsp; &nbsp; R&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt1595366&nbsp; &nbsp; О чём говорят мужчины&nbsp; &nbsp; 4&nbsp; &nbsp; 16&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; Японка&nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; 1080i&nbsp; &nbsp; MP2V&nbsp; &nbsp; PCM&nbsp; &nbsp; stereott0084787&nbsp; &nbsp; The Thing&nbsp; &nbsp; 7&nbsp; &nbsp; R&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt1343727&nbsp; &nbsp; Dredd&nbsp; &nbsp; 8&nbsp; &nbsp; R&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt0903624&nbsp; &nbsp; The Hobbit: An Unexpected Journey&nbsp; &nbsp; 9&nbsp; &nbsp; PG-13&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt1597522&nbsp; &nbsp; Astérix et Obélix: Au service de Sa Majesté&nbsp; &nbsp; 10&nbsp; &nbsp; 12&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt1649419&nbsp; &nbsp; Lo imposible&nbsp; &nbsp; 13&nbsp; &nbsp; PG-13&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt0186566&nbsp; &nbsp; Space Cowboys&nbsp; &nbsp; 14&nbsp; &nbsp; PG-13&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt0443272&nbsp; &nbsp; Lincoln&nbsp; &nbsp; 15&nbsp; &nbsp; PG-13&nbsp; &nbsp; 1080i&nbsp; &nbsp; MP2V&nbsp; &nbsp; PCM&nbsp; &nbsp; stereott1826660&nbsp; &nbsp; ДухLess&nbsp; &nbsp; 16&nbsp; &nbsp; 18&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt2261719&nbsp; &nbsp; Джунгли&nbsp; &nbsp; 17&nbsp; &nbsp; 6&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt1449283&nbsp; &nbsp; Winnie the Pooh&nbsp; &nbsp; 18&nbsp; &nbsp; G&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt2593290&nbsp; &nbsp; Дублёр&nbsp; &nbsp; 19&nbsp; &nbsp; 16&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0tt2124096&nbsp; &nbsp; Ёлки 2&nbsp; &nbsp; 20&nbsp; &nbsp; 12&nbsp; &nbsp; SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0[/CODE]&nbsp;This is something that I can give, if I want, I'll do it.&nbsp;Then convert from a string to a number, that is, on the contrary we have of the numbers in a word. <a href="http://delphi.about.com/od/objectpascalide/a/curr2words.htm" target="_blank">http://delphi.about.com/od/objectpascalide/a/curr2words.htm</a></blockquote>

[QUOTE="ajs, post: 1010516, member: 68833"] For MyVideo: [CODE]SELECT imdbid, strTitle, m.idMovie, m.mpaa, a.[videoResolution], a.[videoCodec], a.[audioCodec], a.[audioChannels] from movieinfo m LEFT JOIN (SELECT f.[idMovie], i.[videoResolution], i.[videoCodec], i.[audioCodec], i.[audioChannels] FROM files f, filesmediainfo i WHERE f.[idFile] = i.[idFile]) a ON m.[idMovie]=a.[idMovie][/CODE] Result: [CODE]IMDBID strTitle idMovie mpaa videoResolution videoCodec audioCodec audioChannels tt0443272 Lincoln 1 PG-13 1080I MPEG VIDEO VERSION 2 MAIN@HIGH PCM stereo tt2261719 Джунгли 4 6 SD DX50 PCM stereo tt1782568 Ёлки 5 12 tt2124096 Ёлки 2 6 12 tt2593290 Дублёр 7 16 tt0186566 Space Cowboys 3 PG-13 tt1449283 Winnie the Pooh 9 G tt1649419 Lo imposible 10 PG-13 tt0084787 The Thing 11 R tt0905372 The Thing 12 R tt1595366 О чём говорят мужчины 13 16 tt1863347 О чём ещё говорят мужчины 14 16 unknown Верёвка из песка 17 12 1080I MPEG VIDEO VERSION 2 MAIN@HIGH PCM stereo tt1826660 ДухLess 8 18 tt1343727 Dredd 15 R tt0903624 The Hobbit: An Unexpected Journey 16 PG-13 tt1597522 Astérix et Obélix: Au service de Sa Majesté 19 12 tt0119116 The Fifth Element 21 PG-13 tt0213149 Pearl Harbor 22 PG-13 tt1245526 Red 23 PG-13 1080I MPEG VIDEO VERSION 2 MAIN@HIGH PCM stereo [/CODE] For MovingPictures: [CODE]SELECT distinct imdb_id, title, id, certification, a.[videoresolution], a.[videocodec], a.[audiocodec], a.[audiochannels] FROM movie_info m LEFT JOIN (SELECT f.[movie_info_id], i.[videoresolution], i.[videocodec], i.[audiocodec], i.[audiochannels] FROM local_media__movie_info f, local_media i WHERE f.[local_media_id] = i.[id]) a ON m.[id]=a.[movie_info_id][/CODE] Result: [CODE]imdb_id title id certification videoresolution videocodec audiocodec audiochannels tt1782568 Ёлки 1 12 SD 0 tt1863347 О чём ещё говорят мужчины 2 16 SD 0 tt0905372 The Thing 3 R SD 0 tt1595366 О чём говорят мужчины 4 16 SD 0 Японка 6 1080i MP2V PCM stereo tt0084787 The Thing 7 R SD 0 tt1343727 Dredd 8 R SD 0 tt0903624 The Hobbit: An Unexpected Journey 9 PG-13 SD 0 tt1597522 Astérix et Obélix: Au service de Sa Majesté 10 12 SD 0 tt1649419 Lo imposible 13 PG-13 SD 0 tt0186566 Space Cowboys 14 PG-13 SD 0 tt0443272 Lincoln 15 PG-13 1080i MP2V PCM stereo tt1826660 ДухLess 16 18 SD 0 tt2261719 Джунгли 17 6 SD 0 tt1449283 Winnie the Pooh 18 G SD 0 tt2593290 Дублёр 19 16 SD 0 tt2124096 Ёлки 2 20 12 SD 0 [/CODE] This is something that I can give, if I want, I'll do it. Then convert from a string to a number, that is, on the contrary we have of the numbers in a word. [url]http://delphi.about.com/od/objectpascalide/a/curr2words.htm[/url] [/QUOTE]

Verification