limit - mysql query

[felito]

I would like to know how can i limit the output by the number of id_offers and not the number of rows. For example

 

 

  SELECT  A.id_offer, T.tags  
        		FROM offer A
        		INNER JOIN offer_has_tags Z
                ON A.id_offer = Z.offer_id_offer
                
          		INNER JOIN tags T
                ON Z.tags_id_tags = T.id_tags
                
        		WHERE state = 0 
        		ORDER BY date
        		DESC LIMIT 0, 10

 

output:

      id_offer 	tags
        77 	     xx 
        76 	     xx 
        76 	     xx 
        75 	     xx 
        75 	     xx 
        74 	     xx 
        74 	     xx
        73 	     xx
        73 	     xx
        72 	     xx

[gin]

Use a LEFT JOIN instead of an INNER JOIN?

[felito]

this solve my problem

 

SELECT  A.id_offer, T.tags  
FROM 
  ( SELECT *
    FROM offer
    WHERE state = 0
    ORDER BY date DESC
    LIMIT 10
  ) A
JOIN offer_has_tags Z
  ON A.id_offer = Z.offer_id_offer
JOIN tags T
  ON Z.tags_id_tags = T.id_tags