Solved : Newbie question - Working with models

[eluser]xwero[/eluser]
If you are busy wrapping your head around the queries you have to do try to write them first to see if they have the desired result before you cut them up in AR library pieces. At the moment your are doing two things at the same time which can be confusing because you don't really know where it goes wrong.
As an alternative you can write the whole statement in the db->query method like you would do in the mysql_query php function.

By grouping you only get the first record of the pSku so you will not have a complete list of the pSkus. And i don't know where that $id variable is coming from? So there are a few holes in your information which doesn't allow me to get you on the right track.