Please note this is a demonstration storefront for Nextwave Commerce   -  No payments will be taken and no orders dispatched
Sequoia
  • New
  • Clothing
    • shop by
      What's New
      Dresses
      Tops
      Pants
      Active wear
      Jackets
      Jeans
      Knitwear
      Shorts
      Skirts
      Outfits
      Bundles
      designers
      1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nwcdemo2_nwc3859349.p2c.categories_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

      select DISTINCT m.manufacturers_name, p.manufacturers_id, p2c.categories_id from manufacturers m, products p, products_to_categories p2c where m.manufacturers_id = p.manufacturers_id and p.products_id in('336','337','338','339','340','341','342','343','346','347','349','350','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','517','518','519','520','522','523','524','525','526','567','568','569','570','572','573','574','575','576','579','580','581','585','586','587','589','590','591','592','593','594','597','598','599','600','601','602','603','604','606','796','825','607','609','610','611','612','613','614','615','617','619','620','621','622','623','624','626','627','628','629','630','631','632','633','634','636','637','638','639','640','641','642','643','644','645','646','647','648','649','651','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','679','680','681','682','683','684','685','686','688','689','690','691','692','693','694','695','696','697','698','700','702','703','704','705','706','707','710','711','713','714','715','716','717','718','719','720','721','722','723','827','724','725','726','727','728','730','731','732','733','736','737','738','739','740','741','742','743','744','745','746','747','749','750','751','753','754','756','757','758','759','760','761','762','763','764','765','766','767','768','769','771','773','774','775','777','778','779','780','784','785','788','791','792','794','795','814','818','831','832','833','834') and p2c.products_id = p.products_id group by m.manufacturers_id ORDER BY RAND() LIMIT 8

      [TEP STOP]