Shahelm

SELECT 
    indexing_link.id, 
    indexing_link.url, 
    indexing_link.title, 
    indexing_link.short
FROM indexing_link, indexing_link_word, indexing_word
WHERE 
    (:searchWords)
    AND indexing_word.word  not in (:stopWords)
    AND indexing_link_word.word_id=indexing_word.id
    AND indexing_link.id=indexing_link_word.link_id

SELECT temp.fl1, temp.fl2
FROM (
    SELECT t1.field1 as fl1, Max(t2.field2) AS fl2
        FROM t1 
    INNER JOIN t2 ON t1.id = t2.id
) as temp
WHERE temp.fl2 < 50