SELECT tblCategories.cid, tblCategories.catpar, tblManufacturer.mfname, tblProducts.pid, tblProducts.pname, tblProducts.pmfr, tblProducts.ptype, tblProducts.pcode, tblProducts.pstyle, tblProducts.padvanced, tblProducts.pcat, tblProducts.pdesc, tblProducts.wcontent, tblProducts.wcaret, tblProducts.wcared, tblProducts.pltd, tblProducts.pweight, tblProducts.wtension, tblProducts.wtenss, tblProducts.wtensr, tblProducts.wcrochhk, tblProducts.ppack, tblProducts.prrp, tblProducts.pprice, tblProducts.plength, tblProducts.plenMt, tblProducts.print, tblProducts.pcolour, tblProducts.pagemin, tblProducts.pagemax, tblProducts.psizemin, tblProducts.psizemax, tblProducts.pheight, tblProducts.pbundle, tblProducts.pimage, tblProducts.pavail, tblProducts.pfeat, tblWoolColours.clavail, tblProducts.pnew, tblProducts.padd_date, tblProducts.pgmt, tblProducts.pwool, tblProducts.wneedle, tblProducts.wneedle2, tblCategories.catdesc, tblCategories_1.catname AS parname, tblCategories_1.catcol AS clr, Count(tblWoolColours.clid) AS shcount FROM ((tblCategories INNER JOIN (tblManufacturer RIGHT JOIN tblProducts ON tblManufacturer.mfid = tblProducts.pmfr) ON tblCategories.cid = tblProducts.pcat) INNER JOIN tblCategories AS tblCategories_1 ON tblCategories.catpar = tblCategories_1.cid) LEFT JOIN tblWoolColours ON tblProducts.pid = tblWoolColours.clwool GROUP BY tblCategories.cid, tblCategories.catpar, tblManufacturer.mfname, tblProducts.pid, tblProducts.pname, tblProducts.pmfr, tblProducts.ptype, tblProducts.pcode, tblProducts.pstyle, tblProducts.padvanced, tblProducts.pcat, tblProducts.pdesc, tblProducts.wcontent, tblProducts.wcaret, tblProducts.wcared, tblProducts.pweight, tblProducts.wtension, tblProducts.wtenss, tblProducts.wtensr, tblProducts.wcrochhk, tblProducts.ppack, tblProducts.prrp, tblProducts.pprice, tblProducts.pltd, tblProducts.plength, tblProducts.plenMt, tblProducts.print, tblProducts.pcolour, tblProducts.pagemin, tblProducts.pagemax, tblProducts.psizemin, tblProducts.psizemax, tblProducts.pheight, tblProducts.pbundle, tblProducts.pimage, tblProducts.pavail, tblProducts.pfeat, tblProducts.pnew, tblProducts.padd_date, tblProducts.pgmt, tblProducts.pwool, tblProducts.wneedle, tblProducts.wneedle2, tblCategories.catdesc, tblWoolColours.clavail, tblCategories_1.catname, tblCategories_1.catcol, tblCategories.catpar HAVING (((tblProducts.pavail)=True)) and clavail = true and tblCategories.cid =24 ORDER BY pnew, pname : - A Woolly Tail Products
 

Jarol

 

Sorry, there are currently no products in this section that
match your request.


Depending on your screen type and settings, actual colours may vary.

Close this box close window
Your Shopping Basket (0)
 

Your basket is empty.