Support the ongoing development of Laravel.io →
duderion
posted 10 years ago
Database Eloquent
Last updated 2 years ago.
0
duderion
replied 10 years ago
Solution

i saved it on my own

SELECT b.Name as bpName, p., MAX(p.created_at), pr. FROM browsenodes b, browsenode_product bp, products pr, positions p WHERE b.id = bp.browsenode_id AND pr.id = bp.product_id AND p.ASIN = pr.ASIN AND b.Name = "'.$topic.'" GROUP BY pr.ASIN ORDER BY position

Last updated 2 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

duderion duderion Joined 8 Apr 2014

Moderators

We'd like to thank these amazing companies for supporting us

Eventy
Fathom
Forge
Envoyer
Beyond Code
BairesDev
Dotcom-monitor
N-iX

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X (Twitter) GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2024 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise