126 Incorrect key file for table '/tmp/#sql_7fc_0.MYI'; try to repair it
in:
[select distinct p.products_id, p.products_type,p.products_image,p.products_model, p.master_categories_id, p.manufacturers_id, p.products_price,p.products_date_added, p.products_tax_class_id, pd.products_description,pd.products_name, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and ( p2c.categories_id =236 or p2c.categories_id =237 or p2c.categories_id =238 or p2c.categories_id =239 or p2c.categories_id =240 or p2c.categories_id =233 or p2c.categories_id =315 or p2c.categories_id =316 or p2c.categories_id =317 or p2c.categories_id =318 or p2c.categories_id =319 or p2c.categories_id =320 or p2c.categories_id =321 or p2c.categories_id =322 or p2c.categories_id =323 or p2c.categories_id =324 or p2c.categories_id =325 or p2c.categories_id =326 or p2c.categories_id =327 or p2c.categories_id =328 or p2c.categories_id =329 or p2c.categories_id =330 or p2c.categories_id =331 or p2c.categories_id =332 or p2c.categories_id =333 or p2c.categories_id =334 or p2c.categories_id =335 or p2c.categories_id =336 or p2c.categories_id =337 or p2c.categories_id =338 or p2c.categories_id =339 or p2c.categories_id =340 or p2c.categories_id =341 or p2c.categories_id =342 or p2c.categories_id =343 or p2c.categories_id =344 or p2c.categories_id =345 or p2c.categories_id =346 or p2c.categories_id =347 or p2c.categories_id =348 or p2c.categories_id =349 or p2c.categories_id =350 or p2c.categories_id =351 or p2c.categories_id =352 or p2c.categories_id =353 or p2c.categories_id =354 or p2c.categories_id =355 or p2c.categories_id =356 or p2c.categories_id =357 or p2c.categories_id =358 or p2c.categories_id =359 or p2c.categories_id =360 or p2c.categories_id =361 or p2c.categories_id =362 or p2c.categories_id =363 or p2c.categories_id =364 or p2c.categories_id =365 or p2c.categories_id =366 or p2c.categories_id =367 or p2c.categories_id =368 or p2c.categories_id =369 or p2c.categories_id =370 or p2c.categories_id =371 or p2c.categories_id =372 or p2c.categories_id =497 or p2c.categories_id =501 or p2c.categories_id =506 or p2c.categories_id =507 or p2c.categories_id =508 or p2c.categories_id =509 or p2c.categories_id =510 or p2c.categories_id =511 or p2c.categories_id =513 or p2c.categories_id =514 or p2c.categories_id =515 or p2c.categories_id =516 or p2c.categories_id =517 or p2c.categories_id =518 or p2c.categories_id =519 or p2c.categories_id =520 or p2c.categories_id =521 or p2c.categories_id =522 or p2c.categories_id =523 or p2c.categories_id =524 or p2c.categories_id =525 or p2c.categories_id =526 or p2c.categories_id =527 or p2c.categories_id =528 or p2c.categories_id =529 or p2c.categories_id =530 or p2c.categories_id =531 or p2c.categories_id =532 or p2c.categories_id =533 or p2c.categories_id =534 or p2c.categories_id =535 or p2c.categories_id =536 or p2c.categories_id =537 or p2c.categories_id =538 or p2c.categories_id =539 or p2c.categories_id =540 or p2c.categories_id =541 or p2c.categories_id =542 or p2c.categories_id =543 or p2c.categories_id =544 or p2c.categories_id =545 or p2c.categories_id =546 or p2c.categories_id =547 or p2c.categories_id =548 or p2c.categories_id =549 or p2c.categories_id =550 or p2c.categories_id =551 or p2c.categories_id =552 or p2c.categories_id =553 or p2c.categories_id =554 or p2c.categories_id =555 or p2c.categories_id =557 or p2c.categories_id =558 or p2c.categories_id =559 or p2c.categories_id =560 or p2c.categories_id =561 or p2c.categories_id =562 or p2c.categories_id =563 or p2c.categories_id =564 or p2c.categories_id =565 or p2c.categories_id =566 or p2c.categories_id =567 or p2c.categories_id =568 or p2c.categories_id =569 or p2c.categories_id =570 or p2c.categories_id =571 or p2c.categories_id =572 or p2c.categories_id =573 or p2c.categories_id =574 or p2c.categories_id =575 or p2c.categories_id =576 or p2c.categories_id =577 or p2c.categories_id =578 or p2c.categories_id =579 or p2c.categories_id =580 or p2c.categories_id =581 or p2c.categories_id =582 or p2c.categories_id =583 or p2c.categories_id =584 or p2c.categories_id =585 or p2c.categories_id =586 or p2c.categories_id =587 or p2c.categories_id =589 or p2c.categories_id =590 or p2c.categories_id =591 or p2c.categories_id =592 or p2c.categories_id =593 or p2c.categories_id =594 or p2c.categories_id =595 or p2c.categories_id =596 or p2c.categories_id =597 or p2c.categories_id =598 or p2c.categories_id =599 or p2c.categories_id =600 or p2c.categories_id =601 or p2c.categories_id =602 or p2c.categories_id =603 or p2c.categories_id =604 or p2c.categories_id =605 or p2c.categories_id =606 or p2c.categories_id =607 or p2c.categories_id =608 or p2c.categories_id =609 or p2c.categories_id =610 or p2c.categories_id =611 or p2c.categories_id =612 or p2c.categories_id =613 or p2c.categories_id =614 or p2c.categories_id =615 or p2c.categories_id =616 or p2c.categories_id =617 or p2c.categories_id =618 or p2c.categories_id =619 or p2c.categories_id =620 or p2c.categories_id =621 or p2c.categories_id =622 or p2c.categories_id =623 or p2c.categories_id =624 or p2c.categories_id =626 or p2c.categories_id =628 or p2c.categories_id =629 or p2c.categories_id =630 or p2c.categories_id =631 or p2c.categories_id =632 or p2c.categories_id =634 or p2c.categories_id =635 or p2c.categories_id =636 or p2c.categories_id =637 or p2c.categories_id =638 or p2c.categories_id =640 or p2c.categories_id =641 or p2c.categories_id =642 or p2c.categories_id =643 or p2c.categories_id =644 or p2c.categories_id =645 or p2c.categories_id =646 or p2c.categories_id =647 or p2c.categories_id =648 or p2c.categories_id =650 or p2c.categories_id =651 or p2c.categories_id =652 or p2c.categories_id =653 or p2c.categories_id =654 or p2c.categories_id =655 or p2c.categories_id =656 or p2c.categories_id =657 or p2c.categories_id =658 or p2c.categories_id =659 or p2c.categories_id =660 or p2c.categories_id =661 or p2c.categories_id =662 or p2c.categories_id =663 or p2c.categories_id =664 or p2c.categories_id =665 or p2c.categories_id =666 or p2c.categories_id =667 or p2c.categories_id =668 or p2c.categories_id =669 or p2c.categories_id =670 or p2c.categories_id =671 or p2c.categories_id =672 or p2c.categories_id =673 or p2c.categories_id =674 or p2c.categories_id =675 or p2c.categories_id =677 or p2c.categories_id =678 or p2c.categories_id =679 or p2c.categories_id =680 or p2c.categories_id =681 or p2c.categories_id =682 or p2c.categories_id =683 or p2c.categories_id =685 or p2c.categories_id =686 or p2c.categories_id =687 or p2c.categories_id =689 or p2c.categories_id =690 or p2c.categories_id =691 or p2c.categories_id =692 or p2c.categories_id =693 or p2c.categories_id =694 or p2c.categories_id =695 or p2c.categories_id =696 or p2c.categories_id =697 or p2c.categories_id =698 or p2c.categories_id =699 or p2c.categories_id =700 or p2c.categories_id =701 or p2c.categories_id =702 or p2c.categories_id =703 or p2c.categories_id =705 or p2c.categories_id =706 or p2c.categories_id =707 or p2c.categories_id =708 or p2c.categories_id =709 or p2c.categories_id =710 or p2c.categories_id =711 or p2c.categories_id =712 or p2c.categories_id =713 or p2c.categories_id =714 or p2c.categories_id =715 or p2c.categories_id =716 or p2c.categories_id =717 or p2c.categories_id =718 or p2c.categories_id =719 or p2c.categories_id =720 or p2c.categories_id =721 or p2c.categories_id =722 or p2c.categories_id =723 or p2c.categories_id =724 or p2c.categories_id =725 or p2c.categories_id =727 or p2c.categories_id =728 or p2c.categories_id =729 or p2c.categories_id =730 or p2c.categories_id =731 or p2c.categories_id =732 or p2c.categories_id =733 or p2c.categories_id =735 or p2c.categories_id =736 or p2c.categories_id =737 or p2c.categories_id =738 or p2c.categories_id =739 or p2c.categories_id =740 or p2c.categories_id =741 or p2c.categories_id =742 or p2c.categories_id =743 or p2c.categories_id =744 or p2c.categories_id =746 or p2c.categories_id =747 or p2c.categories_id =748 or p2c.categories_id =750 or p2c.categories_id =753 or p2c.categories_id =754 or p2c.categories_id =756 or p2c.categories_id =759 or p2c.categories_id =760 or p2c.categories_id =761 or p2c.categories_id =762 or p2c.categories_id =764 or p2c.categories_id =765 or p2c.categories_id =766 or p2c.categories_id =767 or p2c.categories_id =768 or p2c.categories_id =770 or p2c.categories_id =771 or p2c.categories_id =772 or p2c.categories_id =773 or p2c.categories_id =775 or p2c.categories_id =776 or p2c.categories_id =777 or p2c.categories_id =778 or p2c.categories_id =779 or p2c.categories_id =780 or p2c.categories_id =781 or p2c.categories_id =782 or p2c.categories_id =783 or p2c.categories_id =784 or p2c.categories_id =785 or p2c.categories_id =786 or p2c.categories_id =787 or p2c.categories_id =788 or p2c.categories_id =789 or p2c.categories_id =790 or p2c.categories_id =791 or p2c.categories_id =792 or p2c.categories_id =793 or p2c.categories_id =794 or p2c.categories_id =795 or p2c.categories_id =796 or p2c.categories_id =797 or p2c.categories_id =798 or p2c.categories_id =799 or p2c.categories_id =800 or p2c.categories_id =801 or p2c.categories_id =802 or p2c.categories_id =803 or p2c.categories_id =804 or p2c.categories_id =805 or p2c.categories_id =806 or p2c.categories_id =807 or p2c.categories_id =808 or p2c.categories_id =809 or p2c.categories_id =810 or p2c.categories_id =811 or p2c.categories_id =812 or p2c.categories_id =813 or p2c.categories_id =814 or p2c.categories_id =815 or p2c.categories_id =816 or p2c.categories_id =817 or p2c.categories_id =818 or p2c.categories_id =819 or p2c.categories_id =820 or p2c.categories_id =822 or p2c.categories_id =823 or p2c.categories_id =824 or p2c.categories_id =825 or p2c.categories_id =826 or p2c.categories_id =827 or p2c.categories_id =828 or p2c.categories_id =829 or p2c.categories_id =830 or p2c.categories_id =831 or p2c.categories_id =832 or p2c.categories_id =833 or p2c.categories_id =834 or p2c.categories_id =835 or p2c.categories_id =836 or p2c.categories_id =837 or p2c.categories_id =838 or p2c.categories_id =839 or p2c.categories_id =841 or p2c.categories_id =842 or p2c.categories_id =843 or p2c.categories_id =844 or p2c.categories_id =846 or p2c.categories_id =847 or p2c.categories_id =848 or p2c.categories_id =849 or p2c.categories_id =850 or p2c.categories_id =851 or p2c.categories_id =852 or p2c.categories_id =853 or p2c.categories_id =854 or p2c.categories_id =855 or p2c.categories_id =856 or p2c.categories_id =857 or p2c.categories_id =858 or p2c.categories_id =859 or p2c.categories_id =860 or p2c.categories_id =861 or p2c.categories_id =862 or p2c.categories_id =863 or p2c.categories_id =864 or p2c.categories_id =865 or p2c.categories_id =866 or p2c.categories_id =867 or p2c.categories_id =868 or p2c.categories_id =869 or p2c.categories_id =870 or p2c.categories_id =871 or p2c.categories_id =872 or p2c.categories_id =873 or p2c.categories_id =874 or p2c.categories_id =875 or p2c.categories_id =876 or p2c.categories_id =877 or p2c.categories_id =878 or p2c.categories_id =879 or p2c.categories_id =880 or p2c.categories_id =881 or p2c.categories_id =882 or p2c.categories_id =883 or p2c.categories_id =884 or p2c.categories_id =887 or p2c.categories_id =888 or p2c.categories_id =889 or p2c.categories_id =890 or p2c.categories_id =891 or p2c.categories_id =892 or p2c.categories_id =893 or p2c.categories_id =894 or p2c.categories_id =895 or p2c.categories_id =896 or p2c.categories_id =897 or p2c.categories_id =898 or p2c.categories_id =899 or p2c.categories_id =900 or p2c.categories_id =901 or p2c.categories_id =902 or p2c.categories_id =903 or p2c.categories_id =904 or p2c.categories_id =905 or p2c.categories_id =906 or p2c.categories_id =907 or p2c.categories_id =908 or p2c.categories_id =909 or p2c.categories_id =910 or p2c.categories_id =911 or p2c.categories_id =912 or p2c.categories_id =913 or p2c.categories_id =914 or p2c.categories_id =915 or p2c.categories_id =916 or p2c.categories_id =917 or p2c.categories_id =918 or p2c.categories_id =919 or p2c.categories_id =920 or p2c.categories_id =921 or p2c.categories_id =935 or p2c.categories_id =241 or p2c.categories_id =232 or p2c.categories_id =245 or p2c.categories_id =247 or p2c.categories_id =248 or p2c.categories_id =249 or p2c.categories_id =250 or p2c.categories_id =251 or p2c.categories_id =252 or p2c.categories_id =253 or p2c.categories_id =254 or p2c.categories_id =255 or p2c.categories_id =256 or p2c.categories_id =257 or p2c.categories_id =258 or p2c.categories_id =259 or p2c.categories_id =260 or p2c.categories_id =261 or p2c.categories_id =262 or p2c.categories_id =263 or p2c.categories_id =264 or p2c.categories_id =265 or p2c.categories_id =266 or p2c.categories_id =267 or p2c.categories_id =268 or p2c.categories_id =269 or p2c.categories_id =270 or p2c.categories_id =271 or p2c.categories_id =272 or p2c.categories_id =273 or p2c.categories_id =274 or p2c.categories_id =275 or p2c.categories_id =276 or p2c.categories_id =277 or p2c.categories_id =278 or p2c.categories_id =279 or p2c.categories_id =280 or p2c.categories_id =281 or p2c.categories_id =282 or p2c.categories_id =283 or p2c.categories_id =284 or p2c.categories_id =285 or p2c.categories_id =286 or p2c.categories_id =288 or p2c.categories_id =289 or p2c.categories_id =290 or p2c.categories_id =291 or p2c.categories_id =292 or p2c.categories_id =293 or p2c.categories_id =294 or p2c.categories_id =295 or p2c.categories_id =296 or p2c.categories_id =297 or p2c.categories_id =298 or p2c.categories_id =299 or p2c.categories_id =300 or p2c.categories_id =301 or p2c.categories_id =302 or p2c.categories_id =303 or p2c.categories_id =304 or p2c.categories_id =305 or p2c.categories_id =306 or p2c.categories_id =307 or p2c.categories_id =308 or p2c.categories_id =309 or p2c.categories_id =310 or p2c.categories_id =314 or p2c.categories_id =504 or p2c.categories_id =505 or p2c.categories_id =933 or p2c.categories_id =242 or p2c.categories_id =234 or p2c.categories_id =373 or p2c.categories_id =374 or p2c.categories_id =375 or p2c.categories_id =376 or p2c.categories_id =377 or p2c.categories_id =378 or p2c.categories_id =379 or p2c.categories_id =380 or p2c.categories_id =381 or p2c.categories_id =382 or p2c.categories_id =383 or p2c.categories_id =384 or p2c.categories_id =385 or p2c.categories_id =386 or p2c.categories_id =387 or p2c.categories_id =388 or p2c.categories_id =389 or p2c.categories_id =390 or p2c.categories_id =391 or p2c.categories_id =392 or p2c.categories_id =393 or p2c.categories_id =394 or p2c.categories_id =395 or p2c.categories_id =396 or p2c.categories_id =397 or p2c.categories_id =398 or p2c.categories_id =399 or p2c.categories_id =400 or p2c.categories_id =401 or p2c.categories_id =402 or p2c.categories_id =403 or p2c.categories_id =404 or p2c.categories_id =405 or p2c.categories_id =406 or p2c.categories_id =407 or p2c.categories_id =408 or p2c.categories_id =409 or p2c.categories_id =410 or p2c.categories_id =411 or p2c.categories_id =412 or p2c.categories_id =413 or p2c.categories_id =414 or p2c.categories_id =415 or p2c.categories_id =416 or p2c.categories_id =417 or p2c.categories_id =418 or p2c.categories_id =419 or p2c.categories_id =420 or p2c.categories_id =421 or p2c.categories_id =422 or p2c.categories_id =423 or p2c.categories_id =424 or p2c.categories_id =425 or p2c.categories_id =498 or p2c.categories_id =499 or p2c.categories_id =500 or p2c.categories_id =938 or p2c.categories_id =243 or p2c.categories_id =235 or p2c.categories_id =426 or p2c.categories_id =427 or p2c.categories_id =428 or p2c.categories_id =429 or p2c.categories_id =430 or p2c.categories_id =431 or p2c.categories_id =432 or p2c.categories_id =433 or p2c.categories_id =434 or p2c.categories_id =435 or p2c.categories_id =436 or p2c.categories_id =437 or p2c.categories_id =438 or p2c.categories_id =439 or p2c.categories_id =440 or p2c.categories_id =441 or p2c.categories_id =442 or p2c.categories_id =443 or p2c.categories_id =444 or p2c.categories_id =445 or p2c.categories_id =446 or p2c.categories_id =447 or p2c.categories_id =448 or p2c.categories_id =449 or p2c.categories_id =451 or p2c.categories_id =452 or p2c.categories_id =453 or p2c.categories_id =454 or p2c.categories_id =455 or p2c.categories_id =456 or p2c.categories_id =457 or p2c.categories_id =458 or p2c.categories_id =459 or p2c.categories_id =460 or p2c.categories_id =461 or p2c.categories_id =462 or p2c.categories_id =502 or p2c.categories_id =939 or p2c.categories_id =244 or p2c.categories_id =463 or p2c.categories_id =464 or p2c.categories_id =465 or p2c.categories_id =466 or p2c.categories_id =467 or p2c.categories_id =468 or p2c.categories_id =469 or p2c.categories_id =470 or p2c.categories_id =471 or p2c.categories_id =472 or p2c.categories_id =473 or p2c.categories_id =474 or p2c.categories_id =475 or p2c.categories_id =476 or p2c.categories_id =477 or p2c.categories_id =478 or p2c.categories_id =479 or p2c.categories_id =480 or p2c.categories_id =481 or p2c.categories_id =482 or p2c.categories_id =483 or p2c.categories_id =484 or p2c.categories_id =485 or p2c.categories_id =486 or p2c.categories_id =487 or p2c.categories_id =488 or p2c.categories_id =493 or p2c.categories_id =489 or p2c.categories_id =490 or p2c.categories_id =491 or p2c.categories_id =492 or p2c.categories_id =494 or p2c.categories_id =495 or p2c.categories_id =496 or p2c.categories_id =503 or p2c.categories_id =934 or p2c.categories_id =923 or p2c.categories_id =924 or p2c.categories_id =925 or p2c.categories_id =926 or p2c.categories_id =927 or p2c.categories_id =928 or p2c.categories_id =929 or p2c.categories_id =931 or p2c.categories_id =932 or p2c.categories_id =936 or p2c.categories_id =940 or p2c.categories_id =941 or p2c.categories_id =937 or p2c.categories_id =942 or p2c.categories_id =943 or p2c.categories_id =944 or p2c.categories_id =945 or p2c.categories_id =946 or p2c.categories_id =947) order by p.products_sort_order desc,p.products_ordered desc,pd.products_name asc]