Order and limit in prefilter query

[Martooti]

I have a problem with limit in prefilter. Seems like it doesnt work.
It is made for category equals query
It generated 3 values not 1. In phpmyadmin it return just 1 value.
I tried to use prefilter query below the prefilters and than enter in prefilter where category equals $q->m.id, but still limit doesnt apply

My query is

SELECT m.id FROM jos_menu AS m JOIN fb_rightmiddlebanner AS b ON b.category = m.id WHERE lft <= (SELECT lft FROM jos_menu WHERE id = '{$Itemid}')  AND rgt >= (SELECT rgt FROM jos_menu WHERE id = '{$Itemid}') AND lft >=  (SELECT lft FROM jos_menu AS m JOIN fb_rightmiddlebanner AS b ON b.category = m.id WHERE lft < (SELECT lft FROM jos_menu WHERE id = '{$Itemid}') AND rgt > (SELECT rgt FROM jos_menu WHERE id = '{$Itemid}') ORDER BY rgt LIMIT 1) AND rgt <= (SELECT rgt FROM jos_menu AS m JOIN fb_rightmiddlebanner AS b ON b.category = m.id WHERE lft < (SELECT lft FROM jos_menu WHERE id = '{$Itemid}') AND rgt > (SELECT rgt FROM jos_menu WHERE id = '{$Itemid}') ORDER BY rgt LIMIT 1) ORDER BY rgt LIMIT 1

Any ideas how to make it work?
I need to show many rows but all of them from only one category