Fichier de script : /compte/token_liste.php Requête : SELECT
TH.tgid,
TH.ttid,
TH.match_id,
TH.n_journee1,
TH.n_journee2,
TH.datecrea,
TH.montant,
TH.cid,
TH.mid,
TH.commentaire,
TT.tglbl,
S.sid,
S.slbl,
C.clbl,
M.mlbl,
P1.lbl as nom1,
P2.lbl as nom2,
MCP.num_round,
CP.num_image,
0 as nb_record
FROM token_histo TH
INNER JOIN
token_type_gain TT ON TT.tgid = TH.tgid
LEFT OUTER JOIN
concours C ON C.cid = TH.cid
LEFT OUTER JOIN
sport S ON S.sid = C.sid
LEFT OUTER JOIN
manche M ON M.mid = TH.mid
LEFT OUTER JOIN
concours_partenaire CP ON CP.pid = 3 AND
CP.cid = TH.cid
LEFT OUTER JOIN
manche_concours_partenaire MCP ON MCP.cpid = CP.cpid AND
MCP.mid = TH.mid
LEFT OUTER JOIN
manche_match MM ON MM.id = TH.match_id
LEFT OUTER JOIN
participant P1 ON P1.partid = MM.partid1
LEFT OUTER JOIN
participant P2 ON P2.partid = MM.partid2
WHERE TH.uid = AND
TH.ttid = 0 ORDER BY TH.datecrea DESC, TH.tgid, TH.match_id
LIMIT 0, 30 Error#1 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
TH.ttid = 0 ORDER BY TH.datecrea DESC, TH.tgid, TH.match_id
' at line 43
Erreur :
Fichier de script : /compte/token_liste.php Requête : SELECT YEAR(datecrea) as datey, MONTH(datecrea) as datem, uid, sum(montant) as nb
FROM token_histo
WHERE uid = AND
ttid = 1 AND
montant >0
GROUP BY uid, YEAR(datecrea), MONTH(datecrea) Error#1 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
ttid = 1 AND
montant >0
G' at line 3
Erreur :
Fichier de script : /compte/token_liste.php Requête : SELECT YEAR(datecrea) as datey, MONTH(datecrea) as datem, uid, sum(montant) as nb
FROM token_histo
WHERE uid = AND
ttid = 1 AND
montant <0
GROUP BY uid, YEAR(datecrea), MONTH(datecrea) Error#1 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
ttid = 1 AND
montant <0
G' at line 3
Erreur :
Fichier de script : /compte/token_liste.php Requête : SELECT YEAR(datecrea) as datey, MONTH(datecrea) as datem, uid, sum(montant) as nb
FROM token_histo
WHERE uid = AND
ttid = 0 AND
montant >0
GROUP BY uid, YEAR(datecrea), MONTH(datecrea) Error#1 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
ttid = 0 AND
montant >0
G' at line 3
Erreur :
Fichier de script : /compte/token_liste.php Requête : SELECT YEAR(datecrea) as datey, MONTH(datecrea) as datem, uid, sum(montant) as nb
FROM token_histo
WHERE uid = AND
ttid = 0 AND
montant <0
GROUP BY uid, YEAR(datecrea), MONTH(datecrea) Error#1 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
ttid = 0 AND
montant <0
G' at line 3
Pro-foot - Historique