fetchAll error : SQL Relay -> fetchAll error : Server message: Incorrect syntax near ')'. severity(0) number(102) state(1) line(1) Server Name:PROODY Procedure Name: | bdd :: default | query :: select * from (select ROW_NUMBER() OVER( ORDER BY J0.cltvente asc, T0.modele asc) _RowNum,COUNT(*) OVER() AS _Count,T0.enseigne col_0, T0.saison col_1, T0.modele col_2, T0.coloris col_3 FROM Options T0 JOIN OptPays J0 ON T0.enseigne = J0.enseigne and T0.saison = J0.saison and T0.modele = J0.modele and T0.coloris = J0.coloris JOIN TarifLiv J1 ON T0.enseigne = J1.enseigne and T0.modele = J1.modele and T0.saison = J1.saison and T0.coloris = J1.coloris JOIN Modele J2 ON T0.enseigne = J2.enseigne and T0.saison = J2.saison and T0.modele = J2.modele JOIN Modtrad J3 ON T0.enseigne = J3.enseigne and T0.saison = J3.saison and T0.modele = J3.modele, Libtra T1 WHERE J0.pays = 'UK' AND T0.saison IN ('1','7','8') AND T1.codelibelle = 'COLORIS' AND T1.enseigne = '0' AND T1.langue = J0.pays AND T1.valeur = J0.coloris AND J2.famille <> '99' AND exists (select * from coloris where coloris.coloris = J0.coloris and coloris.colorisgenerique = '063') AND J3.langue = J0.pays AND J1.pays = J0.pays AND J1.paysliv = 'UK' AND J1.devise = 'GBP' AND exists(select * from Article JJ0,Stock JJ1 where JJ0.enseigne=J2.enseigne and JJ0.saison=T0.saison and jj0.modele=T0.modele and jj0.coloris=T0.coloris and jj0.numinterneref=JJ1.numinterneref and JJ0.maj <> 'S' and JJ0.enseigne = JJ1.enseigne and JJ1.etatarticle <> '3' and ((JJ1.stockdispo > 0) or (JJ1.stockdispo = 0 and jj1.datedispoprevu > Convert(datetime,Convert(varchar,'24/10/2014 22:00',103),103))) and (( JJ0.taille IN (select TradProduit.taille from taille_trad_pays TradGrille, taille_trad_pays TradProduit where ()and TradGrille.pays='UK' and TradProduit.codfamilletaille=J2.Cod_famille_taille and TradProduit.libelle=TradGrille.libelle and TradProduit.pays='UK'))) )) limit where _RowNum BETWEEN 1 AND 32 | bdd :: default | query :: select * from (select ROW_NUMBER() OVER( ORDER BY J0.cltvente asc, T0.modele asc) _RowNum,COUNT(*) OVER() AS _Count,T0.enseigne col_0, T0.saison col_1, T0.modele col_2, T0.coloris col_3 FROM Options T0 JOIN OptPays J0 ON T0.enseigne = J0.enseigne and T0.saison = J0.saison and T0.modele = J0.modele and T0.coloris = J0.coloris JOIN TarifLiv J1 ON T0.enseigne = J1.enseigne and T0.modele = J1.modele and T0.saison = J1.saison and T0.coloris = J1.coloris JOIN Modele J2 ON T0.enseigne = J2.enseigne and T0.saison = J2.saison and T0.modele = J2.modele JOIN Modtrad J3 ON T0.enseigne = J3.enseigne and T0.saison = J3.saison and T0.modele = J3.modele, Libtra T1 WHERE J0.pays = 'UK' AND T0.saison IN ('1','7','8') AND T1.codelibelle = 'COLORIS' AND T1.enseigne = '0' AND T1.langue = J0.pays AND T1.valeur = J0.coloris AND J2.famille <> '99' AND exists (select * from coloris where coloris.coloris = J0.coloris and coloris.colorisgenerique = '063') AND J3.langue = J0.pays AND J1.pays = J0.pays AND J1.paysliv = 'UK' AND J1.devise = 'GBP' AND exists(select * from Article JJ0,Stock JJ1 where JJ0.enseigne=J2.enseigne and JJ0.saison=T0.saison and jj0.modele=T0.modele and jj0.coloris=T0.coloris and jj0.numinterneref=JJ1.numinterneref and JJ0.maj <> 'S' and JJ0.enseigne = JJ1.enseigne and JJ1.etatarticle <> '3' and ((JJ1.stockdispo > 0) or (JJ1.stockdispo = 0 and jj1.datedispoprevu > Convert(datetime,Convert(varchar,'24/10/2014 22:00',103),103))) and (( JJ0.taille IN (select TradProduit.taille from taille_trad_pays TradGrille, taille_trad_pays TradProduit where ()and TradGrille.pays='UK' and TradProduit.codfamilletaille=J2.Cod_famille_taille and TradProduit.libelle=TradGrille.libelle and TradProduit.pays='UK'))) )) limit where _RowNum BETWEEN 1 AND 32 Collection Wear Yellow/Orange - Promod

Advanced Search

No results matched your search
You can also launch a new search (decreasing the number of criteria gives better results)

Advanced search
*Click on the links to check the conditions
**Offer valid from 23/10/2014 to 03/11/2014 exclusively online on Promod.co.uk when you buy a black article and a second article. The reduction will be applied on the cheaper one. Valid on the womens and mens collection. Excluded from this offer are price-reduced items and low priced labelled items. This offer cannot be combined with any other offer. Items defined as black have to contain a reference number ending end with one of the following numbers: 001, 002, 003, 004, 007, 010, 014, 015, 019, 080, 082, 084, 101, 103, 104, 110, 114, 201, 202, 203, 204, 207, 210, 214, 215, 219, 284, 301, 304, 309, 311, 314, 318, 320, 324, 501, 503, 507, 510, 514, 582, 601, 701, 702, 799, 801, 802, 803, 804, 814, 819, 880, 882, 884, 899, 902, 910, 926, 962, 986, 987, 996; e.g. 1-1-23-01-25-001.