I finish some selections with hibernate criteria but now that criterias need to work with big collection of data. I found better sql query which is faster than converted previous query bat here is problem. How to convert that sql query to hql.


Database : MYSQL
SQL query example: create sub table with inline view and afther that get other related data. Biggest problem is with searching by external attribute.
----------------------------------------------
Select *
from
(SELECT
*
FROM Item1
WHERE someexpression
ORDER BY .... LIMIT 200 //here is another problem. I can not find solution how to search
// this sub query by some attribute ( programaticaly ) which is in someItem2 table
) ItemTempTable
Inner join someItem2
-----------------------------------------------

Thanks for your idea !
simulation taux banque credit immobilier de France - Credit immobilier de France, simulation credit immobilier. Résultat mitigé pour le crédit immobilier de France.simulation taux banque credit immobilier de France