[ Avaa Bypassed ]

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