42000:SELECT A.id, A.menu_id, A.nr_ref, A.distributionAL, A.vat, A.znacznik, A.znacznik_new, A.forma_prod, A.paleta, A.index_magick, A.orygin, A.grupa_kosztowa, A.sezon, A.sezon_new, A.poile, A.op_ilosc, A.nr_kat, A.ilosc_w_opak, A.blokada, A.ts, A.tb, A.tygodnie_sprzed, A.cena, A.cena_euro, A.grp, A.grupa, A.forma_opak, A.standard, A.grupac, A.ukryjcene, A.rok, A.wyprzedany, A.euro, A.nowosc, A.zamienniki_im, A.moznaZapytac ,R.nazwa as R_nazwa,R.lang0_barwa as R_lang0_barwa,R.gatunek as R_gatunek,R.patent as R_patent,R.licencja as R_licencja , R.zestaw_odmian, R.nowosc, R.menu_id, R.foto1, R.grupa, R.foto_label as fl, WEEK(promo_end,1) as terminp, N.status as nadwyzka, N.tydzien as ntydzien, N.ilosc_pozostajaca, IF('1' = 0,IF (max(T.upust) > 0,max(T.upust),IF(N.id_pozycji_mag = A.index_magick,max(N.procent_upustu),0)),0) as rabat, N.lt, N.tstart, N.tend, GROUP_CONCAT(DISTINCT concat(N.id,':',N.ilosc_pozostajaca)) as gilosc_pozostajaca, GROUP_CONCAT(DISTINCT concat(N.id,':',N.tstart)) as gtstart, GROUP_CONCAT(DISTINCT concat(N.id,':',N.tend)) as gtend, 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, C.tb as blokady, GROUP_CONCAT(DISTINCT concat(N.id,':',IF(N.kt AND N.id_pozycji_mag = A.index_magick,1,0))) as gkt, IF(N.kt AND N.id_pozycji_mag = A.index_magick,1,0) as kt, IF(C.cena_pln IS NOT NULL, C.cena_pln, A.cena) as cena, IF(C.cena_eur IS NOT NULL, C.cena_eur, A.cena_euro) as cena_euro, GROUP_CONCAT(DISTINCT TS.tydzien ORDER BY TS.tydzien ASC SEPARATOR ' ') as tygodnie, IF(C.rok IS NOT NULL, C.rok, A.rok) as rok, C.rok as crok, C.wnp as blokadywnp, IF(C.paleta IS NOT NULL, C.paleta, A.paleta) as paleta, IF(C.poile IS NOT NULL, C.poile, A.poile) as poile,0 as __search_priority FROM act_base_produkty_formy as A LEFT JOIN act_base_produkty as R ON R.nr_kat = A.nr_kat INNER JOIN act_base_produkty__cats as CATS ON CATS.rid = R.id AND CATS.menu_id IN (2993,173,2996,3389,3665,3306,4141,3446,3372,3368,3374,3240,2994,4076,4079,3742,1552,1536,1553,3745,3049,1537,1554,2992,3463,2929,3746,3752,3466,1535,3753,3754,1651,3137,3084,1653,2802,2948,1555,1654,3863,1557,4083,1558,1656,3864,3087,266,3955,1657,3507,2806,3139,3508,3756,2715,3181,3511,3514,267,1560,3519,3074,397,2713,1538,2809,1539,1540,3917,3091,3574,2772,1663,1664,1665,3533,4077,3534,3759,269,3536,1666,1667,418,2832,1668,3540,2833,2773,3189,3054,1542,3566,1669,1670,1671,3866,3585,1672,3761,3762,417,3605,1673,375,3763,3095,3764,1563,1543,1674,3765,3609,1675,270,2834,3012,1676,1677,1695,3766,1679,3868,1544,1680,3207,3767,1681,3768,2804,271,1565,1696,1683,3769,1684,3869,1685,3617,1545,1568,2930,3102,3620,1546,1547,3771,3772,1687,3782,272,3622,1688,273,1503,1548,2774,297,3773,1549,2742,3356,3624,420,2705,1689,1572,3777,3427,3628,1573,2775,1550,1691,2990,1692,3778,1693,1574,2704,1551,4098,4038,3950,3944,4040,2901,2947,2902,4039,3941,3870,3420,3572,3421,3288,3290,3289,3472,3790,2949,3871,2903,2908,2997,3925,3050,3324,3206,2927,2926,2909,3504,2928,3505,3506,3073,2986,3515,3291,2910,2911,2912,2952,3182,2915,3516,3807,3337,2914,2913,2999,4096,3075,1662,3183,3525,3583,3079,3076,3526,3077,3078,3292,3080,3527,1582,1585,3081,1584,1583,2916,2984,2917,2921,2920,2922,2918,2919,3131,3422,3423,3958,3810,3988,3979,3797,3796,3798,3809,3114,4105,3535,3872,3283,2923,2924,4041,3184,2978,3730,2979,3051,2980,2981,3951,3949,3942,3293,3052,3053,3928,3191,3799,3190,3295,3940,3828,2974,2975,2976,2977,3055,2972,2973,3057,3056,2971,2970,3325,3058,3255,2969,3939,3194,3195,4042,3938,3843,2955,2956,4142,2716,3200,2717,3060,4046,4045,3326,3198,3328,3284,4043,4121,4122,4120,3943,3664,3567,3256,3811,3136,2957,3360,2958,282,281,283,3795,2987,3447,2718,3108,3107,3202,3203,3204,2968,2959,2960,4044,2962,4106,2961,3061,2963,3424,2965,2966,2967,4133,3577,3578,3788,3579,3001,3002,3003,3004,3005,3006,3208,3666,3667,3668,3669,3581,3597,3309,3308,3307,3305,3926,2741,3180,2744,2745,1559,2991,2746,3338,419,3425,1576,3193,2748,3173,3593,2749,3174,2810,3426,3176,2750,2811,2751,3197,3296,3820,3893,3177,3178,4011,3179) LEFT JOIN act_base_import_nadwyzki as N ON N.id_pozycji_mag = A.index_magick AND 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() INNER JOIN act_menu as M ON CATS.menu_id = M.id AND M.parent_id NOT IN (2993,2996,157,3665) LEFT JOIN act_menu as M2 ON R.menu_id = M2.id LEFT JOIN act_base_cennik C ON C.im = A.index_magick AND C.rok = '' LEFT JOIN act_base_tygodnie_sprzed TS ON TS.im = A.index_magick AND TS.rok = '' AND TS.perms & 1 AND TS.akcja IN (0,'') LEFT JOIN act_base_upusty_terminowe as T ON A.index_magick = T.im AND T.rok = '' AND T.tydzien = '' WHERE (((A.status = 1 AND R.status = 1 AND TS.perms & 1 OR N.kt = 1) AND (R.akcja_new IN (0,'') OR '1' & 240) AND forma_prod != '' AND A.blokada = 0 AND R.perms & 1 AND (TS.rok = '' OR N.kt = 1 OR A.tygodnie_sprzed = '1-52')))AND ( A.`forma_prod` = 'produkt gotowy' ) AND A.lang & 2 GROUP BY A.id ORDER BY M2.iparam5, R.sequence,R.nazwa,A.sequence LIMIT 0, 5001