Warning: SQLite3::query(): Unable to prepare statement: 1, Expression tree is too large (maximum depth 1000) in /home/users/1/elnet/web/new_ra_men/inc/common-pc.php on line 858
Error:テーブルからのデータ取得に失敗しました!!select AVG(rank),count(shop_id),shop_id from data WHERE men_id != 1 and area_big = 2 and shop_id != 16 and area_big = 2 and shop_id != 17 and area_big = 2 and shop_id != 22 and area_big = 2 and shop_id != 24 and area_big = 2 and shop_id != 25 and area_big = 2 and shop_id != 26 and area_big = 2 and shop_id != 28 and area_big = 2 and shop_id != 33 and area_big = 2 and shop_id != 38 and area_big = 2 and shop_id != 40 and area_big = 2 and shop_id != 46 and area_big = 2 and shop_id != 50 and area_big = 2 and shop_id != 53 and area_big = 2 and shop_id != 59 and area_big = 2 and shop_id != 69 and area_big = 2 and shop_id != 70 and area_big = 2 and shop_id != 73 and area_big = 2 and shop_id != 74 and area_big = 2 and shop_id != 75 and area_big = 2 and shop_id != 76 and area_big = 2 and shop_id != 77 and area_big = 2 and shop_id != 78 and area_big = 2 and shop_id != 79 and area_big = 2 and shop_id != 80 and area_big = 2 and shop_id != 81 and area_big = 2 and shop_id != 82 and area_big = 2 and shop_id != 83 and area_big = 2 and shop_id != 84 and area_big = 2 and shop_id != 85 and area_big = 2 and shop_id != 86 and area_big = 2 and shop_id != 87 and area_big = 2 and shop_id != 88 and area_big = 2 and shop_id != 90 and area_big = 2 and shop_id != 95 and area_big = 2 and shop_id != 101 and area_big = 2 and shop_id != 102 and area_big = 2 and shop_id != 103 and area_big = 2 and shop_id != 108 and area_big = 2 and shop_id != 109 and area_big = 2 and shop_id != 111 and area_big = 2 and shop_id != 118 and area_big = 2 and shop_id != 119 and area_big = 2 and shop_id != 129 and area_big = 2 and shop_id != 133 and area_big = 2 and shop_id != 138 and area_big = 2 and shop_id != 139 and area_big = 2 and shop_id != 142 and area_big = 2 and shop_id != 143 and area_big = 2 and shop_id != 148 and area_big = 2 and shop_id != 149 and area_big = 2 and shop_id != 151 and area_big = 2 and shop_id != 152 and area_big = 2 and shop_id != 155 and area_big = 2 and shop_id != 159 and area_big = 2 and shop_id != 163 and area_big = 2 and shop_id != 172 and area_big = 2 and shop_id != 173 and area_big = 2 and shop_id != 179 and area_big = 2 and shop_id != 180 and area_big = 2 and shop_id != 182 and area_big = 2 and shop_id != 188 and area_big = 2 and shop_id != 189 and area_big = 2 and shop_id != 190 and area_big = 2 and shop_id != 191 and area_big = 2 and shop_id != 192 and area_big = 2 and shop_id != 194 and area_big = 2 and shop_id != 195 and area_big = 2 and shop_id != 196 and area_big = 2 and shop_id != 197 and area_big = 2 and shop_id != 199 and area_big = 2 and shop_id != 200 and area_big = 2 and shop_id != 201 and area_big = 2 and shop_id != 203 and area_big = 2 and shop_id != 204 and area_big = 2 and shop_id != 205 and area_big = 2 and shop_id != 206 and area_big = 2 and shop_id != 210 and area_big = 2 and shop_id != 211 and area_big = 2 and shop_id != 212 and area_big = 2 and shop_id != 213 and area_big = 2 and shop_id != 214 and area_big = 2 and shop_id != 216 and area_big = 2 and shop_id != 217 and area_big = 2 and shop_id != 218 and area_big = 2 and shop_id != 219 and area_big = 2 and shop_id != 220 and area_big = 2 and shop_id != 221 and area_big = 2 and shop_id != 222 and area_big = 2 and shop_id != 223 and area_big = 2 and shop_id != 224 and area_big = 2 and shop_id != 225 and area_big = 2 and shop_id != 228 and area_big = 2 and shop_id != 230 and area_big = 2 and shop_id != 232 and area_big = 2 and shop_id != 234 and area_big = 2 and shop_id != 238 and area_big = 2 and shop_id != 239 and area_big = 2 and shop_id != 242 and area_big = 2 and shop_id != 243 and area_big = 2 and shop_id != 245 and area_big = 2 and shop_id != 246 and area_big = 2 and shop_id != 247 and area_big = 2 and shop_id != 248 and area_big = 2 and shop_id != 249 and area_big = 2 and shop_id != 250 and area_big = 2 and shop_id != 255 and area_big = 2 and shop_id != 256 and area_big = 2 and shop_id != 258 and area_big = 2 and shop_id != 259 and area_big = 2 and shop_id != 260 and area_big = 2 and shop_id != 262 and area_big = 2 and shop_id != 263 and area_big = 2 and shop_id != 264 and area_big = 2 and shop_id != 265 and area_big = 2 and shop_id != 266 and area_big = 2 and shop_id != 267 and area_big = 2 and shop_id != 274 and area_big = 2 and shop_id != 277 and area_big = 2 and shop_id != 278 and area_big = 2 and shop_id != 279 and area_big = 2 and shop_id != 280 and area_big = 2 and shop_id != 281 and area_big = 2 and shop_id != 282 and area_big = 2 and shop_id != 285 and area_big = 2 and shop_id != 286 and area_big = 2 and shop_id != 287 and area_big = 2 and shop_id != 289 and area_big = 2 and shop_id != 290 and area_big = 2 and shop_id != 291 and area_big = 2 and shop_id != 292 and area_big = 2 and shop_id != 293 and area_big = 2 and shop_id != 295 and area_big = 2 and shop_id != 297 and area_big = 2 and shop_id != 298 and area_big = 2 and shop_id != 299 and area_big = 2 and shop_id != 300 and area_big = 2 and shop_id != 301 and area_big = 2 and shop_id != 302 and area_big = 2 and shop_id != 304 and area_big = 2 and shop_id != 305 and area_big = 2 and shop_id != 306 and area_big = 2 and shop_id != 307 and area_big = 2 and shop_id != 320 and area_big = 2 and shop_id != 345 and area_big = 2 and shop_id != 351 and area_big = 2 and shop_id != 358 and area_big = 2 and shop_id != 371 and area_big = 2 and shop_id != 374 and area_big = 2 and shop_id != 375 and area_big = 2 and shop_id != 377 and area_big = 2 and shop_id != 378 and area_big = 2 and shop_id != 379 and area_big = 2 and shop_id != 380 and area_big = 2 and shop_id != 382 and area_big = 2 and shop_id != 383 and area_big = 2 and shop_id != 384 and area_big = 2 and shop_id != 386 and area_big = 2 and shop_id != 387 and area_big = 2 and shop_id != 389 and area_big = 2 and shop_id != 390 and area_big = 2 and shop_id != 391 and area_big = 2 and shop_id != 393 and area_big = 2 and shop_id != 395 and area_big = 2 and shop_id != 397 and area_big = 2 and shop_id != 401 and area_big = 2 and shop_id != 402 and area_big = 2 and shop_id != 403 and area_big = 2 and shop_id != 404 and area_big = 2 and shop_id != 406 and area_big = 2 and shop_id != 407 and area_big = 2 and shop_id != 409 and area_big = 2 and shop_id != 410 and area_big = 2 and shop_id != 411 and area_big = 2 and shop_id != 414 and area_big = 2 and shop_id != 415 and area_big = 2 and shop_id != 416 and area_big = 2 and shop_id != 421 and area_big = 2 and shop_id != 422 and area_big = 2 and shop_id != 423 and area_big = 2 and shop_id != 424 and area_big = 2 and shop_id != 427 and area_big = 2 and shop_id != 428 and area_big = 2 and shop_id != 429 and area_big = 2 and shop_id != 430 and area_big = 2 and shop_id != 431 and area_big = 2 and shop_id != 432 and area_big = 2 and shop_id != 433 and area_big = 2 and shop_id != 434 and area_big = 2 and shop_id != 435 and area_big = 2 and shop_id != 436 and area_big = 2 and shop_id != 437 and area_big = 2 and shop_id != 438 and area_big = 2 and shop_id != 439 and area_big = 2 and shop_id != 440 and area_big = 2 and shop_id != 441 and area_big = 2 and shop_id != 443 and area_big = 2 and shop_id != 444 and area_big = 2 and shop_id != 445 and area_big = 2 and shop_id != 446 and area_big = 2 and shop_id != 447 and area_big = 2 and shop_id != 448 and area_big = 2 and shop_id != 450 and area_big = 2 and shop_id != 451 and area_big = 2 and shop_id != 453 and area_big = 2 and shop_id != 454 and area_big = 2 and shop_id != 455 and area_big = 2 and shop_id != 456 and area_big = 2 and shop_id != 457 and area_big = 2 and shop_id != 458 and area_big = 2 and shop_id != 461 and area_big = 2 and shop_id != 462 and area_big = 2 and shop_id != 463 and area_big = 2 and shop_id != 464 and area_big = 2 and shop_id != 465 and area_big = 2 and shop_id != 466 and area_big = 2 and shop_id != 467 and area_big = 2 and shop_id != 469 and area_big = 2 and shop_id != 471 and area_big = 2 and shop_id != 472 and area_big = 2 and shop_id != 473 and area_big = 2 and shop_id != 475 and area_big = 2 and shop_id != 476 and area_big = 2 and shop_id != 477 and area_big = 2 and shop_id != 479 and area_big = 2 and shop_id != 480 and area_big = 2 and shop_id != 481 and area_big = 2 and shop_id != 482 and area_big = 2 and shop_id != 493 and area_big = 2 and shop_id != 494 and area_big = 2 and shop_id != 500 and area_big = 2 and shop_id != 501 and area_big = 2 and shop_id != 503 and area_big = 2 and shop_id != 505 and area_big = 2 and shop_id != 515 and area_big = 2 and shop_id != 516 and area_big = 2 and shop_id != 517 and area_big = 2 and shop_id != 521 and area_big = 2 and shop_id != 522 and area_big = 2 and shop_id != 537 and area_big = 2 and shop_id != 544 and area_big = 2 and shop_id != 545 and area_big = 2 and shop_id != 566 and area_big = 2 and shop_id != 567 and area_big = 2 and shop_id != 572 and area_big = 2 and shop_id != 574 and area_big = 2 and shop_id != 577 and area_big = 2 and shop_id != 581 and area_big = 2 and shop_id != 582 and area_big = 2 and shop_id != 587 and area_big = 2 and shop_id != 588 and area_big = 2 and shop_id != 591 and area_big = 2 and shop_id != 594 and area_big = 2 and shop_id != 603 and area_big = 2 and shop_id != 608 and area_big = 2 and shop_id != 610 and area_big = 2 and shop_id != 611 and area_big = 2 and shop_id != 617 and area_big = 2 and shop_id != 620 and area_big = 2 and shop_id != 621 and area_big = 2 and shop_id != 623 and area_big = 2 and shop_id != 624 and area_big = 2 and shop_id != 625 and area_big = 2 and shop_id != 628 and area_big = 2 and shop_id != 630 and area_big = 2 and shop_id != 634 and area_big = 2 and shop_id != 635 and area_big = 2 and shop_id != 637 and area_big = 2 and shop_id != 641 and area_big = 2 and shop_id != 642 and area_big = 2 and shop_id != 643 and area_big = 2 and shop_id != 651 and area_big = 2 and shop_id != 653 and area_big = 2 and shop_id != 656 and area_big = 2 and shop_id != 657 and area_big = 2 and shop_id != 659 and area_big = 2 and shop_id != 660 and area_big = 2 and shop_id != 663 and area_big = 2 and shop_id != 666 and area_big = 2 and shop_id != 670 and area_big = 2 and shop_id != 671 and area_big = 2 and shop_id != 672 and area_big = 2 and shop_id != 673 and area_big = 2 and shop_id != 674 and area_big = 2 and shop_id != 675 and area_big = 2 and shop_id != 676 and area_big = 2 and shop_id != 677 and area_big = 2 and shop_id != 678 and area_big = 2 and shop_id != 679 and area_big = 2 and shop_id != 680 and area_big = 2 and shop_id != 681 and area_big = 2 and shop_id != 683 and area_big = 2 and shop_id != 686 and area_big = 2 and shop_id != 688 and area_big = 2 and shop_id != 689 and area_big = 2 and shop_id != 691 and area_big = 2 and shop_id != 692 and area_big = 2 and shop_id != 693 and area_big = 2 and shop_id != 694 and area_big = 2 and shop_id != 695 and area_big = 2 and shop_id != 699 and area_big = 2 and shop_id != 700 and area_big = 2 and shop_id != 701 and area_big = 2 and shop_id != 702 and area_big = 2 and shop_id != 704 and area_big = 2 and shop_id != 708 and area_big = 2 and shop_id != 709 and area_big = 2 and shop_id != 710 and area_big = 2 and shop_id != 711 and area_big = 2 and shop_id != 712 and area_big = 2 and shop_id != 713 and area_big = 2 and shop_id != 717 and area_big = 2 and shop_id != 719 and area_big = 2 and shop_id != 720 and area_big = 2 and shop_id != 726 and area_big = 2 and shop_id != 727 and area_big = 2 and shop_id != 728 and area_big = 2 and shop_id != 729 and area_big = 2 and shop_id != 730 and area_big = 2 and shop_id != 731 and area_big = 2 and shop_id != 733 and area_big = 2 and shop_id != 734 and area_big = 2 and shop_id != 735 and area_big = 2 and shop_id != 736 and area_big = 2 and shop_id != 738 and area_big = 2 and shop_id != 739 and area_big = 2 and shop_id != 741 and area_big = 2 and shop_id != 743 and area_big = 2 and shop_id != 744 and area_big = 2 and shop_id != 745 and area_big = 2 and shop_id != 746 and area_big = 2 and shop_id != 747 and area_big = 2 and shop_id != 749 and area_big = 2 and shop_id != 750 and area_big = 2 and shop_id != 751 and area_big = 2 and shop_id != 755 and area_big = 2 and shop_id != 756 and area_big = 2 and shop_id != 757 and area_big = 2 and shop_id != 759 and area_big = 2 and shop_id != 783 and area_big = 2 and shop_id != 789 and area_big = 2 and shop_id != 790 and area_big = 2 and shop_id != 794 and area_big = 2 and shop_id != 796 and area_big = 2 and shop_id != 799 and area_big = 2 and shop_id != 802 and area_big = 2 and shop_id != 805 and area_big = 2 and shop_id != 806 and area_big = 2 and shop_id != 808 and area_big = 2 and shop_id != 809 and area_big = 2 and shop_id != 810 and area_big = 2 and shop_id != 812 and area_big = 2 and shop_id != 813 and area_big = 2 and shop_id != 821 and area_big = 2 and shop_id != 822 and area_big = 2 and shop_id != 827 and area_big = 2 and shop_id != 840 and shop_id != 15 and shop_id != 23 and shop_id != 32 and shop_id != 34 and shop_id != 35 and shop_id != 39 and shop_id != 42 and shop_id != 47 and shop_id != 49 and shop_id != 55 and shop_id != 56 and shop_id != 60 and shop_id != 62 and shop_id != 63 and shop_id != 65 and shop_id != 68 and shop_id != 71 and shop_id != 72 and shop_id != 89 and shop_id != 93 and shop_id != 94 and shop_id != 97 and shop_id != 98 and shop_id != 100 and shop_id != 104 and shop_id != 105 and shop_id != 106 and shop_id != 107 and shop_id != 110 and shop_id != 112 and shop_id != 115 and shop_id != 116 and shop_id != 117 and shop_id != 120 and shop_id != 121 and shop_id != 122 and shop_id != 126 and shop_id != 128 and shop_id != 130 and shop_id != 132 and shop_id != 135 and shop_id != 137 and shop_id != 140 and shop_id != 141 and shop_id != 144 and shop_id != 150 and shop_id != 153 and shop_id != 154 and shop_id != 157 and shop_id != 160 and shop_id != 162 and shop_id != 165 and shop_id != 166 and shop_id != 171 and shop_id != 174 and shop_id != 175 and shop_id != 176 and shop_id != 177 and shop_id != 178 and shop_id != 184 and shop_id != 186 and shop_id != 193 and shop_id != 198 and shop_id != 202 and shop_id != 207 and shop_id != 208 and shop_id != 209 and shop_id != 215 and shop_id != 226 and shop_id != 227 and shop_id != 229 and shop_id != 231 and shop_id != 235 and shop_id != 236 and shop_id != 241 and shop_id != 244 and shop_id != 251 and shop_id != 252 and shop_id != 253 and shop_id != 254 and shop_id != 257 and shop_id != 261 and shop_id != 268 and shop_id != 269 and shop_id != 272 and shop_id != 273 and shop_id != 284 and shop_id != 288 and shop_id != 294 and shop_id != 296 and shop_id != 308 and shop_id != 310 and shop_id != 311 and shop_id != 312 and shop_id != 313 and shop_id != 314 and shop_id != 315 and shop_id != 316 and shop_id != 317 and shop_id != 318 and shop_id != 319 and shop_id != 321 and shop_id != 322 and shop_id != 323 and shop_id != 324 and shop_id != 325 and shop_id != 327 and shop_id != 328 and shop_id != 329 and shop_id != 330 and shop_id != 331 and shop_id != 332 and shop_id != 333 and shop_id != 334 and shop_id != 335 and shop_id != 336 and shop_id != 337 and shop_id != 338 and shop_id != 339 and shop_id != 340 and shop_id != 341 and shop_id != 342 and shop_id != 343 and shop_id != 344 and shop_id != 346 and shop_id != 347 and shop_id != 348 and shop_id != 349 and shop_id != 350 and shop_id != 352 and shop_id != 353 and shop_id != 354 and shop_id != 355 and shop_id != 356 and shop_id != 357 and shop_id != 359 and shop_id != 360 and shop_id != 361 and shop_id != 362 and shop_id != 363 and shop_id != 364 and shop_id != 365 and shop_id != 366 and shop_id != 367 and shop_id != 368 and shop_id != 369 and shop_id != 370 and shop_id != 372 and shop_id != 373 and shop_id != 376 and shop_id != 381 and shop_id != 385 and shop_id != 392 and shop_id != 394 and shop_id != 396 and shop_id != 398 and shop_id != 399 and shop_id != 405 and shop_id != 412 and shop_id != 413 and shop_id != 417 and shop_id != 442 and shop_id != 449 and shop_id != 452 and shop_id != 459 and shop_id != 460 and shop_id != 468 and shop_id != 470 and shop_id != 478 and shop_id != 483 and shop_id != 484 and shop_id != 485 and shop_id != 486 and shop_id != 487 and shop_id != 488 and shop_id != 490 and shop_id != 492 and shop_id != 495 and shop_id != 496 and shop_id != 497 and shop_id != 498 and shop_id != 499 and shop_id != 502 and shop_id != 504 and shop_id != 506 and shop_id != 507 and shop_id != 508 and shop_id != 510 and shop_id != 511 and shop_id != 512 and shop_id != 513 and shop_id != 514 and shop_id != 518 and shop_id != 523 and shop_id != 524 and shop_id != 525 and shop_id != 526 and shop_id != 527 and shop_id != 528 and shop_id != 529 and shop_id != 530 and shop_id != 531 and shop_id != 532 and shop_id != 533 and shop_id != 534 and shop_id != 535 and shop_id != 536 and shop_id != 538 and shop_id != 539 and shop_id != 540 and shop_id != 541 and shop_id != 542 and shop_id != 543 and shop_id != 547 and shop_id != 548 and shop_id != 549 and shop_id != 550 and shop_id != 551 and shop_id != 552 and shop_id != 553 and shop_id != 554 and shop_id != 555 and shop_id != 556 and shop_id != 557 and shop_id != 558 and shop_id != 559 and shop_id != 560 and shop_id != 561 and shop_id != 562 and shop_id != 563 and shop_id != 564 and shop_id != 565 and shop_id != 569 and shop_id != 570 and shop_id != 571 and shop_id != 573 and shop_id != 575 and shop_id != 576 and shop_id != 580 and shop_id != 586 and shop_id != 589 and shop_id != 590 and shop_id != 592 and shop_id != 593 and shop_id != 595 and shop_id != 596 and shop_id != 597 and shop_id != 598 and shop_id != 599 and shop_id != 600 and shop_id != 601 and shop_id != 604 and shop_id != 605 and shop_id != 606 and shop_id != 607 and shop_id != 609 and shop_id != 615 and shop_id != 619 and shop_id != 626 and shop_id != 639 and shop_id != 644 and shop_id != 648 and shop_id != 649 and shop_id != 652 and shop_id != 654 and shop_id != 655 and shop_id != 658 and shop_id != 687 and shop_id != 696 and shop_id != 703 and shop_id != 714 and shop_id != 722 and shop_id != 724 and shop_id != 732 and shop_id != 737 and shop_id != 740 and shop_id != 742 and shop_id != 748 and shop_id != 758 and shop_id != 760 and shop_id != 761 and shop_id != 762 and shop_id != 764 and shop_id != 766 and shop_id != 767 and shop_id != 782 and shop_id != 784 and shop_id != 786 and shop_id != 787 and shop_id != 793 and shop_id != 798 and shop_id != 800 and shop_id != 804 and shop_id != 811 and shop_id != 824 and shop_id != 828 and shop_id != 833 and shop_id != 837 group by shop_id order by AVG(rank) desc