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 = 5 and t.id_modelu = 38219 and ( p2c.categories_id = 100373 or p2c.categories_id = 100380 or p2c.categories_id = 100379 or p2c.categories_id = 100788 or p2c.categories_id = 102778 or p2c.categories_id = 100375 or p2c.categories_id = 102450 or p2c.categories_id = 100377 or p2c.categories_id = 100378 or p2c.categories_id = 100374 or p2c.categories_id = 100376 or p2c.categories_id = 100515 or p2c.categories_id = 100519 or p2c.categories_id = 100524 or p2c.categories_id = 100525 or p2c.categories_id = 100526 or p2c.categories_id = 100528 or p2c.categories_id = 100527 or p2c.categories_id = 100518 or p2c.categories_id = 100521 or p2c.categories_id = 100520 or p2c.categories_id = 100531 or p2c.categories_id = 100532 or p2c.categories_id = 100529 or p2c.categories_id = 100530 or p2c.categories_id = 103270 or p2c.categories_id = 100517 or p2c.categories_id = 100886 or p2c.categories_id = 100522 or p2c.categories_id = 100786 or p2c.categories_id = 100523 or p2c.categories_id = 100759 or p2c.categories_id = 102683 or p2c.categories_id = 103120 or p2c.categories_id = 103129 or p2c.categories_id = 100754 or p2c.categories_id = 103397 or p2c.categories_id = 103037 or p2c.categories_id = 100700 or p2c.categories_id = 100701 or p2c.categories_id = 100702 or p2c.categories_id = 100514 or p2c.categories_id = 100760 or p2c.categories_id = 100533 or p2c.categories_id = 100767 or p2c.categories_id = 100534 or p2c.categories_id = 105862 or p2c.categories_id = 105864 or p2c.categories_id = 105860 or p2c.categories_id = 105861 or p2c.categories_id = 100245 or p2c.categories_id = 100474 or p2c.categories_id = 100483 or p2c.categories_id = 100485 or p2c.categories_id = 100488 or p2c.categories_id = 103072 or p2c.categories_id = 100470 or p2c.categories_id = 100479 or p2c.categories_id = 100512 or p2c.categories_id = 100475 or p2c.categories_id = 100491 or p2c.categories_id = 100489 or p2c.categories_id = 100490 or p2c.categories_id = 100472 or p2c.categories_id = 101994 or p2c.categories_id = 100476 or p2c.categories_id = 100494 or p2c.categories_id = 100492 or p2c.categories_id = 100493 or p2c.categories_id = 100885 or p2c.categories_id = 100481 or p2c.categories_id = 100838 or p2c.categories_id = 100477 or p2c.categories_id = 100513 or p2c.categories_id = 100478 or p2c.categories_id = 100003 or p2c.categories_id = 101833 or p2c.categories_id = 100425 or p2c.categories_id = 100396 or p2c.categories_id = 100410 or p2c.categories_id = 102015 or p2c.categories_id = 100404 or p2c.categories_id = 100409 or p2c.categories_id = 100406 or p2c.categories_id = 100407 or p2c.categories_id = 100875 or p2c.categories_id = 100405 or p2c.categories_id = 102027 or p2c.categories_id = 100399 or p2c.categories_id = 100398 or p2c.categories_id = 100401 or p2c.categories_id = 100852 or p2c.categories_id = 100397 or p2c.categories_id = 100422 or p2c.categories_id = 100424 or p2c.categories_id = 100423 or p2c.categories_id = 100403 or p2c.categories_id = 100414 or p2c.categories_id = 101485 or p2c.categories_id = 100413 or p2c.categories_id = 103278 or p2c.categories_id = 100411 or p2c.categories_id = 104695 or p2c.categories_id = 103437 or p2c.categories_id = 100541 or p2c.categories_id = 100866 or p2c.categories_id = 100542 or p2c.categories_id = 103237 or p2c.categories_id = 103236 or p2c.categories_id = 100551 or p2c.categories_id = 100546 or p2c.categories_id = 102993 or p2c.categories_id = 100543 or p2c.categories_id = 100545 or p2c.categories_id = 103235 or p2c.categories_id = 103238 or p2c.categories_id = 100549 or p2c.categories_id = 100729 or p2c.categories_id = 100552 or p2c.categories_id = 100560 or p2c.categories_id = 100564 or p2c.categories_id = 103444 or p2c.categories_id = 100557 or p2c.categories_id = 100556 or p2c.categories_id = 100559 or p2c.categories_id = 100558 or p2c.categories_id = 103254 or p2c.categories_id = 100223 or p2c.categories_id = 100224 or p2c.categories_id = 100789 or p2c.categories_id = 100225 or p2c.categories_id = 100229 or p2c.categories_id = 100234 or p2c.categories_id = 100235 or p2c.categories_id = 100227 or p2c.categories_id = 100233 or p2c.categories_id = 100244 or p2c.categories_id = 100684 or p2c.categories_id = 100231 or p2c.categories_id = 100228 or p2c.categories_id = 100683 or p2c.categories_id = 100682 or p2c.categories_id = 102771 or p2c.categories_id = 100383 or p2c.categories_id = 100390 or p2c.categories_id = 103421 or p2c.categories_id = 100393 or p2c.categories_id = 102076 or p2c.categories_id = 100394 or p2c.categories_id = 100391 or p2c.categories_id = 100392 or p2c.categories_id = 103543 or p2c.categories_id = 100384 or p2c.categories_id = 100387 or p2c.categories_id = 100386 or p2c.categories_id = 100385 or p2c.categories_id = 100389 or p2c.categories_id = 100704 or p2c.categories_id = 100706 or p2c.categories_id = 102339 or p2c.categories_id = 100705 or p2c.categories_id = 102235 or p2c.categories_id = 100818 or p2c.categories_id = 102872 or p2c.categories_id = 100388 or p2c.categories_id = 100535 or p2c.categories_id = 100698 or p2c.categories_id = 100539 or p2c.categories_id = 100536 or p2c.categories_id = 100538 or p2c.categories_id = 104377 or p2c.categories_id = 104302 or p2c.categories_id = 104327 or p2c.categories_id = 104303 or p2c.categories_id = 104304 or p2c.categories_id = 104305 or p2c.categories_id = 104306 or p2c.categories_id = 104307 or p2c.categories_id = 104308 or p2c.categories_id = 104309 or p2c.categories_id = 104310 or p2c.categories_id = 104311 or p2c.categories_id = 104312 or p2c.categories_id = 104316 or p2c.categories_id = 104313 or p2c.categories_id = 104315 or p2c.categories_id = 104314 or p2c.categories_id = 104317 or p2c.categories_id = 104318 or p2c.categories_id = 104319 or p2c.categories_id = 104320 or p2c.categories_id = 104321 or p2c.categories_id = 104326 or p2c.categories_id = 104322 or p2c.categories_id = 104324 or p2c.categories_id = 104323 or p2c.categories_id = 104325 or p2c.categories_id = 104329 or p2c.categories_id = 104330 or p2c.categories_id = 104328 or p2c.categories_id = 104331 or p2c.categories_id = 104332) and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6