<dynamic prepend="WHERE">
<iterate property="keywordList" conjunction="OR">
lower(name) like lower(#keywordList[]#) OR
lower(categoryid) like lower(#keywordList[]#) OR
lower(description) like lower(#keywordList[]#)
</iterate>
</dynamic>
<dynamic prepend="WHERE riyousya_id IN ">
<iterate property="employers"
open="(" close=")"
conjunction=",">
#employers[]#
</iterate>
</dynamic>