jpql query with where clause code example
Example: create query in where clasue
"Select * from s_custom_references where
article IN (SELECT ordernumber from s_articles_details where articleID = ".$articleID.") ORDER BY updated_at DESC LIMIT 5 "