select distinct p.products_id, pd.products_name, pd.products_description, p.products_kod_oryginal, p.products_price, p.products_price_2, p.kaucja, p.products_tax_class_id, gf.thumb, gf.images, m.manufacturers_name from products p, products_description pd, typ_to_products t2p, typ t, products_to_categories_new p2c, stany_products sp, manufacturers m, grupy_foto_new gf where p.products_id = pd.products_id and p.products_id = sp.products_id and t2p.products_id = p.products_id and p.products_id = p2c.products_id and t2p.typ_id = t.id_typu and p.products_id = gf.products_id and t.id_marki = 93 and t.id_modelu = 1562 and ( p2c.categories_id = 100743 or p2c.categories_id = 100185 or p2c.categories_id = 100164 or p2c.categories_id = 100166 or p2c.categories_id = 100165 or p2c.categories_id = 100168 or p2c.categories_id = 100739 or p2c.categories_id = 100699 or p2c.categories_id = 100191 or p2c.categories_id = 100155 or p2c.categories_id = 100181 or p2c.categories_id = 100169 or p2c.categories_id = 100537 or p2c.categories_id = 100737 or p2c.categories_id = 100606 or p2c.categories_id = 101504 or p2c.categories_id = 100187 or p2c.categories_id = 104382 or p2c.categories_id = 104812 or p2c.categories_id = 104959 or p2c.categories_id = 103213 or p2c.categories_id = 103214 or p2c.categories_id = 103215 or p2c.categories_id = 103469 or p2c.categories_id = 100219 or p2c.categories_id = 100741 or p2c.categories_id = 100740 or p2c.categories_id = 100742 or p2c.categories_id = 100744 or p2c.categories_id = 100566 or p2c.categories_id = 100745 or p2c.categories_id = 100569 or p2c.categories_id = 100567 or p2c.categories_id = 102346 or p2c.categories_id = 100568 or p2c.categories_id = 100217 or p2c.categories_id = 103132 or p2c.categories_id = 101407 or p2c.categories_id = 101420 or p2c.categories_id = 102406 or p2c.categories_id = 101421 or p2c.categories_id = 101422 or p2c.categories_id = 101423 or p2c.categories_id = 101428 or p2c.categories_id = 101429 or p2c.categories_id = 101430 or p2c.categories_id = 101431 or p2c.categories_id = 101411 or p2c.categories_id = 101412 or p2c.categories_id = 101413 or p2c.categories_id = 101414 or p2c.categories_id = 101408 or p2c.categories_id = 101409 or p2c.categories_id = 101410 or p2c.categories_id = 101441 or p2c.categories_id = 101444 or p2c.categories_id = 101443 or p2c.categories_id = 101446 or p2c.categories_id = 101442 or p2c.categories_id = 101445 or p2c.categories_id = 101424 or p2c.categories_id = 101425 or p2c.categories_id = 101426 or p2c.categories_id = 101427 or p2c.categories_id = 101452 or p2c.categories_id = 101415 or p2c.categories_id = 101416 or p2c.categories_id = 101418 or p2c.categories_id = 101417 or p2c.categories_id = 101419 or p2c.categories_id = 101432 or p2c.categories_id = 101434 or p2c.categories_id = 101433 or p2c.categories_id = 101435 or p2c.categories_id = 103118 or p2c.categories_id = 100295 or p2c.categories_id = 101340 or p2c.categories_id = 101349 or p2c.categories_id = 101350 or p2c.categories_id = 101352 or p2c.categories_id = 101351 or p2c.categories_id = 101345 or p2c.categories_id = 101348 or p2c.categories_id = 101346 or p2c.categories_id = 101347 or p2c.categories_id = 101341 or p2c.categories_id = 101342 or p2c.categories_id = 101344 or p2c.categories_id = 101343 or p2c.categories_id = 101353 or p2c.categories_id = 101356 or p2c.categories_id = 101354 or p2c.categories_id = 101355 or p2c.categories_id = 100746 or p2c.categories_id = 102760 or p2c.categories_id = 100778 or p2c.categories_id = 102414 or p2c.categories_id = 100189 or p2c.categories_id = 102731 or p2c.categories_id = 100192 or p2c.categories_id = 100184 or p2c.categories_id = 101648 or p2c.categories_id = 101650 or p2c.categories_id = 101673 or p2c.categories_id = 101774 or p2c.categories_id = 101679 or p2c.categories_id = 101772 or p2c.categories_id = 101775 or p2c.categories_id = 101675 or p2c.categories_id = 101674 or p2c.categories_id = 101778 or p2c.categories_id = 101777 or p2c.categories_id = 101773 or p2c.categories_id = 101776 or p2c.categories_id = 103064 or p2c.categories_id = 101669 or p2c.categories_id = 101670 or p2c.categories_id = 101671 or p2c.categories_id = 101672 or p2c.categories_id = 101654 or p2c.categories_id = 101653 or p2c.categories_id = 101766 or p2c.categories_id = 101769 or p2c.categories_id = 101768 or p2c.categories_id = 101771 or p2c.categories_id = 101767 or p2c.categories_id = 101770 or p2c.categories_id = 103035 or p2c.categories_id = 101656 or p2c.categories_id = 101659 or p2c.categories_id = 101657 or p2c.categories_id = 101660 or p2c.categories_id = 101658 or p2c.categories_id = 101665 or p2c.categories_id = 101668 or p2c.categories_id = 101666 or p2c.categories_id = 101667 or p2c.categories_id = 101661 or p2c.categories_id = 101662 or p2c.categories_id = 101664 or p2c.categories_id = 101663 or p2c.categories_id = 101655 or p2c.categories_id = 101652 or p2c.categories_id = 101651 or p2c.categories_id = 101649 or p2c.categories_id = 104724 or p2c.categories_id = 101465 or p2c.categories_id = 101468 or p2c.categories_id = 101469 or p2c.categories_id = 101466 or p2c.categories_id = 101467 or p2c.categories_id = 100826 or p2c.categories_id = 101690 or p2c.categories_id = 101700 or p2c.categories_id = 101702 or p2c.categories_id = 101701 or p2c.categories_id = 101703 or p2c.categories_id = 102758 or p2c.categories_id = 101699 or p2c.categories_id = 101694 or p2c.categories_id = 101698 or p2c.categories_id = 101693 or p2c.categories_id = 101692 or p2c.categories_id = 101696 or p2c.categories_id = 101697 or p2c.categories_id = 101695 or p2c.categories_id = 101691 or p2c.categories_id = 101760 or p2c.categories_id = 101705 or p2c.categories_id = 101779 or p2c.categories_id = 101745 or p2c.categories_id = 101750 or p2c.categories_id = 101748 or p2c.categories_id = 101751 or p2c.categories_id = 101746 or p2c.categories_id = 101747 or p2c.categories_id = 101752 or p2c.categories_id = 101749 or p2c.categories_id = 101727 or p2c.categories_id = 101729 or p2c.categories_id = 101728 or p2c.categories_id = 101730 or p2c.categories_id = 101735 or p2c.categories_id = 101737 or p2c.categories_id = 101736 or p2c.categories_id = 101738 or p2c.categories_id = 101718 or p2c.categories_id = 101719 or p2c.categories_id = 101720 or p2c.categories_id = 101721 or p2c.categories_id = 101715 or p2c.categories_id = 101716 or p2c.categories_id = 101717 or p2c.categories_id = 101783 or p2c.categories_id = 101711 or p2c.categories_id = 101785 or p2c.categories_id = 101788 or p2c.categories_id = 101787 or p2c.categories_id = 101790 or p2c.categories_id = 101786 or p2c.categories_id = 101789 or p2c.categories_id = 101731 or p2c.categories_id = 101733 or p2c.categories_id = 101732 or p2c.categories_id = 101734 or p2c.categories_id = 103036 or p2c.categories_id = 101708 or p2c.categories_id = 101707 or p2c.categories_id = 101782 or p2c.categories_id = 101781 or p2c.categories_id = 101780 or p2c.categories_id = 101739 or p2c.categories_id = 101741 or p2c.categories_id = 101740 or p2c.categories_id = 101742 or p2c.categories_id = 101722 or p2c.categories_id = 101723 or p2c.categories_id = 101725 or p2c.categories_id = 101724 or p2c.categories_id = 101726 or p2c.categories_id = 101784 or p2c.categories_id = 101710 or p2c.categories_id = 101763 or p2c.categories_id = 101706 or p2c.categories_id = 101765 or p2c.categories_id = 101454 or p2c.categories_id = 100216 or p2c.categories_id = 105577 or p2c.categories_id = 104728) and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6