mysql - Limit Group Concat for first 5 products -


i have few group concats in query, loading time slow, because think de query concats , limit end result. prijs-table big takes 8 seconds load.

this query:

select babyfoontest.idnummer, babyfoontest.typenummer, deeplink, merk,  afbeelding, group_concat(price) `prijs`, group_concat(producturl) `deeplink`, $query_string_variable total prijzen inner join babyfoontest on  prijzen.eancode = babyfoontest.ean  (shopnaam = 'amazon' , categorie = 'babby en dreumes') group eancode order total desc, abs(prijs)  limit 0, 5; 

i want show first 5 products how can limit group-concats first 5 rows? need subquery? if so, how do in example? sorry, not expert in sql.

thanks much!

kind regards, mark


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

node.js - How to abort query on demand using Neo4j drivers -