Erreur de requête sur la base de données
ErrorNo: 1064, Message:Erreur de base de données durant l'exécution : 'SELECT xar_articles.xar_pubtypeid, catlink0.xar_cid, catlink1.xar_cid, catlink2.xar_cid, catlink3.xar_cid, catlink4.xar_cid, catlink5.xar_cid, catlink6.xar_cid, catlink7.xar_cid, catlink8.xar_cid, catlink9.xar_cid, catlink10.xar_cid, COUNT(*)
FROM xar_articles
LEFT JOIN xar_categories_linkage as catlink0
ON catlink0.xar_iid = xar_articles.xar_aid LEFT JOIN xar_categories_linkage as catlink1 ON catlink0.xar_iid = catlink1.xar_iid AND catlink0.xar_modid = catlink1.xar_modid LEFT JOIN xar_categories_linkage as catlink2 ON catlink0.xar_iid = catlink2.xar_iid AND catlink0.xar_modid = catlink2.xar_modid LEFT JOIN xar_categories_linkage as catlink3 ON catlink0.xar_iid = catlink3.xar_iid AND catlink0.xar_modid = catlink3.xar_modid LEFT JOIN xar_categories_linkage as catlink4 ON catlink0.xar_iid = catlink4.xar_iid AND catlink0.xar_modid = catlink4.xar_modid LEFT JOIN xar_categories_linkage as catlink5 ON catlink0.xar_iid = catlink5.xar_iid AND catlink0.xar_modid = catlink5.xar_modid LEFT JOIN xar_categories_linkage as catlink6 ON catlink0.xar_iid = catlink6.xar_iid AND catlink0.xar_modid = catlink6.xar_modid LEFT JOIN xar_categories_linkage as catlink7 ON catlink0.xar_iid = catlink7.xar_iid AND catlink0.xar_modid = catlink7.xar_modid LEFT JOIN xar_categories_linkage as catlink8 ON catlink0.xar_iid = catlink8.xar_iid AND catlink0.xar_modid = catlink8.xar_modid LEFT JOIN xar_categories_linkage as catlink9 ON catlink0.xar_iid = catlink9.xar_iid AND catlink0.xar_modid = catlink9.xar_modid LEFT JOIN xar_categories_linkage as catlink10 ON catlink0.xar_iid = catlink10.xar_iid AND catlink0.xar_modid = catlink10.xar_modid
WHERE catlink0.xar_modid = 151 AND catlink0.xar_cid = 25 AND catlink1.xar_cid = 50 AND catlink2.xar_cid = 52 AND catlink3.xar_cid = 326 AND catlink4.xar_cid = 363 AND catlink5.xar_cid = 54 AND catlink6.xar_cid = 56 AND catlink7.xar_cid = 57 AND catlink8.xar_cid = 146 AND catlink9.xar_cid = 58 AND catlink10.xar_cid = 343 AND .xar_cid = 345 AND .xar_cid = 342 AND .xar_cid = 295 AND .xar_cid = 60 AND .xar_cid = 266 AND .xar_cid = 359 AND .xar_cid = 320 AND .xar_cid = 255 AND .xar_cid = 63 AND .xar_cid = 65 AND .xar_cid = 333 AND .xar_cid = 330 AND .xar_cid = 372 AND .xar_cid = 317 AND .xar_cid = 339 AND .xar_cid = 153 AND .xar_cid = 298 AND .xar_cid = 373 AND .xar_cid = 269 AND .xar_cid = 144 AND .xar_cid = 66 AND .xar_cid = 67 AND .xar_cid = 353 AND .xar_cid = 234 AND .xar_cid = 296 AND .xar_cid = 315 AND .xar_cid = 236 AND .xar_cid = 149 AND .xar_cid = 272 AND .xar_cid = 69 AND .xar_cid = 341 AND .xar_cid = 368 AND .xar_cid = 28 AND .xar_cid = 245 AND .xar_cid = 346 AND .xar_cid = 347 AND .xar_cid = 71 AND .xar_cid = 354 AND .xar_cid = 309 AND .xar_cid = 74 AND .xar_cid = 75 AND .xar_cid = 336 AND .xar_cid = 286 AND .xar_cid = 76 AND .xar_cid = 239 AND .xar_cid = 77 AND .xar_cid = 78 AND .xar_cid = 323 AND .xar_cid = 318 AND .xar_cid = 270 AND .xar_cid = 79 AND .xar_cid = 302 AND .xar_cid = 312 AND .xar_cid = 80 AND .xar_cid = 81 AND .xar_cid = 104 AND .xar_cid = 158 AND .xar_cid = 27 AND .xar_cid = 304 AND .xar_cid = 83 AND .xar_cid = 316 AND .xar_cid = 240 AND .xar_cid = 351 AND .xar_cid = 235 AND .xar_cid = 348 AND .xar_cid = 70 AND .xar_cid = 337 AND .xar_cid = 277 AND .xar_cid = 273 AND .xar_cid = 358 AND .xar_cid = 84 AND .xar_cid = 288 AND .xar_cid = 85 AND .xar_cid = 344 AND .xar_cid = 278 AND .xar_cid = 87 AND .xar_cid = 325 AND .xar_cid = 86 AND .xar_cid = 243 AND .xar_cid = 334 AND .xar_cid = 237 AND .xar_cid = 366 AND .xar_cid = 257 AND .xar_cid = 306 AND .xar_cid = 350 AND .xar_cid = 275 AND .xar_cid = 349 AND .xar_cid = 242 AND .xar_cid = 90 AND .xar_cid = 92 AND .xar_cid = 91 AND .xar_cid = 303 AND .xar_cid = 93 AND .xar_cid = 94 AND .xar_cid = 356 AND .xar_cid = 327 AND .xar_cid = 246 AND .xar_cid = 361 AND .xar_cid = 314 AND .xar_cid = 99 AND .xar_cid = 244 AND .xar_cid = 281 AND .xar_cid = 148 AND xar_articles.xar_status IN (3, 2)
GROUP BY xar_articles.xar_pubtypeid, catlink0.xar_cid, catlink1.xar_cid, catlink2.xar_cid, catlink3.xar_cid, catlink4.xar_cid, catlink5.xar_cid, catlink6.xar_cid, catlink7.xar_cid, catlink8.xar_cid, catlink9.xar_cid, catlink10.xar_cid'; Description de l'erreur : '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 '= 345 AND .xar_cid = 342 AND .xar_cid = 295 AND .xar_cid = 60 AND .xar_cid = 266' at line 5'.
- Message d'erreur
- Type : System Error
- Description courte : ErrorNo: 1064, Message:Erreur de base de données durant l'exécution : 'SELECT xar_articles.xar_pubtypeid, catlink0.xar_cid, catlink1.xar_cid, catlink2.xar_cid, catlink3.xar_cid, catlink4.xar_cid, catlink5.xar_cid, catlink6.xar_cid, catlink7.xar_cid, catlink8.xar_cid, catlink9.xar_cid, catlink10.xar_cid, COUNT(*)
FROM xar_articles
LEFT JOIN xar_categories_linkage as catlink0
ON catlink0.xar_iid = xar_articles.xar_aid LEFT JOIN xar_categories_linkage as catlink1 ON catlink0.xar_iid = catlink1.xar_iid AND catlink0.xar_modid = catlink1.xar_modid LEFT JOIN xar_categories_linkage as catlink2 ON catlink0.xar_iid = catlink2.xar_iid AND catlink0.xar_modid = catlink2.xar_modid LEFT JOIN xar_categories_linkage as catlink3 ON catlink0.xar_iid = catlink3.xar_iid AND catlink0.xar_modid = catlink3.xar_modid LEFT JOIN xar_categories_linkage as catlink4 ON catlink0.xar_iid = catlink4.xar_iid AND catlink0.xar_modid = catlink4.xar_modid LEFT JOIN xar_categories_linkage as catlink5 ON catlink0.xar_iid = catlink5.xar_iid AND catlink0.xar_modid = catlink5.xar_modid LEFT JOIN xar_categories_linkage as catlink6 ON catlink0.xar_iid = catlink6.xar_iid AND catlink0.xar_modid = catlink6.xar_modid LEFT JOIN xar_categories_linkage as catlink7 ON catlink0.xar_iid = catlink7.xar_iid AND catlink0.xar_modid = catlink7.xar_modid LEFT JOIN xar_categories_linkage as catlink8 ON catlink0.xar_iid = catlink8.xar_iid AND catlink0.xar_modid = catlink8.xar_modid LEFT JOIN xar_categories_linkage as catlink9 ON catlink0.xar_iid = catlink9.xar_iid AND catlink0.xar_modid = catlink9.xar_modid LEFT JOIN xar_categories_linkage as catlink10 ON catlink0.xar_iid = catlink10.xar_iid AND catlink0.xar_modid = catlink10.xar_modid
WHERE catlink0.xar_modid = 151 AND catlink0.xar_cid = 25 AND catlink1.xar_cid = 50 AND catlink2.xar_cid = 52 AND catlink3.xar_cid = 326 AND catlink4.xar_cid = 363 AND catlink5.xar_cid = 54 AND catlink6.xar_cid = 56 AND catlink7.xar_cid = 57 AND catlink8.xar_cid = 146 AND catlink9.xar_cid = 58 AND catlink10.xar_cid = 343 AND .xar_cid = 345 AND .xar_cid = 342 AND .xar_cid = 295 AND .xar_cid = 60 AND .xar_cid = 266 AND .xar_cid = 359 AND .xar_cid = 320 AND .xar_cid = 255 AND .xar_cid = 63 AND .xar_cid = 65 AND .xar_cid = 333 AND .xar_cid = 330 AND .xar_cid = 372 AND .xar_cid = 317 AND .xar_cid = 339 AND .xar_cid = 153 AND .xar_cid = 298 AND .xar_cid = 373 AND .xar_cid = 269 AND .xar_cid = 144 AND .xar_cid = 66 AND .xar_cid = 67 AND .xar_cid = 353 AND .xar_cid = 234 AND .xar_cid = 296 AND .xar_cid = 315 AND .xar_cid = 236 AND .xar_cid = 149 AND .xar_cid = 272 AND .xar_cid = 69 AND .xar_cid = 341 AND .xar_cid = 368 AND .xar_cid = 28 AND .xar_cid = 245 AND .xar_cid = 346 AND .xar_cid = 347 AND .xar_cid = 71 AND .xar_cid = 354 AND .xar_cid = 309 AND .xar_cid = 74 AND .xar_cid = 75 AND .xar_cid = 336 AND .xar_cid = 286 AND .xar_cid = 76 AND .xar_cid = 239 AND .xar_cid = 77 AND .xar_cid = 78 AND .xar_cid = 323 AND .xar_cid = 318 AND .xar_cid = 270 AND .xar_cid = 79 AND .xar_cid = 302 AND .xar_cid = 312 AND .xar_cid = 80 AND .xar_cid = 81 AND .xar_cid = 104 AND .xar_cid = 158 AND .xar_cid = 27 AND .xar_cid = 304 AND .xar_cid = 83 AND .xar_cid = 316 AND .xar_cid = 240 AND .xar_cid = 351 AND .xar_cid = 235 AND .xar_cid = 348 AND .xar_cid = 70 AND .xar_cid = 337 AND .xar_cid = 277 AND .xar_cid = 273 AND .xar_cid = 358 AND .xar_cid = 84 AND .xar_cid = 288 AND .xar_cid = 85 AND .xar_cid = 344 AND .xar_cid = 278 AND .xar_cid = 87 AND .xar_cid = 325 AND .xar_cid = 86 AND .xar_cid = 243 AND .xar_cid = 334 AND .xar_cid = 237 AND .xar_cid = 366 AND .xar_cid = 257 AND .xar_cid = 306 AND .xar_cid = 350 AND .xar_cid = 275 AND .xar_cid = 349 AND .xar_cid = 242 AND .xar_cid = 90 AND .xar_cid = 92 AND .xar_cid = 91 AND .xar_cid = 303 AND .xar_cid = 93 AND .xar_cid = 94 AND .xar_cid = 356 AND .xar_cid = 327 AND .xar_cid = 246 AND .xar_cid = 361 AND .xar_cid = 314 AND .xar_cid = 99 AND .xar_cid = 244 AND .xar_cid = 281 AND .xar_cid = 148 AND xar_articles.xar_status IN (3, 2)
GROUP BY xar_articles.xar_pubtypeid, catlink0.xar_cid, catlink1.xar_cid, catlink2.xar_cid, catlink3.xar_cid, catlink4.xar_cid, catlink5.xar_cid, catlink6.xar_cid, catlink7.xar_cid, catlink8.xar_cid, catlink9.xar_cid, catlink10.xar_cid'; Description de l'erreur : '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 '= 345 AND .xar_cid = 342 AND .xar_cid = 295 AND .xar_cid = 60 AND .xar_cid = 266' at line 5'.
- Description longue : Une requête sur la base de données n'a pu être éxécutée, soit car la requête n'a pu être comprise soit car elle a renvoyé un résultat inattendu.
Réessayer
Fermer