Home / GETZNER / BROCADE / GETZNER SUPER WAGAMBARI GOLD XL BROCADE/BAZIN / GWB110 - Getzner Wagambari Brocade White < GO BACK
zoom +
GWB110 - Getzner Wagambari Brocade White
Unable to run pageCountColumn 'ParentProductID' in where clause is ambiguousSELECT COUNT(*) AS recCount FROM (SELECT DISTINCT p.*,c.CatName FROM products p LEFT JOIN products parent ON (p.ParentProductID=parent.id) LEFT JOIN categories c ON (p.CategoryID1=c.id) LEFT JOIN products_categories pc ON (p.id=pc.ProductID) WHERE 1 AND p.`Deleted`=0 AND ParentProductID=11178 AND p.Visible=1 AND ItemColor<>'') as t