All pastes #523113 Raw Edit

Untitled

public text v1 · immutable
#523113 ·published 2007-05-30 17:47 UTC
rendered paste body
SELECT SQL_CALC_FOUND_ROWS p.post_id FROM (phpbb3_search_w
ordmatch m0, phpbb3_search_wordmatch m1, phpbb3_search_wordmatch m2, phpbb3_search_wordmatch m3, phpbb3_search_wordmatch m4, phpbb3_
search_wordmatch m5, phpbb3_search_wordmatch m6, phpbb3_search_wordmatch m7, phpbb3_search_wordmatch m8, phpbb3_search_wordmatch m9,
 phpbb3_search_wordmatch m10, phpbb3_search_wordmatch m11, phpbb3_search_wordmatch m12, phpbb3_search_wordmatch m13, phpbb3_posts p)
 WHERE m0.post_id = p.post_id AND m0.word_id = 433 AND m1.word_id = 433 AND m1.post_id = m0.post_id AND m2.word_id = 434 AND m2.post
_id = m0.post_id AND m3.word_id = 434 AND m3.post_id = m0.post_id AND m4.word_id = 494 AND m4.post_id = m0.post_id AND m5.word_id =
494 AND m5.post_id = m0.post_id AND m6.word_id = 1498 AND m6.post_id = m0.post_id AND m7.word_id = 1498 AND m7.post_id = m0.post_id
AND m8.word_id = 2313 AND m8.post_id = m0.post_id AND m9.word_id = 2313 AND m9.post_id = m0.post_id AND m10.word_id = 2590 AND m10.p
ost_id = m0.post_id AND m11.word_id = 2590 AND m11.post_id = m0.post_id AND m12.word_id = 2743 AND m12.post_id = m0.post_id AND m13.
word_id = 2743 AND m13.post_id = m0.post_id AND p.post_approved = 1 AND p.forum_id NOT IN (7, 9, 11, 23, 24, 28, 32, 35, 38, 39, 40,
 41, 42, 43, 44, 45, 47, 48, 51, 52, 53, 54, 55, 56, 57) GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC
 LIMIT 250