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_itemtype = 8 AND catlink0.xar_cid = 25 AND catlink1.xar_cid = 456 AND catlink2.xar_cid = 312 AND catlink3.xar_cid = 439 AND catlink4.xar_cid = 450 AND catlink5.xar_cid = 50 AND catlink6.xar_cid = 52 AND catlink7.xar_cid = 461 AND catlink8.xar_cid = 326 AND catlink9.xar_cid = 423 AND catlink10.xar_cid = 363 AND .xar_cid = 54 AND .xar_cid = 373 AND .xar_cid = 56 AND .xar_cid = 57 AND .xar_cid = 146 AND .xar_cid = 58 AND .xar_cid = 404 AND .xar_cid = 343 AND .xar_cid = 345 AND .xar_cid = 342 AND .xar_cid = 295 AND .xar_cid = 413 AND .xar_cid = 418 AND .xar_cid = 60 AND .xar_cid = 266 AND .xar_cid = 359 AND .xar_cid = 320 AND .xar_cid = 379 AND .xar_cid = 255 AND .xar_cid = 421 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 = 387 AND .xar_cid = 298 AND .xar_cid = 269 AND .xar_cid = 144 AND .xar_cid = 460 AND .xar_cid = 66 AND .xar_cid = 67 AND .xar_cid = 353 AND .xar_cid = 385 AND .xar_cid = 389 AND .xar_cid = 444 AND .xar_cid = 386 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 = 425 AND .xar_cid = 376 AND .xar_cid = 384 AND .xar_cid = 368 AND .xar_cid = 28 AND .xar_cid = 245 AND .xar_cid = 346 AND .xar_cid = 453 AND .xar_cid = 464 AND .xar_cid = 347 AND .xar_cid = 454 AND .xar_cid = 71 AND .xar_cid = 309 AND .xar_cid = 74 AND .xar_cid = 75 AND .xar_cid = 336 AND .xar_cid = 382 AND .xar_cid = 286 AND .xar_cid = 393 AND .xar_cid = 378 AND .xar_cid = 76 AND .xar_cid = 239 AND .xar_cid = 463 AND .xar_cid = 424 AND .xar_cid = 462 AND .xar_cid = 77 AND .xar_cid = 422 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 = 472 AND .xar_cid = 420 AND .xar_cid = 417 AND .xar_cid = 80 AND .xar_cid = 81 AND .xar_cid = 104 AND .xar_cid = 414 AND .xar_cid = 158 AND .xar_cid = 27 AND .xar_cid = 457 AND .xar_cid = 83 AND .xar_cid = 316 AND .xar_cid = 402 AND .xar_cid = 240 AND .xar_cid = 351 AND .xar_cid = 235 AND .xar_cid = 380 AND .xar_cid = 348 AND .xar_cid = 476 AND .xar_cid = 397 AND .xar_cid = 70 AND .xar_cid = 433 AND .xar_cid = 337 AND .xar_cid = 277 AND .xar_cid = 273 AND .xar_cid = 390 AND .xar_cid = 358 AND .xar_cid = 84 AND .xar_cid = 288 AND .xar_cid = 85 AND .xar_cid = 383 AND .xar_cid = 473 AND .xar_cid = 344 AND .xar_cid = 466 AND .xar_cid = 468 AND .xar_cid = 436 AND .xar_cid = 375 AND .xar_cid = 278 AND .xar_cid = 87 AND .xar_cid = 415 AND .xar_cid = 325 AND .xar_cid = 86 AND .xar_cid = 416 AND .xar_cid = 441 AND .xar_cid = 334 AND .xar_cid = 465 AND .xar_cid = 237 AND .xar_cid = 429 AND .xar_cid = 475 AND .xar_cid = 243 AND .xar_cid = 366 AND .xar_cid = 257 AND .xar_cid = 452 AND .xar_cid = 306 AND .xar_cid = 350 AND .xar_cid = 275 AND .xar_cid = 391 AND .xar_cid = 349 AND .xar_cid = 419 AND .xar_cid = 242 AND .xar_cid = 388 AND .xar_cid = 90 AND .xar_cid = 92 AND .xar_cid = 91 AND .xar_cid = 469 AND .xar_cid = 303 AND .xar_cid = 93 AND .xar_cid = 94 AND .xar_cid = 356 AND .xar_cid = 430 AND .xar_cid = 327 AND .xar_cid = 246 AND .xar_cid = 361 AND .xar_cid = 411 AND .xar_cid = 396 AND .xar_cid = 314 AND .xar_cid = 99 AND .xar_cid = 467 AND .xar_cid = 244 AND .xar_cid = 281 AND .xar_cid = 427 AND .xar_cid = 426 AND .xar_cid = 408 AND .xar_cid = 148 AND xar_articles.xar_pubtypeid = 8 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 '= 54 AND .xar_cid = 373 AND .xar_cid = 56 AND .xar_cid = 57 AND .xar_cid = 146 A' 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_itemtype = 8 AND catlink0.xar_cid = 25 AND catlink1.xar_cid = 456 AND catlink2.xar_cid = 312 AND catlink3.xar_cid = 439 AND catlink4.xar_cid = 450 AND catlink5.xar_cid = 50 AND catlink6.xar_cid = 52 AND catlink7.xar_cid = 461 AND catlink8.xar_cid = 326 AND catlink9.xar_cid = 423 AND catlink10.xar_cid = 363 AND .xar_cid = 54 AND .xar_cid = 373 AND .xar_cid = 56 AND .xar_cid = 57 AND .xar_cid = 146 AND .xar_cid = 58 AND .xar_cid = 404 AND .xar_cid = 343 AND .xar_cid = 345 AND .xar_cid = 342 AND .xar_cid = 295 AND .xar_cid = 413 AND .xar_cid = 418 AND .xar_cid = 60 AND .xar_cid = 266 AND .xar_cid = 359 AND .xar_cid = 320 AND .xar_cid = 379 AND .xar_cid = 255 AND .xar_cid = 421 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 = 387 AND .xar_cid = 298 AND .xar_cid = 269 AND .xar_cid = 144 AND .xar_cid = 460 AND .xar_cid = 66 AND .xar_cid = 67 AND .xar_cid = 353 AND .xar_cid = 385 AND .xar_cid = 389 AND .xar_cid = 444 AND .xar_cid = 386 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 = 425 AND .xar_cid = 376 AND .xar_cid = 384 AND .xar_cid = 368 AND .xar_cid = 28 AND .xar_cid = 245 AND .xar_cid = 346 AND .xar_cid = 453 AND .xar_cid = 464 AND .xar_cid = 347 AND .xar_cid = 454 AND .xar_cid = 71 AND .xar_cid = 309 AND .xar_cid = 74 AND .xar_cid = 75 AND .xar_cid = 336 AND .xar_cid = 382 AND .xar_cid = 286 AND .xar_cid = 393 AND .xar_cid = 378 AND .xar_cid = 76 AND .xar_cid = 239 AND .xar_cid = 463 AND .xar_cid = 424 AND .xar_cid = 462 AND .xar_cid = 77 AND .xar_cid = 422 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 = 472 AND .xar_cid = 420 AND .xar_cid = 417 AND .xar_cid = 80 AND .xar_cid = 81 AND .xar_cid = 104 AND .xar_cid = 414 AND .xar_cid = 158 AND .xar_cid = 27 AND .xar_cid = 457 AND .xar_cid = 83 AND .xar_cid = 316 AND .xar_cid = 402 AND .xar_cid = 240 AND .xar_cid = 351 AND .xar_cid = 235 AND .xar_cid = 380 AND .xar_cid = 348 AND .xar_cid = 476 AND .xar_cid = 397 AND .xar_cid = 70 AND .xar_cid = 433 AND .xar_cid = 337 AND .xar_cid = 277 AND .xar_cid = 273 AND .xar_cid = 390 AND .xar_cid = 358 AND .xar_cid = 84 AND .xar_cid = 288 AND .xar_cid = 85 AND .xar_cid = 383 AND .xar_cid = 473 AND .xar_cid = 344 AND .xar_cid = 466 AND .xar_cid = 468 AND .xar_cid = 436 AND .xar_cid = 375 AND .xar_cid = 278 AND .xar_cid = 87 AND .xar_cid = 415 AND .xar_cid = 325 AND .xar_cid = 86 AND .xar_cid = 416 AND .xar_cid = 441 AND .xar_cid = 334 AND .xar_cid = 465 AND .xar_cid = 237 AND .xar_cid = 429 AND .xar_cid = 475 AND .xar_cid = 243 AND .xar_cid = 366 AND .xar_cid = 257 AND .xar_cid = 452 AND .xar_cid = 306 AND .xar_cid = 350 AND .xar_cid = 275 AND .xar_cid = 391 AND .xar_cid = 349 AND .xar_cid = 419 AND .xar_cid = 242 AND .xar_cid = 388 AND .xar_cid = 90 AND .xar_cid = 92 AND .xar_cid = 91 AND .xar_cid = 469 AND .xar_cid = 303 AND .xar_cid = 93 AND .xar_cid = 94 AND .xar_cid = 356 AND .xar_cid = 430 AND .xar_cid = 327 AND .xar_cid = 246 AND .xar_cid = 361 AND .xar_cid = 411 AND .xar_cid = 396 AND .xar_cid = 314 AND .xar_cid = 99 AND .xar_cid = 467 AND .xar_cid = 244 AND .xar_cid = 281 AND .xar_cid = 427 AND .xar_cid = 426 AND .xar_cid = 408 AND .xar_cid = 148 AND xar_articles.xar_pubtypeid = 8 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 '= 54 AND .xar_cid = 373 AND .xar_cid = 56 AND .xar_cid = 57 AND .xar_cid = 146 A' 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