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
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 |
|