42000:SELECT SQL_CALC_FOUND_ROWS  A.id, A.menu_id, A.nr_kat, A.zestaw_odmian, A.lang0_rodzaj, A.grupa, A.lang0_ozd_lisc, A.kwitnienie, A.lang0_termin, A.sezon, A.sezon_new, A.lang0_opis, A.nazwa_foto, A.nowosc, A.sprzedaz, A.nazwa, A.gatunek, A.foto1, A.foto1crop, A.related, A.patent, A.licencja, A.foto_label, A.licencja_notatka, A.licencja_szt, A.sort_gatunek, A.akcja_new, A.lang0_opis_tab, A.photo_cnt, A.visual, A.landscape  , R.distributionAL, R.paleta as R_paleta, R.nr_kat as R_nr_kat,R.forma_prod as R_forma_prod,R.wyprzedany as R_wyprzedany,R.cena as R_cena,R.cena_euro as R_cena_euro,R.forma_opak as R_forma_opak,R.poile as R_poile,R.tygodnie_sprzed as R_tygodnie_sprzed,R.standard as R_standard,R.ilosc_w_opak as R_ilosc_w_opak, R.id as rid, R.id as R_id, R.index_magick, R.nowosc as R_nowosc, R.grupac, R.zamienniki_im, N.status as nadwyzka, N.tydzien as ntydzien, N.ilosc_pozostajaca, SUM(R.wyprzedany) as il_wyp, SUM(R.status) as il_form,GROUP_CONCAT(DISTINCT concat(N.id,':',N.tydzien)) as gtydzien, GROUP_CONCAT(DISTINCT concat(N.id,':',N.lt)) as glt, GROUP_CONCAT(DISTINCT concat(N.id,':',N.tydzien+N.lt)) as gtydzien_end, GROUP_CONCAT(DISTINCT concat(N.id,':',N.status)) as gnadwyzka, R.ts, R.tb ,GROUP_CONCAT(DISTINCT concat(N.id,':',N.ilosc_pozostajaca)) as gilosc_pozostajaca, GROUP_CONCAT(DISTINCT concat(N.id,':',N.kt)) as gkt, 
GROUP_CONCAT(DISTINCT concat(N.id,':',N.procent_upustu)) as gupausty,
C.upusty,
TS.rok as rok,
IF(C.cena_pln IS NOT NULL, C.cena_pln, R.cena) as R_cena,
IF(C.cena_eur IS NOT NULL, C.cena_eur, R.cena_euro) as R_cena_euro,
GROUP_CONCAT(DISTINCT TS.tydzien ORDER BY TS.tydzien ASC SEPARATOR ' ') as tygodnie,
C.wnp as blokady,0 as __search_priority FROM act_base_produkty as A   INNER JOIN act_base_produkty__cats as CATS 
										ON CATS.rid = A.id
										AND CATS.menu_id IN (102,2925,1626,440,2794,123,3819,124,3647,119,1637,120,194,2826,195,126,274,193,121,3806,3302,122,1627,309,188,3359,3792,2788,3639,3147,3149,3640,2789,3641,3150,3642,488,2895,3151,489,3036,2894,487,3152,3643,484,3644,2790,3330,3153,3334,492,3645,3154,4080,2791,2896,2897,2792,2940,3155,3646,3156,3413,2898,3903,496,497,2942,2795,3970,2796,3793,3340,3157,2939,3953,111,2853,115,2866,1417,2659,3333,450,3648,3649,1649,3650,1577,1418,3651,163,2658,189,2685,1643,2871,3335,3652,3653,3411,3654,3655,1638,4057,3158,3794,3159,3277,3656,1614,3825,3414,1640,3253,1641,3657,3800,2872,2689,3415,441,2687,2688,3160,2686,4006,3416,3161,3162,186,3366,2813,185,451,3945,3417,414,3163,2884,2690,3636,3638,449,3278,200,3042,3044,2824,4053,4054,3637,3801,3270,3900,4055,2825,2827,2828,3832,198,279,415,2691,3269,1578,2886,3419,3164,4048,2692,277,276,278,1420,2693,3802,1634,3659,3661,107,3409,330,4049,3996,3165,3901,4060,3660,3410,3855,3662,2873,3412,3663,202,4136,4137,1579,2780,3344,1586,203,3671,1580,1421,275,3672,3673,204,1587,2859,217,205,2888,470,280,1422,1633,3682,4047,1650,201,3683,3684,1588,2829,3920,2694,1581,207,3418,1440,2695,152,4081,208,2696,209,1635,210,2830,1589,1639,1590,211,1648,2697,471,212,213,2698,1591,1425,1592,103,2874,1593,1594,1642,214,1595,452,215,216,3685,2875,1596,3686,1426,3443,3045,3168,3169,3167,3171,3172,3909,3679,3805,3804,3297,3405,3336,3906,3014,3048,2889,3406,2883,4061,3263,118,422,4088,3997,3407,3408,3803,4089,4090,3681,2787,4084,3166,3748,3747,1423,3271,3272,3273,4130,3999,3910,3674,4059,3675,1621,1622,1623,1624,154,155,1628,1629,1630,2900,1631,1632,486,490,491,493,494,495,191,192)
										  INNER JOIN  act_base_produkty_formy as R ON R.nr_kat = A.nr_kat  AND R.lang & pow(2,0) 
LEFT JOIN act_base_tygodnie_sprzed TS ON TS.im = R.index_magick AND TS.rok >= @vyear AND TS.perms & 1 AND TS.akcja IN (0,'')
LEFT JOIN act_base_import_nadwyzki as N ON N.id_pozycji_mag = R.index_magick AND TS.rok = N.rok AND N.ilosc_pozostajaca > 0 AND N.perms & 1 AND N.dyst &  AND N.status = 1  AND STR_TO_DATE(CONCAT(N.data_waznosci,N.godz_waznosci),'%Y%m%d%H%i') >= NOW() AND N.rozp_sprzed <= NOW()
LEFT JOIN act_menu as M2 ON A.menu_id = M2.id
LEFT JOIN act_base_cennik C ON C.im = R.index_magick AND C.rok = TS.rok AND C.tydzien_od = 1  WHERE (((A.status = 1 AND R.status = 1 AND (TS.rok > @vyear OR TS.tydzien > @vweek OR N.ilosc_pozostajaca > 0) AND TS.perms & 1 OR N.kt = 1)  AND (A.akcja_new IN (0,'')  OR '1' & 240) AND (R.tygodnie_sprzed = '1-52' OR TS.rok IS NOT NULL)))AND ( R.forma_prod  = 'półprodukt' )  AND A.lang & 1  GROUP BY R.index_magick, TS.rok ORDER BY (A.mc = '{menu.parents.1}' OR A.mc = '102') DESC, M2.iparam5, A.sequence,A.nazwa,R.sequence  LIMIT 0, 101