Reply to thread

Message

<blockquote data-quote="ajs" data-source="post: 1212001" data-attributes="member: 68833">Пробежал скриптом по своей БД:[CODE=SQL]SELECT DISTINCT TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; word,'.',''),'a drug','drug'),'a rape','rape'),'a scene','scene'),'a sexual','sexual'),'brief',''),'for a ',''),'for an ',''),'for ',''),'some ',''),'mild ','')) AS WORDS FROM (WITH split(word, str, offsep) AS (&nbsp; VALUES('',&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; TRIM((SELECT GROUP_CONCAT(COL,'|') FROM (SELECT DISTINCT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(LTRIM(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUBSTR(strPlot,INSTR(strPlot,'MPAA')+6),':'))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,',','|'),'and ','|'),' ',' '),'Rated ',' '),'PG ',' '),'G ',' '),'PG-13 ',' '),'NC-17 ',' '),'R ',' '),'&nbsp; ',' ') AS COL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM movieinfo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE [strPlot] LIKE &quot;%MPAA%&quot; AND INSTR(strPlot,'MPAA')&gt;6)), '| '),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; ) UNION ALL SELECT&nbsp; &nbsp; &nbsp; &nbsp; SUBSTR(str, 0, case when instr(str, '|') then instr(str, '|') else length(str)+1 end),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ltrim(substr(str, instr(str, '|')), '| '),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; instr(str, '|')&nbsp; &nbsp; &nbsp; &nbsp; FROM split&nbsp; &nbsp; &nbsp; &nbsp; WHERE offsep) SELECT word FROM split WHERE word!='') ORDER BY 1;[/CODE]Получил:[code]accident sceneactionaction violenceadventure actionalcohol use - all involving teensbloody violencebloody violence throughoutbrutal medieval warfarebrutal violencecomic actioncrude humorcrude sexual referencedestructiondialogue throughoutdisaster sequencedisturbingdisturbing content involving preteensdisturbing imagesdisturbing materialdisturbing prisoner of war violencedisturbing violent content including torturedrugdrug contentdrug materialdrug referencedrug referencesdrug useexplicit sexual contentextendedfantasy actionfrightening imagesfrightening momentsgoregraphic bloody violencegraphic nuditygraphic sexualitygraphic violencegrisly imagesheavy drug contenthistorical smokingimages of woundedincluding sex-related dialogueinnuendointense actionintense action violenceintense scenes of action violenceintense sci-fi violenceintense sequences of Western violenceintense sequences of sci-fi actionintense sequences of violenceintense stylized actionlanguagelanguage including sexual referenceslanguage throughoutlot of action/violencemartial arts actionmature thematic elementsmature thematic elements including disturbing violent contentmental torture/terrormildly scary actionnuditynudity/sexualityon appeal sexuality/nuditypartial nudityperilperil/ frightening imagespervasive languageprolonged intense disaster sequencesraperelated disturbing imagesrude humorscary actionscary imagesscene of rapescene of sexualityscene of violent sexual contentscenes of sexualitysci-fi actionsci-fi action violencesensualitysequences of intense actionsequences of intense mixed martial arts fightingsequences of intense sci-fi actionsequences of martial arts actionsequences of war violencesexual contentsexual content including dialoguesexual content/nuditysexual imagessexual materialsexual referencesexual referencessexualitysexuality/nuditysmokingsports actionstrong bloody brutal violencestrong bloody violencestrong bloody violence throughoutstrong brutal stylized violence throughoutstrong brutal violencestrong graphic sexual materialstrong languagestrong language including sexual referencesstrong sexual contentstrong sexualitystrong sexuality/nuditystrong violencestrong violence including sexual assaultstrong violence throughoutstrong war violencesubstance abusesuggestivesuggestive contentsuggestive materialsustained intense war sequencessustained strong stylized violencethematic elementsthematic materialthematic material including frightening sequences of threat with violencethematic material involving drugthematic material involving threatening behaviortortureviolenceviolence including disturbing imagesviolence including intense sequences of warfareviolence throughoutviolentviolent contentviolent imagesviolent situationswarwar violence including intense sequences of brutality[/code]По идее можно перевести и вставить в граббер ... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> будет на русском ...</blockquote>

[QUOTE="ajs, post: 1212001, member: 68833"] Пробежал скриптом по своей БД: [CODE=SQL]SELECT DISTINCT TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( word,'.',''),'a drug','drug'),'a rape','rape'),'a scene','scene'),'a sexual','sexual'),'brief',''),'for a ',''),'for an ',''),'for ',''),'some ',''),'mild ','')) AS WORDS FROM ( WITH split(word, str, offsep) AS ( VALUES('', TRIM((SELECT GROUP_CONCAT(COL,'|') FROM (SELECT DISTINCT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(LTRIM( SUBSTR(strPlot,INSTR(strPlot,'MPAA')+6),':')) ,',','|'),'and ','|'),' ',' '),'Rated ',' '),'PG ',' '),'G ',' '),'PG-13 ',' '),'NC-17 ',' '),'R ',' '),' ',' ') AS COL FROM movieinfo WHERE [strPlot] LIKE "%MPAA%" AND INSTR(strPlot,'MPAA')>6)), '| '), 1 ) UNION ALL SELECT SUBSTR(str, 0, case when instr(str, '|') then instr(str, '|') else length(str)+1 end), ltrim(substr(str, instr(str, '|')), '| '), instr(str, '|') FROM split WHERE offsep ) SELECT word FROM split WHERE word!='') ORDER BY 1;[/CODE] Получил: [code]accident scene action action violence adventure action alcohol use - all involving teens bloody violence bloody violence throughout brutal medieval warfare brutal violence comic action crude humor crude sexual reference destruction dialogue throughout disaster sequence disturbing disturbing content involving preteens disturbing images disturbing material disturbing prisoner of war violence disturbing violent content including torture drug drug content drug material drug reference drug references drug use explicit sexual content extended fantasy action frightening images frightening moments gore graphic bloody violence graphic nudity graphic sexuality graphic violence grisly images heavy drug content historical smoking images of wounded including sex-related dialogue innuendo intense action intense action violence intense scenes of action violence intense sci-fi violence intense sequences of Western violence intense sequences of sci-fi action intense sequences of violence intense stylized action language language including sexual references language throughout lot of action/violence martial arts action mature thematic elements mature thematic elements including disturbing violent content mental torture/terror mildly scary action nudity nudity/sexuality on appeal sexuality/nudity partial nudity peril peril/ frightening images pervasive language prolonged intense disaster sequences rape related disturbing images rude humor scary action scary images scene of rape scene of sexuality scene of violent sexual content scenes of sexuality sci-fi action sci-fi action violence sensuality sequences of intense action sequences of intense mixed martial arts fighting sequences of intense sci-fi action sequences of martial arts action sequences of war violence sexual content sexual content including dialogue sexual content/nudity sexual images sexual material sexual reference sexual references sexuality sexuality/nudity smoking sports action strong bloody brutal violence strong bloody violence strong bloody violence throughout strong brutal stylized violence throughout strong brutal violence strong graphic sexual material strong language strong language including sexual references strong sexual content strong sexuality strong sexuality/nudity strong violence strong violence including sexual assault strong violence throughout strong war violence substance abuse suggestive suggestive content suggestive material sustained intense war sequences sustained strong stylized violence thematic elements thematic material thematic material including frightening sequences of threat with violence thematic material involving drug thematic material involving threatening behavior torture violence violence including disturbing images violence including intense sequences of warfare violence throughout violent violent content violent images violent situations war war violence including intense sequences of brutality[/code] По идее можно перевести и вставить в граббер ... :) будет на русском ... [/QUOTE]

Verification