subConsulta select transformed to DQL

Question

subConsulta select transformed to DQL

Navigation

#1 by (0 votes)

0

I am using MySQL and I have this select :

Select 
TOP 15
Item 
DescriptionforSales
, (select  top 1 Retail from Pricelist where Pricelist.peachitemid = products.peachitemid ) as Retail "
From products where imagen=1 and active=1

When I convert it to dql until here I have no problem:

        $em=$this->getDoctrine()->getManager();
        $dql="SELECT p.ItemID, p.DescriptionforSales
              FROM BackendBundle:Products p";
              $query=$em->createQuery($dql);

        $query=$em->createQuery($dql);
        $query->setMaxResults(15);

The problem is when placing the subquery. Any suggestions?

Greetings

mysql sql symfony3 symfony dql

asked by juanitourquiza 26.11.2017 в 23:17

source

1 answer

How to upload a text from summernote to mysql Div error with ajax

score 0 · Accepted Answer

The entities had no relationship for this reason, the query is defined in another way, but the result is what is needed in this way:

SELECT p
FROM BackendBundle:Products p
JOIN BackendBundle:Pricelist pl
WITH p.peachitemid =  pl.peachitemid
WHERE p.hasimages =  1
Order by p.bestseller desc

Greetings