404

[ Avaa Bypassed ]




Upload:

Command:

botdev@18.225.156.49: ~ $
SELECT *, false as related FROM   `musiceri_telegram_bot`.`bayadic_dictionary_de_fa` where word like 'Buch' or translation like 'Buch' UNION (SELECT *,true as related FROM bayadic_dictionary_de_fa WHERE id IN (SELECT id FROM bayadic_related_words_de_fa WHERE word LIKE 'Buch'))
-- reformed
SELECT *, false as related FROM `musiceri_telegram_bot`.`bayadic_dictionary_de_fa_paired_not_used` where word like 'Buch' or translation like 'Buch' UNION (SELECT *,true as related FROM `musiceri_telegram_bot`.`bayadic_dictionary_de_fa_paired_not_used` WHERE id IN (SELECT id FROM bayadic_related_words_de_fa WHERE word LIKE 'Buch'))




--- new way 2
SELECT * FROM bayadic_dictionary_words_fa INNER JOIN bayadic_dictionary_de_fa ON bayadic_dictionary_words_fa.id = bayadic_dictionary_de_fa.worddeID INNER JOIN  bayadic_dictionary_words_de on  bayadic_dictionary_de_fa.worddeID = bayadic_dictionary_words_de.id WHERE  bayadic_dictionary_words_fa.word LIKE 'کتاب'";

-- book
SELECT * FROM bayadic_dictionary_words_fa INNER JOIN bayadic_dictionary_de_fa
 ON bayadic_dictionary_words_fa.id = bayadic_dictionary_de_fa.worddeID INNER JOIN  bayadic_dictionary_words_de
  on  bayadic_dictionary_de_fa.worddeID = bayadic_dictionary_words_de.id WHERE
    bayadic_dictionary_words_fa.word LIKE 'buch';

-- together
SELECT * FROM bayadic_dictionary_words_fa INNER JOIN bayadic_dictionary_de_fa
 ON bayadic_dictionary_words_fa.id = bayadic_dictionary_de_fa.worddeID INNER JOIN  bayadic_dictionary_words_de
  on  bayadic_dictionary_de_fa.worddeID = bayadic_dictionary_words_de.id WHERE
    bayadic_dictionary_words_fa.word LIKE 'buch' or bayadic_dictionary_words_de.word  LIKE 'buch';

-- selective way of solutio n2
SELECT bayadic_dictionary_words_de.word,bayadic_dictionary_words_de.perfect,bayadic_dictionary_words_de.artikel,bayadic_dictionary_words_fa.word FROM bayadic_dictionary_words_fa INNER JOIN bayadic_dictionary_de_fa ON bayadic_dictionary_words_fa.id = bayadic_dictionary_de_fa.worddeID INNER JOIN bayadic_dictionary_words_de on bayadic_dictionary_de_fa.worddeID = bayadic_dictionary_words_de.id WHERE bayadic_dictionary_words_fa.word LIKE 'buch' or bayadic_dictionary_words_de.word LIKE 'buch'


-- new way 3
-- first try
select * from bayadic_dictionary_words_fa where id in (select wordFaID from bayadic_dictionary_de_fa where id in (select id from bayadic_dictionary_words_de WHERE word like "buch"))

-- new way 4
SELECT * FROM bayadic_dictionary_words_de , bayadic_dictionary_de_fa,bayadic_dictionary_words_fa WHERE bayadic_dictionary_words_de.word like 'buch' and bayadic_dictionary_words_de.id = bayadic_dictionary_de_fa.worddeID and bayadic_dictionary_words_fa.id = bayadic_dictionary_de_fa.wordfaID
-- refined 
SELECT bayadic_dictionary_words_de.word, bayadic_dictionary_words_de.artikel, bayadic_dictionary_words_de.perfect, bayadic_dictionary_words_de.plural, bayadic_dictionary_words_fa.word as translation, bayadic_dictionary_de_fa.related FROM bayadic_dictionary_words_de , bayadic_dictionary_de_fa,bayadic_dictionary_words_fa WHERE (bayadic_dictionary_words_de.word like 'آسایش' or bayadic_dictionary_words_fa.word LIKE 'آسایش') and bayadic_dictionary_words_de.id = bayadic_dictionary_de_fa.worddeID and bayadic_dictionary_words_fa.id = bayadic_dictionary_de_fa.wordfaID

-- old way

(SELECT id, artikel,word,perfect,plural,translation,soundFile FROM  `musiceri_telegram_bot`.`dictionary` where searchedWord='buch' AND status='de' limit 60) UNION ALL
                SELECT (id+255700) as id, artikel ,word, '' AS perfekt, '' AS plural, translation, '' AS soundFile FROM  `musiceri_telegram_bot`.`dicusers_contribution` where word='buch' AND translation !='' AND adminOpinion ='adminConfirmed'  or translation Like '%".buch."%' AND adminOpinion ='adminConfirmed' order by id

Filemanager

Name Type Size Permission Actions
.angular Folder 0755
.git Folder 0755
docker-images Folder 0755
e2e Folder 0755
node_modules Folder 0755
resources Folder 0755
src Folder 0755
tests Folder 0755
.eslintrc.json File 1.04 KB 0644
.gitignore File 1.05 KB 0644
.gitlab-ci.yml File 3.2 KB 0644
.gitmodules File 129 B 0644
Bayadic-Info.plist File 7.68 KB 0644
LICENSE File 1.92 KB 0644
angular.json File 4.13 KB 0644
browserslist File 536 B 0644
build-tasks File 584 B 0644
capacitor.config.json File 3 B 0644
capacitor.config.ts File 228 B 0644
config.xml File 8.1 KB 0644
docker-compose.yml File 263 B 0644
google-services.json File 1.64 KB 0644
ionic.config.json File 93 B 0644
jest.config.js File 214 B 0644
karma.conf.js File 1.39 KB 0644
nohup.out File 9.23 KB 0600
old_permissions.txt File 238 B 0644
package-lock.json File 900.86 KB 0644
package.json File 5.02 KB 0644
remake.sh File 53 B 0755
remove_permissions.js File 701 B 0644
setup-jest.ts File 41 B 0644
speed-notes File 3.71 KB 0644
tsconfig.app.json File 349 B 0644
tsconfig.json File 986 B 0644
tsconfig.spec.json File 234 B 0644
tslint.json File 1.8 KB 0644