Problem with custom new additions page....

[Andrew1986]

my new additions page i created pulls out the newest items added and places them into a table so here is my problem...

if you have a product say a bag in the colours red, green, blue. if the price is the same it only pulls out the one price and places the one item in the tabel but if the colours are different prices it pulls them all out like the 2 sharpeners in the pic below


as you can see it has pulled out both versions and not just the one

if this is unclear to any one the pic shows the same product but is displaying both versions i only want it to show the version with the lowest price. Also here is my Query

strQuery = LimitSQL("tblCactuShop" & TABLE_PREFIX & "Products.P_ID, tblCactuShop" & TABLE_PREFIX & "Versions.V_Price, tblCactuShop" & TABLE_PREFIX & "Products.P_DateAdded, tblCactuShop" & TABLE_PREFIX & "Products.P_Name" & numLanguageID & ", P_StrapLine" & CInt(numLanguageID) & strSelectValues & " FROM (((tblCactuShop" & TABLE_PREFIX & "Versions INNER JOIN tblCactuShop" & TABLE_PREFIX & "Products ON tblCactuShop" & TABLE_PREFIX & "Versions.V_ProductID = tblCactuShop" & TABLE_PREFIX & "Products.P_ID) INNER JOIN tblCactuShop" & TABLE_PREFIX & "ProductCategoryLink ON tblCactuShop" & TABLE_PREFIX & "Products.P_ID = tblCactuShop" & TABLE_PREFIX & "ProductCategoryLink.PCAT_ProductID) INNER JOIN tblCactuShop" & TABLE_PREFIX & "Categories ON tblCactuShop" & TABLE_PREFIX & "ProductCategoryLink.PCAT_CategoryID = tblCactuShop" & TABLE_PREFIX & "Categories.CAT_ID) LEFT OUTER JOIN tblCactuShop" & TABLE_PREFIX & "Suppliers ON tblCactuShop" & TABLE_PREFIX & "Products.P_SupplierID = tblCactuShop" & TABLE_PREFIX & "Suppliers.SUP_ID WHERE P_Name" & CInt(numLanguageID) & " <> '' AND V_Live ='y' AND P_Live = 'y' AND V_Live ='y' AND CAT_Live = 'y' AND V_CustomerGroupID IN (0," & DB_CG_ID & ") AND P_CustomerGroupID IN (0," & DB_CG_ID & ") AND CAT_CustomerGroupID IN (0," & DB_CG_ID & ") AND (SUP_Live <> 'n' OR SUP_Live IS NULL) AND P_Featured=0 ORDER BY P_ID DESC", numNewestProductsList, true)

if any one could help me it would save alot of needed time and i would be VERY greatful

[Andrew1986]

Pleadelete This...