SELECT DISTINCT mod.id AS mod_id, mod.created AS mod_created, mod.updated AS mod_updated, mod.user_id AS mod_user_id, mod.game_id AS mod_game_id, mod.name AS mod_name, mod.description AS mod_description, mod.short_description AS mod_short_description, mod.published AS mod_published, mod.locked AS mod_locked, mod.locked_by_id AS mod_locked_by_id, mod.lock_reason AS mod_lock_reason, mod.donation_link AS mod_donation_link, mod.external_link AS mod_external_link, mod.license AS mod_license, mod.votes AS mod_votes, mod.score AS mod_score, mod.background AS mod_background, mod."bgOffsetX" AS "mod_bgOffsetX", mod."bgOffsetY" AS "mod_bgOffsetY", mod.default_version_id AS mod_default_version_id, mod.source_link AS mod_source_link, mod.follower_count AS mod_follower_count, mod.download_count AS mod_download_count, mod.ckan AS mod_ckan 
FROM mod JOIN "user" ON "user".id = mod.user_id JOIN modversion ON mod.id = modversion.mod_id JOIN game ON game.id = mod.game_id 
WHERE mod.game_id = 3102 AND mod.published = true AND (mod.name ILIKE '%%' OR mod.short_description ILIKE '%%' OR mod.description ILIKE '%%') ORDER BY mod.score  DESC
LIMIT 30 OFFSET 0