Search Results
Column 'StoreStyleNum' in field list is ambiguous
ERRORSQL: /* s8 */ SELECT p.ProdNum, MATCH (a.proddesc,a.prodshortdesc,a.prodnum, a.prodkeywords) AGAINST ('shoes*') as relevance, p.CurrencyType, p.custPhotoVersion, a.ProdId, p.ProdPrice, p.ProdImage, p.ManufProd, p.manufSeqId, p.ManufColId, c.LinkPrefix, a.ProdShortDesc, a.ProdDesc, b.CatId, c.manufId, c.releaseDate, c.productType, c.colNameForTitles, p.prodURLOverride,c.masterColId, StoreStyleNum FROM vprod_search30 AS a LEFT JOIN efashion_products AS p ON a.ProdId=p.ProdId LEFT JOIN efashion_prod_cat AS b ON a.ProdId=b.ProdId LEFT JOIN efashion_manuf_cols AS c ON c.ManufColId=p.ManufColId left join efashion_products cp on p.ManufSeqId=cp.ManufSeqId left join efashion_inventory i on i.prodId=cp.ProdId and i.efid in(441,527,106,514,545,206,528,372,108,548,355,353,536,501,646,606,485,213,609) left join efashion_inv_manuf_dedicated mi on mi.seq=p.ManufSeqId WHERE a.EfId=103 and p.EfId=103 and p.ProductStatus IN (1) and cp.ProductStatus IN (1) and p.ProdEcommAvail=1 and cp.ProdEcommAvail=1 and p.prodPrice>0 and cp.ProdPrice>0 and p.prodid IS NOT NULL AND (i.inventoryId is not null or (mi.inventoryId is not null and (mi.arrivalDate<='2024-03-18' or mi.arrivalDate IS NULL))) and MATCH (a.proddesc,a.prodshortdesc,a.prodnum, a.prodkeywords) AGAINST ('shoes*') and (i.size in('6') or mi.size in('6')) group by a.prodid order by relevance desc Limit 0,25