Guest User

Untitled

a guest
May 23rd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. $query = $this->getEntityManager()
  2. ->createQuery('SELECT adsLink
  3. FROM CatalogBundle:AdsLink adsLink
  4. JOIN CatalogBundle:Product product
  5. WHERE product.user = :user')
  6. ->setParameter('user', $user);
  7.  
  8. return $query->getResult();
  9.  
  10. SELECT product_advertising_link.*, products.name, products.user_id
  11. FROM product_advertising_link
  12. JOIN products ON product_advertising_link.product_id = products.id
  13. WHERE products.user_id = 1
Add Comment
Please, Sign In to add comment