Return to Question

This seems to work perfectly and allowing me to remove all products with tier prices set to "all_group" and i seem to have my collection. Feel a bit gutted i wasted the bounty now :P

This seems to work perfectly allowing me to remove all products with tier prices set to "all_group" leaving just my collection of tier priced products within signed in users customer group. Feel a bit gutted i wasted the bounty now :P

So i have added a join to the collection:

This has allowed me to remove all "all_group" tier prices and i seem to have my collection. Feel a bit gutted i wasted the bounty now :P

So i have added a join to the collection and filtered by all tier prices set to 0 to remove the tier prices for all groups:

This seems to work perfectly and allowing me to remove all products with tier prices set to "all_group" and i seem to have my collection. Feel a bit gutted i wasted the bounty now :P

UPDATE

I receive the products with tier prices however this shows the ones for all groups also which i need to filter out. Something like:

Upon looking at the database there just seems to be a record set for each group id, so to solve this i think I can join this table to the 'catalog_product_entity_tier_price' table so that i can then filter out products that have the all_groups row set to 1 as this seems to have the data i need.

How is a collection like above filtered to achieve this?

UPDATE

The above filter works giving me the products with tier prices however this also shows the products for all groups also which i need to filter out. Something like below:

Upon looking at the database in the "catalog_product_index_price" price table there just seems to be a record set for each group id when all group is selected, so to solve this i think I can join this table to the 'catalog_product_entity_tier_price' table so that i can then filter out products that have the all_groups row set to 1 as this seems to have the data i need.