Unknown column 'rank' in 'ORDER BY' : /* ***  SQL zbozi v kategorii *** */
 SELECT  z.id AS id ,   (z.cena * (100-z.sleva)/100 * (1+(d.hodnota/100)) / z.baleni)  AS cena_s_dph ,
 IF (z.zakazat_nakup='n' OR z.skladem like 'skladem' ,1,2) AS ord_zakazat_nakup  
FROM
 prefix_zbozi AS z LEFT JOIN prefix_zbozi_kategorie AS zk  ON z.id =zk.id_zbozi , tmp_zbozi_fulltext_1768592069_7589 AS fulltext_results , prefix_dph AS d    
WHERE 
 z.id_obchodu='2106'  AND z.cena > 0  AND z.id = fulltext_results.id_zbozi  AND z.id IN (7087889,658834,6628917,7905227087,6767355,7084325,7905238367,7132047,7089538,6989208,6780693,7124192,659273,7905287715,7905106657,6939511,2321,7124185,7905106628,6934263,7905106666,7077111,7905106488,7049991,812134,6931995,6935621,7124779,7089260,816054,669707,7160728,669974,7905228859,7905144654,7905215451,7905237776,7180416,7905293542,6931495,6934103,6784119,6932403,6764829,6766165,7905227028,6935759,7077038,7905106577,6934259,7054925,6934291,7124732,6934017,7054760,518,6789081,7132053,7055169,7124168,7087922,7905229114,7123742,7905227095,668822,6935362,7905144598,670192,7905152472,7180351,6784107,6952874,6764847,7077126,6766672,7054908,7905152505,7077273,6935735,7077140,7905110219,7905102939,7124315,6935403,7055117,6935548,7180426,2196,7905106495,7905214222,7153742,7096157,7091767,7905227072,6695067,665303,6935223,7905106642,7905115940,7096094,6934159,7089233,657574,7124678,657873,7123745,6934429,7124402,6935658,658753,7905115671,6935320,718,7132645,6695030,7905164836,7905157058,7132122,7905237783,7055234,7905110231,7160740,7123976,668871,7160715,7905228437,7905157023,6784751,7077340,7905164844,6738220,7905287711,727865,6764800,7077345,6764951,7089180,7077246,7054939,7905106544,7153766,7905215459,6934450,7124759,6935424,7055250,7905115679,7054852,7905144686,7055112,7905243308,7905107504,661682,7905110223,661263,7087953,6766129,7132628,6935610,7124335,7905157028,7055284,6764674,7160768,661248,6695819,7905215281,6788358,7905229514,7905257269,6739008,6768329,7905227354,7180151,7905293503,6764820,7089537,7905257282,6934217,7077304,7905106568,7096079,6934455,7905115782,7124717,6935530,6792367,527,6789078,7077133,7055154,7905188308,7087897,7905229476,7132044,7132123,6784057,7078125,6764777,6780701,7180409,6989205,7905237804,6767357,6764863,7077118,6764920,7054899,7905152512,7077263,6935729,7905287744,7905106694,6780778,7124300,6934083,7055090,6935557,7124132,669741,7132660,7905214214,7153728,7905107501,7160798,7905227064,6784758,7905164782,756846,913,6928445,7096107,7905157047,6939500,7089558,7124431,657891,7054694,6764407,7124416,6935646,7905293500,6924923,7077138,7161097,7124766,2315,7905257275,6989245,7088004,6934173,7055221,7124096,7087935,658567,7905215711,7085464,6695122,6787317,7905107506,7096092,6764277,7077396,7905157052,7089103,6764794,7905144626,6764958,7089171,7077143,6989314,7905106533,7153757,6934257,7132061,7124731,6935419,7055197,7905238396,7054950,7123766,7055103,7905243298,7085469,7905288195,7132646,7905227055,6784027,7078143,6695046,7123723,6935247,6935387,7905157014,7905164811,7905237773,6783081,658921,7054705,7077371,6932416,6935682,756137,6785076,7089150,6935315,7089523,7905227367,6784111,1775,6764811,7049989,661735,7089194,7077292,6738925,7905106559,669666,7170158,7905144615,7124701,6935520,7055271,7905115690,373,6587632,7055141,7905243323,7087902,664037,7089105,7124137,7905107442,7078151,7905215436,6766168,7905215712,7905238389,7123783,7905154470,7077047,6764917,6764396,6939514,7180391,7905107367,7905106587,7905287735,7905106678,6695217,7905106481,7059478,6935396,7084338,6935633,7124797,7905214202,7153731,7905110210,7160787,7180413,988176,7905157032,7905157056,7077271,7905226894,6934052,7089536,7077383,7905107484,7124420,7905257277,6939496,7905106377,7124408,6935692,6932397,6935755,7077102,7905107479,7124752,7905238983,7054767,6637910,6789069,7905106687,7059502,7123970,7087936,669626,7905106372,7096191,6935214,7164503,7905237762,7055207,7091754,6989211,6989302,7180357,6764846,7905144622,6764944,7089162,7077059,6932375,7905106519,7153748,7905107453,7905152482,7124703,7124117,7055148,6935534,7054954,6938511,7059483,7160772,7087868,6784770,7905287982,7905227046,7132025,7078129,6766169,7089572,7905228870,7905238380,6931505,7089235,1768,6934107,764759,7123759,6934310,7905115686,6935680,6935220,7089561,669468,669742,7905115901,6637905,7089200,6935574,6935707,7905289255,7055261,7124039,7160759,669948,7123779,7180481,7054788,7124773,6935428,7055255,6934010,7132643,916,7055131,7905243313,7087899,664018,756265,7153682,7905107439,7084307,6784120,7077261,7123778,6989204,7091759,7124189,6764835,392,6764401,6939524,7905164818,7124176,7905106512,7905287745,6720342,7077107,7905106490,7905157037,986184,7055293,6935628,7124786,7096083,6934164,7905115790,7160735,669968,7905215723,7905144659,7054870,739,7054822,7905157045,6788355,6935205,7905115667,7180392,6764831,7164827,6931469,7123726,6738992,7905106582,7153707,7054930,6934170,7124739,658382,7054769,774253,6789025,669735,7055199,6932381,7087949,7905229548,7905115661,7905227089,7054730,6935361,7905215445,670199,7905237800,6785024,6932390,7905154492,6764854,7905228945,6766670,7054913,7905164823,7077278,6935736,7077083,7096160,7905287802,7124326,6935407,7055122,6935543,7180433,669754,7905106500,7905214228,6934442,7096166,7905106351,7905225003,702841,7077430,7096070,657849,7905115666,7096116,6935255,7089218,657572,7124684,7181207,7123750,6934301,756292,6935665,1930,6781423,7123978,659926,7905106506,668819,7132635,2364,756293,6696270,7055243,7905107466,7160746,669868,6720339,7089097,6928443,7905102934,6932850,6935310,6780698,823675,6784742,6952873,6764807,7905157039,6764930,7089185,7077251,7077258,7905106549,6934140,7905115663,6935344,7905156153,7089101,7905106676,7905102946,7905106661,6939507,7077367,7089543,6935684,7170161,7905107478,7077115,661266,7089110,657785,6935702,6935615,7124784,6768602,7055289,7905106650,7160724,661278,7170164,7905144650,7905115932,819856,7905115930,6989322,6931488,7905227372,7905157015,7905152491,6764907,7089147,7905110251,6935765,668959,7905106573,6739005,7054921,7905288955,7124726,6935526,7054836,658278,6789077,7905107480,7055164,7905286221,7087883,7905229080,7905226918,7905227091,7905107446,657596,6642225,7077389,7087981,433,6952868,7091764,6764869,7132036,6766675,7054904,7905238986,7077265,7905106629,7905287750,7905152499,7054827,7124314,7124109,7055095,6935552,7180429,657595,7905106674,7905214198,7153738,7905107460,6935705,7905227069,6932810,7905110298,6935224,816028,6788369,7077364,7905226899,7089225,827519,7124674,657886,7905110235,6934294,7124399,6935652,662132,827579,7089102,7905152516,7124774,660890,7077328,7905293344,7087947,6932415,7055230,7905110227,7160737,7180380,6768789,7087870,6935209,1176,6784097,7905257292,6784089,7905293101,7905287808,810210,6764799,7905144630,6764954,7089176,7077242,7054935,7905106539,7153762,7905102927,7054783,7124747,6935422,7059493,7905115675,7054850,6766149,7055108,7905243304,7085474,7905155596,756298,7905227083,6784033,7084312,988130,669663,7905107448,980309,7905288093,6935594,7124331,7180396,7055273,7096176,7160764,669942,6764291,7905144669,669802,6767519,7089525,7905152476,6788363,7905110269,6784121,923,6764903,7905257286,657862,6934220,7077297,6935316,7905106564,7905288151,7096100,7905115777,7124710,6935523,7055279,910,6935215,6780780,7055146,7905243328,7087890,664046,7905237759,670173,6784024,7078145,6768392,668978,7054775,7905106367,7905237803,7905154478,7077052,756274,6764923,6939532,7180390,7077093,7905106625,7905287740,7905152504,661391,7905288044,7055086,6935559,7160718,6935638,1053477,7905214207,7153721,7905107497,7160792,7905227060,7905257266,7180119,6784018,7132120,7905216879,6931786,7905215716,7089153,6934046,7124427,657880,7054715,7905106382,7124414,6935695,6784124,6935753,7077134,7161096,7124760,7132050,7054752,669577,7089099,7905216252,7055217,6932414,7087930,1193699,6695162,6766682,7905156143,2059,7905106386,7055212,6931511,6935372,6935218,7180363,6764789,7905144636,6764940,7089167,7132042,7077322,7905106527,7153753,7170157,7905107505,7124718,6935416,7055161,7905238392,7054952,6938520,7059488,7160770,7085451,7905293541,7054780,7905227053,6934071,7077431,988146,7123741,7180385,6935378,7124104,6989308,7905293511,669778,7905106662,7054700,6934315,7124100,6935655,7905293505,7089565,7905225009,661239,7905115903,6764809,7905164788,6764928,7089190,7077288,7077313,7905106554,6934145,7905157048,6934817,7124695,6935432,7055267,7905115687,7124187,814116,7055136,7905243318,7087880,7905215633,6934081,7153684,7905107441,7078158,6766285,7077327,6766220,7077416,7160707,7905152495,6764840,816031,6764406,6939529,7905115774,7905115672,7905106592,7905287731,657068,7905106667,7905106390,7059470,6782970,7055298,6935624,7124792,7160777,7132124,7905110211,7160783,661253,6784014,7905144643,7164821,7905107482,7905164789,7905228443,7087993,7153743,7096102,856464,657900,6939554,7905106373,7123732,6935687,657781,7153712,6932367,7077068,7124746,710905,7054764,2186,6789022,7905227375,7059498,7123966,7087939,7905214044,7096075,7096183,695570,7164499,7905226121,7905215713,6780784,657798,6931498,756262,6764845,7905144620,6764932,7089158,7905152509,7077283,7905106516,7077142,7905107472,7905228435,7124690,6935414,7055127,6935538,6932742,6938499,7161701,7905214234,7180420,6768791,6935712,7905227038,6764292,7084302,6934079,7905293495,7181208,825602,6784762,7089223,1767,7124689,764765,7123755,6934306,756285,6935673,664623,7089571,662075,1089,7905115896,756142,7054955,6935570,7124133,6931789,7055248,7905164799,7160751,669921,6766281,7089114,7180369,6935204,7180412,6935314,6934225,7905257724,7905156162,7905156151,7055113,7905243309,7087891,6787343,6628918,7905215655,7905107435,7078135,7905216221,7132017,6784117,6989207,6934222,7124213,6931973,7077090,7905106659,6939520,2322,7124186,6935732,6932364,6738993,7089527,7077113,7905106485,7905164821,814032,6931996,6935618,7124781,7089261,657575,7905115789,7160729,669983,7123973,7905144655,7180405,6934102,7180443,6931787,7164495,6934106,6783770,7905164833,6764827,6766166,7132127,6935760,7905110297,7905106578,7153703,7054926,6934176,7124733,6934018,7054738,685,6789082,7132054,7055170,7905164803,7087925,7905227382,7089152,7905154728,668870,6935358,6764775,670193,7905214186,7180352,6784108,7905287935,6764842,7077128,6766673,7054909,7123763,7077274,7905106634,7077087,7905110220,7905157029,7124316,7124113,7055118,6935547,7180431,669752,7905106503,7905214223,6934437,7096158,7091768,7905227073,6766229,665304,6934062,7905106643,7905115664,6785023,6934160,7180406,827527,7124679,657875,7123746,6934298,7124403,6935659,668952,6932371,6935322,677669,7905106361,6581285,7905164835,816029,657617,6788991,7055235,7905110232,7160745,2145,6767356,7084336,7905228438,7905157021,6934150,7077341,6931513,823676,7905225006,668934,6764802,7132039,6764953,7089181,7077247,7054940,7905106545,7153767,7905115662,6934447,7124761,6935425,7055251,7905115682,7054945,658602,6935683,7905107477,814131,7905110224,661269,7089106,6695070,7905110236,6935611,7124336,7087722,7055285,7905228366,7160754,661260,6768319,7905144644,7905152530,747690,6934163,6739009,6768330,7905227362,7180152,816034,6764819,7089146,7905215439,6934218,7077343,7905106569,7096080,6934452,7905115783,7124719,6935529,6792368,691,6789079,7905115934,7055155,7905188309,7087896,7905227033,7132043,670051,7905107444,7087895,734031,6780779,7905214191,6935376,7123775,7905154484,6764865,7077119,6764921,7054900,7905238988,7077264,6935730,7905287746,7905216244,7905110241,7905115772,6637901,7055091,6935556,7905215632,669743,7905106352,7905214215,7153723,7905107502,7160799,7905227065,6784759,7078121,662663,657751,6788367,7096106,7087995,6939503,7089552,7124432,657893,7054698,6764671,7124417,6935647,664681,7089559,7132041,657846,7124768,2318,6931994,7905293499,7088006,7089531,7055222,7132059,7087920,756275,6934266,7085465,6695123,2163,7180348,6932377,7077039,7077397,7905257287,7077080,6764795,7905144625,6764961,7089172,7077146,6989316,7905106534,7153758,7905102926,7132064,7124735,7124121,7055201,7905238397,7054848,658591,7055104,7905243299,7085478,6696617,7905214240,7905227079,6784029,7078142,978318,7123724,6784099,7077408,7905156150,7905164809,7905237778,669782,658922,7054706,7077376,7124033,6935208,7905144664,756139,7905216228,7123974,6935311,7905157013,7905227368,7905152489,922,6764813,829545,661736,7089195,7077293,6935317,7905106560,669621,6738999,7905144609,7124704,6935392,7055275,907,7132652,6587633,7055142,7905243324,7087912,664062,7170160,7905152967,7905107443,7084315,7905157054,7905216629,6931471,7905238390,7123784,7905154486,7077048,7089526,6764397,6939515,7180387,7905107364,7905106586,7905287736,7905106679,6696266,7905106482,7055082,6935561,7085467,6935634,7124798,7905214203,7153732,7905216248,7160788,661292,988177,7096085,7905152527,7077092,7055179,6764784,7164817,6939499,7164815,7124421,7905257276,6939497,7905106378,7124409,6935690,6935011,6935756,7132040,6934829,7124754,7905238984,7054748,6637912,7087874,7905106688,7059503,7123971,7087938,6764916,6938494,7084330,7905289081,7164504,7905288138,7055208,7091755,6989209,7132049,7180361,6764858,7905144623,677676,7089163,7077060,7077317,7905106522,7153749,7905107454,7905152481,7124705,6935413,7055149,6931558,7054844,6938512,7059484,7160773,7087869,7905293539,7096167,7905227047,6934067,7078128,988141,6934994,7905228871,7905238381,7905238372,7089236,526,669766,764761,7123760,7905259225,6989318,6935672,658593,7089556,669467,669749,7905115908,6637906,7132651,6935575,6935703,7905243296,7055262,7096170,7160760,669896,7905288152,7054789,7124777,6935429,7055256,6934011,7132644,519,7055132,7905243314,7087898,952,756264,7089546,7905243290,7084306,7905102941,7077337,7180472,6935375,6931500,7905287728,6764836,2270,6764402,6939525,756301,7124177,7905106524,7905287752,747713,7077386,7905106491,7055074,906965,7055294,6935629,7124787,7096084,6934165,756268,7160779,669982,7905215724,7905144660,6695031,7905157036,7180371,7132034,7905156140,657697,7905226900,7132024,6764833,7164828,6932355,7123727,7077417,7905106583,7153708,7054931,7124165,7124740,7905238303,7054745,2183,6789026,669737,7055200,6932418,7087932,664039,7905215460,670153,992029,6935364,7905215446,670197,7905237801,7905238378,6934180,7905288144,6764849,7905228863,6766671,7089151,7905152511,7077279,7905106639,7077084,7096161,7905243292,7124324,7124115,7055123,6935542,7180438,669755,7132640,7905214229,6934443,7905102944,7132627,7905225004,702843,7077427,7905107361,668943,7181196,7096111,6932391,7089219,657566,7124685,657877,7123751,6934431,756280,6935666,7905293338,7905288142,7905156155,661168,7905106622,1038119,7132636,6935564,7124129,7905293508,7055244,7905107467,7160748,669885,6934179,7088007,7054718,7905102929,6932396,6935339,6780700,823670,6934078,7096098,6764899,756278,6764931,7089186,7077252,7077305,7905106550,6934141,669662,7905107450,6935345,6952789,7124190,6934821,7180368,7905106653,6939508,7077377,7124182,6935739,7905215289,7089528,7077116,7905227043,7089202,657786,6935700,6935616,7124789,7089252,7905152490,6989303,7160725,661288,7170165,7905144651,7905115942,819859,6784098,661913,6931490,7905227373,7905227032,7905152517,6764823,668719,7905110252,6935767,6766282,7905106574,6738994,7054922,657750,7124727,6935394,7160720,6637909,6789084,7905216238,7055165,670017,7085449,664048,7905152520,7905227092,7905107447,6785025,734026,670187,6767350,7905215441,7905226893,6933046,6764870,7077122,6766676,7054905,7905238987,7077266,7905106630,7905287751,7905110216,6934093,7124311,7124111,7055096,6935551,7180430,6934445,7124128,7905214199,7153739,7905107461,7905102945,7905227070,6695064,7905110619,980296,7905293501,7905157705,7096093,7905228860,7089226,657581,7124675,657887,7054713,6934295,7124398,6935653,664380,827573,7180381,6785226,7124775,662171,7905106671,814135,7054835,7089541,7055231,7905110228,7160741,7905257284,6695121,7087871,7180401,6788353,6784744,7905257293,7091757,7096095,7164814,6768551,6764873,7905144631,6764959,7089177,7077243,7054936,7905106540,7153763,7905102928,7054784,7124749,7124123,7059494,7905115683,7054947,668979,7055109,7905243305,7085476,7905155594,756299,7905227084,6784034,7077446,6785071,661243,7905115902,6581290,7905288097,6935607,7124332,7180393,7055274,7096177,7160765,669945,668831,7905107486,6766130,6934100,7905106652,6934262,6768325,7905227352,6932847,2337,6764815,395,7905216667,6934214,7077300,7089574,7905106565,669711,7905293494,7905115778,7124712,6935525,7055280,924,7905288917,659830,7055151,7905243329,7087886,7905227628,7905237772,670171,6784054,7077428,734035,980313,7055182,7905216242,7905257289,7905154482,7077053,7905157042,6764924,7054896,7905152510,6934290,7905106626,7905287741,7905106691,6764276,926,7055087,6935400,7160719,669739,7089575,7905214211,7153722,7905107498,7160793,7905227061,6784113,665302,6768317,7132022,7181197,7124029,7905107493,7089154,6781845,7124428,657881,7054716,7905106383,7124412,6935696,6780696,6935750,7077135,7905156156,7124762,7132051,7054753,659115,7088003,7905216253,7055218,6932412,7087934,1169,6934161,6766683,7905157010,2060,7905237797,7055213,7055173,6935369,6935219,7180365,6764791,7905144634,6764941,7089168,7077073,7905107491,7905106529,7153754,7170156,7905152502,7124722,7124119,7055162,7905238393,7054846,6938508,7055100,7160771,7085452,6738525,7905144606,7905216233,6934073,7078139,7096071,7905216224,7905214185,7905238382,7124105,6989309,7905293518,669770,7905106654,7054701,7905286158,7905164812,6935663,2274,7089566,7905228861,7905156163,7905164813,6764810,7160704,661732,7089191,7077289,7077314,7905106556,7905157017,7905215458,6934818,7124697,6935433,7055268,7905115696,7089549,662080,7055137,7905243319,7087879,664049,6934824,7180414,6599316,7078156,7089545,6739003,6928416,7077415,7123781,7180372,6764841,7905293504,6764393,6939530,7905115775,7905115673,7905106594,7905287732,7153745,627,7905106391,7059471,6935533,7180427,6935625,7124793,7160776,7132125,7905110212,7160784,661259,6784015,7905144661,7905115643,974,7905164790,7905156157,7087994,756300,6784106,7054823,657901,6939562,7905106374,7123733,6935686,7905226947,7153713,7089241,6785060,7124748,659143,7054763,2187,6789071,7905106689,7059499,7123967,7087909,7078048,7054689,7096184,6784110,7164500,7905237758,7160710,7905225000,6935388,6935211,6932357,6764856,7905144618,6764933,7089159,6934434,7077284,7905106517,7153744,7905107473,7905152486,7124692,6935411,7055128,6935537,6932741,6938503,7059480,7905214235,7180422,6768792,6768441,7905227039,6766232,7077434,6772293,669627,7181209,657568,6784764,7089214,7089140,7905164834,764764,7123756,6934307,756286,6935676,930,7089554,7132732,1096,7905115906,6637903,7054956,6935571,6935640,6934096,7055258,7905164800,7160753,669924,6768324,7087913,7180156,6935207,7180415,6935333,7905157053,7905227364,7054853,1038125,7055114,7905243310,7085468,661508,6943055,7905227088,7905107436,7078130,6784016,7132048,7055180,7077401,7905152529,7124193,6934283,7905102947,7905106660,6939521,756303,7124179,7905106637,7091756,7905107433,7905154469,7905157019,7905106486,7180353,6768547,7055290,6935619,7124782,7089573,657573,7905115791,7160730,669966,7905215720,7905144656,747699,7124160,6788356,6933998,6695214,7905288157,6934226,6739013,6764892,6784772,7096077,6935761,7905152475,7905106579,7153704,7054927,657607,7124734,6934019,7054761,686,6789083,669732,7055171,7905164804,7089112,664021,6738988,7054824,668869,6935363,6738991,670195,7905237787,669688,6932387,7153696,6764853,7153716,6766674,7054910,7123764,7077275,7905106635,7077139,7096155,7161056,7124322,6935404,7055119,6935546,7180436,669750,7905106496,7905214225,6934439,7096162,7905110272,7905227075,6766230,665295,7096068,657851,7180473,6989212,7180444,7905215452,827534,7124680,657872,7123747,6934299,6935713,6935661,522,6932372,6935323,793,7905106362,2326,7905164837,1038108,7132642,6788992,7055237,7124028,7160742,669864,6785068,7084335,7164492,6932807,6932385,6933997,6931512,823672,7096069,844,6764897,7077109,6764956,7089182,7077248,7054941,7905106546,7077086,7905102931,7054785,7124765,7124124,7055252,7905115674,7077366,7124035,6935650,669488,7905293346,7905110225,661240,7089107,6637907,7905110237,6935612,7124337,658845,7055286,7905107490,7160755,661270,6768320,7905144645,7096101,659171,7180454,6739011,6768546,7905227358,7180153,816035,6764821,680,6934147,6935764,7077255,7905106570,7905102925,6934453,7905115784,7124720,6935528,6792363,692,6789080,1948,7055156,7905188310,7087892,664036,6931504,670052,6784072,7905115670,7905287709,6784657,7905214192,6935382,7089524,7905154485,6764866,7077120,6766679,7054901,7180389,7077311,7905106623,7905287747,7905216245,7905110242,6935715,6637902,7055092,6935555,6782271,669745,659139,7905214216,7153724,7905164830,7087921,7905227066,7180349,7161669,756143,914,7905115933,7096108,7087997,7123739,7089553,7124671,657894,7054710,6764672,7124415,6935648,662134,7089562,6780781,6696650,7124769,1161464,7132052,6803215,7087945,7905152494,7055223,7132060,6989248,6739002,6934212,7085466,6695124,6935019,6782968,7091770,6784088,7905238386,7905257288,664069,6764876,7905144627,6764947,7089173,7077239,7054932,7905106536,7153759,7905288153,7054724,7124737,6935420,7059489,7905238398,7054949,6784134,7055105,7905243300,7085480,662239,7905215444,7905227080,6784030,7077442,6934050,7096088,7164493,7905238383,6931503,7905164810,6933088,669779,657885,7054707,7160761,669919,668829,7905144665,6780684,6785077,6934168,6935343,6788359,7905227369,7905102919,657807,6764814,669484,661730,7089196,7077294,6935338,7905106561,669718,7054832,7905144611,7124706,6935521,7055276,657272,7153686,6935221,7055143,7905243325,7087884,7905115945,7164506,7905144607,6784020,7077423,7905102920,6932373,6931472,7905106363,7161060,7905154476,7077049,756269,6764399,6939516,7905164822,7905107368,7905106588,7905287737,7905106680,756156,7905106483,7055083,6935398,7905238990,6935635,7124302,7905214204,7153733,7905107494,7160789,661294,7905257262,6934250,7905152525,7087894,7180455,6767714,7905107485,7123736,7905257250,7124422,7905257278,6939498,7905106379,7124406,6935689,6931501,6935757,7077103,7054683,7124756,7905238985,7054749,6637913,7087875,7905106690,7059504,7905164802,7087926,661170,6938495,7084331,6784138,2009,7905257271,7055209,7905214187,7077395,7123780,7905216226,6764859,7905144632,6764945,7089164,7077062,7077319,7905106523,7153750,7905107455,7905152488,7124709,6935415,7055150,7091458,7054843,6938513,7059485,7160774,7084337,7905293540,7905214238,7905227048,6934068,7078149,6784039,7905243330,6785072,6935355,7091761,7089237,525,669764,764762,7123761,6934312,6989319,6935674,658597,6931992,668720,1100,7905115905,662439,7132637,6935577,6935704,7905243295,7055263,7096172,6934142,669695,7054791,7124691,7124126,7055257,6934014,7132657,662077,7055133,7905243315,7087877,664064,756263,7905287717,1073037,7078152,7161059,7077323,665249,6935381,7160705,7905287727,6764837,2271,6764403,6939526,756302,7124173,7905106535,7905287753,747714,7077387,7905106492,7055076,6724912,7055295,6935630,7124788,7905216222,7905157035,6932363,7160780,669985,7905215726,7905144639,6784058,7905157038,7124217,7905102940,7905156141,7091760,7905226122,7132023,657897,7164829,7905225130,7123728,7905164793,7905106555,7153709,7096081,7077054,7124742,2194,7054770,2098,6789027,6934264,7055202,6932419,7087951,7905286222,7132030,7905243293,695481,6935366,7905288150,669723,6768552,7905238379,6934211,6931470,6764844,7905144616,6764935,7089155,7180388,7077280,7905106513,7077085,7096165,7905152493,7124325,6935408,7055124,6935541,7085459,7905107487,7091763,7905214230,6934444,6934000,7164823,7905227078,7096115,7077422,6781461,657848,7180379,7096114,6932812,7089220,462,7124686,657878,7123752,6934302,756281,6935668,7905293340,7905288141,6934256,659393,7905106355,6764973,657615,6935565,7905164807,7096082,7055245,7905107468,7160749,669886,7905257249,7088011,6928444,7905106668,7164818,6935336,7096097,823671,7905156154,7905156146,6764805,756279,6764925,7089187,7077253,7077306,7905106551,7078137,6934077,669518,7905152518,6935347,6780691,661651,6934822,7905287712,7905106655,6939509,7077368,7124183,7905106595,6952875,7905106664,7077112,756305,7160733,7905238368,7132638,6935617,7124794,6772768,7905164838,669708,7160726,670000,7160717,7905144652,7905238370,819853,6931497,7077363,6931492,7905227374,7096072,662422,6764825,658245,7905110253,6935768,7905107488,7905106575,7905215449,7054923,689,7124728,6934015,7160721,658473,6789085,7905288143,7055166,6786488,7087872,1592,7054686,7905227093,7905157057,657797,729580,670189,7132027,658552,7905228442,7905156158,6764871,7077123,6766677,7054906,7054778,7077268,7905106631,7077081,7905110217,7905157044,7124312,6935402,7055097,6935550,7180423,658561,7132647,7905214220,7153740,7905107462,6768442,7905226172,988148,7124163,6696609,7905106640,7905115939,7123703,6928420,7089227,659531,7124676,657871,7123743,6934296,7124401,6935654,2202,827582,7905228428,668638,7124776,661915,7905164801,816025,7054834,7905152519,7055232,7905110229,7160738,7905228947,6952877,7180440,7180445,666730,6784747,7905257294,7091758,6782855,7123964,6784013,6764796,7905157030,6764963,7089178,7077244,7054937,7905106541,7153764,7905157043,6934448,7124753,6935423,7059496,7905115676,7054851,661573,7055110,7905243306,7085471,7905155597,7132045,7905227085,7905107369,7905115685,661249,7905115907,6581291,7132632,6935608,7124333,7123980,7055282,7096178,7160766,669951,668884,7905115767,7164487,756256,7054722,6934251,6768327,7905227353,6932848,747709,6764817,679,6787093,6934215,7077301,7905106566,669717,7905107489,7905115779,7124714,6935532,7055281,1185663,7132631,6943056,7055152,7905215455,7087908,664050,7905157049,670180,6784055,7078126,6764772,657285,7087992,7905216243,7905157009,7905154479,6764780,7153715,6764918,7054897,6931977,6934289,7905106627,7905287742,7905106692,7905293497,7174190,835,7055088,6935558,7089547,2195,7132659,7905214212,7153720,7905107499,7160794,7905227062,988147,6934495,6952788,2341,6767348,7905293352,6788364,7164832,6786674,7124429,657882,7054692,7905106384,7124410,6935697,6784126,827570,7077136,662767,7124763,7905259689,7054754,659116,7088005,7905152501,7055219,7905164805,7087943,1170,7905237780,7180442,7905157012,2011,6784100,7055214,7055174,6935385,7905214197,7180367,6764792,7905144637,6764942,7089169,7132057,7905110249,7905106530,7153755,7905215457,756276,7124724,6935417,7055163,7905238394,7054951,657464,7055101,7905243303,7085450,6934972,6934210,7905237805,6934074,7078154,6934149,7905216225,7905237789,6935379,7905164796,6989311,7905293538,669769,657888,7054702,7905286159,7905110245,6935669,7077338,7089567,7087985,7905110255,7905156164,7905156148,6764812,7132035,661733,7089192,7077290,7077315,7905106557,677671,7905102933,6934819,7124699,6935434,7055269,7905115688,7905238981,814117,7055138,7905243320,7087882,7905237644,6934826,7124134,7905243291,7078146,6933996,1311,7123963,7077400,7160708,7164834,7077044,756327,6764394,7054895,7054776,7905215450,7905106593,7905287733,7905164831,1081,7905106392,7059476,6935395,7180428,6935631,7124795,7905214200,7153729,7905110213,7160785,661267,6766278,7905144662,7905214194,7905227031,7905215717,6785230,7055184,7077381,7905228440,7905154493,657903,6939576,7905106375,7124404,6935693,666704,7153714,7905259663,7905110233,7124750,659140,7054766,7905257949,6789073,7905152492,7059500,7123968,7087940,6771201,7054690,7096187,6771202,7164501,7905237760,7089100,7905238373,657594,6935212,7905157024,6764857,7905144621,6764934,7089160,756294,7077285,6935725,7153746,7905107474,7905152479,7124696,7124116,7055129,6935536,7160716,6939501,7059481,7905214236,7180425,6784129,7905257273,7905227044,7123972,7077421,6581283,7096090,7905228862,657588,6931507,7089215,7089141,7077077,764758,7123757,6934308,756287,6935677,668975,7089555,7123962,1098,7905115898,6637904,7054779,6935572,7132119,7153681,7055259,7124036,7160757,669925,6928419,7905115946,668886,7905293342,7905287716,6935312,7055253,6934001,7054944,814045,7055115,7905243311,7087901,7905215440,6628916,7905229261,6784070,7077443,6784025,7077259,7055181,7077399,7905157005,7124188,6931975,2148,6764398,6939522,756304,7124180,6935734,1133989,658848,6720340,677670,7905106487,7180354,814036,7055291,6935626,7124783,6932376,7905157033,7905115786,7160731,669975,7087983,7905144657,7054918,7905216217,6952870,6934065,6934137,7905188307,6934265,658752,6764830,7164825,7054725,6935763,7905107508,7905106580,7153705,7054928,6934169,7124736,6934022,7054739,668948,6789023,669734,7055172,7124169,7087933,7905288241,6738989,7905216229,756158,6935359,7054818,670196,7905237788,669686,6932388,6932366,6764848,7153719,6766668,7054911,7054777,7077276,7905106636,7905257267,7096156,7180410,7124319,6935406,7055120,6935545,7180437,669751,7905106504,7905214226,6934440,7096163,6931985,7905227076,695607,665305,7905216220,657850,7905115665,7077413,7905226892,7089216,827523,7124681,657876,7123748,6934430,756290,6935662,628,657947,6935324,794,7905106509,2328,7124301,6659513,6787287,6696606,7055241,7123769,7160743,669867,6785069,7084334,7055177,6934099,6932849,6766287,7089142,823673,7180149,747707,6764803,7077088,6764957,7089183,7077249,7054942,7905106547,6934138,669692,7054786,7124767,7124125,657890,7054708,7077369,7124034,6935660,756258,7905293347,7905164798,661265,7089108,668875,7132650,6935613,7124308,658846,7055287,7077357,7160756,661277,7123773,7905144647,7905115931,659172,6784035,6764299,6931485,7905227370,7180154,7905293507,6764822,659831,7905227027,6935762,7077256,7905106571,7905102924,6934454,7905289271,7124721,6935390,6792364,1193700,6789075,7181211,7055157,7905188311,7084333,7905227384,7905102942,7905227057,6784076,6935373,7905228427,6934101,7905237770,6935383,7132029,7905154467,6764867,7905106669,6766680,7054902,7096154,7077312,6935731,7905287748,7905216246,7905110243,7124303,7124106,7055093,6935554,7180419,669746,7091769,7905214217,7153736,7905164829,7124260,7905227067,7180397,6768760,6768785,662311,6784112,7096110,7087998,7905107483,827571,7124672,657895,7054709,7905152474,7124418,6935649,662084,7089563,6780782,6928474,7124770,669485,7905106356,7905188314,7087946,7180376,7055224,7905110226,6989247,934,6934213,7085456,6694857,6928441,6784093,7091771,7905225002,7905106368,7905107476,668938,6764798,7905144628,6764950,7089174,7077240,7054933,7905106537,7153760,6934091,7054781,7124741,6935421,7059490,7905238399,7054849,659942,7055106,7905243301,7085479,851339,7905115660,7905227081,6784031,7078141,988127,7096089,7164494,7905238385,6695177,6989310,827588,669776,7055264,7096174,7160762,669922,669805,7905144668,6780685,6637914,6934174,6935327,6788360,7905227363,6932845,532,6764881,727866,661731,7089197,7077295,6935335,7905106562,669713,7096066,7905144612,7124707,6935522,7055277,6928481,7905238287,6935222,7055144,7905243326,7087888,7905227303,7054821,7905144608,6784022,7084311,6764778,663786,6934277,7905106365,7160709,7905154475,7077050,756271,6764391,6939517,7905152508,7905152477,7905106589,7905287738,7905164832,6766235,7905106484,7055084,6935560,7905238991,6935636,7905110240,7905214205,7153734,7905107495,7160790,669999,7905257263,6933128,7905152526,7132065,7905216880,6764782,7905107492,6939506,7905257251,7124425,7905257279,7054711,7905106380,7124407,6935694,6784123,6935751,7077095,6934827,7124757,7905259572,7054750,1066766,7123768,7905216250,7055215,6932413,7087927,660725,7096074,7085458,6784776,657275,7905287807,7055210,7905214188,7077394,7905287719,7905216227,6764860,7905144635,6764946,7089165,7077063,7077320,7905106525,7153751,7905107456,6764774,7124711,7124118,7055159,6989317,7054953,6938514,7059486,7160775,7085453,7905110239,7089550,7905216066,6934069,7084313,6784041,6934146,7089138,6935356,7087999,7089238,694,669761,764763,7054699,6934313,6989320,6935678,6934287,7096180,7905157018,1101,7905115900,6695060,7153700,6935592,6935711,6934094,7077307,7905106552,6934143,7905102932,7054792,7124693,6935431,7055265,7905115681,7087907,814046,7055134,7905243316,7087876,7905286196,7132031,669984,6934085,7078148,6766135,7077325,7055176,6935377,7096103,7905152497,6764838,2362,6764404,6939527,7077027,7124174,7905106585,7905287755,659392,7077388,7905106493,7055077,668535,7055296,6935622,7124790,7905216223,657577,7905102938,7160781,661241,7905215727,7905144640,7055186,7905228558,6785074,7905152523,6932383,658731,7905109971,6934253,657898,7164830,7905152473,7123729,6935685,2338,7153710,7905288154,7077056,7124744,371,7054746,6784131,6789018,7160712,7055203,6932417,7087950,6780365,7096073,7905227035,695568,7164497,7905154473,7905286412,980295,6935351,7905225007,6932362,6764855,7905144619,6764936,7089156,7905164825,7077281,7905106514,7077099,7905107470,7905228433,7124330,6935409,7055125,6935540,7087873,6938501,7132630,7905214231,7087906,7905228865,7164822,7905227036,6695125,7084316,6764771,668944,7181199,6932565,6932392,7089221,7180411,7124687,657879,7123753,6934303,756283,6935670,7905293341,7089569,6934254,660039,7132629,6724657,7905214239,6935568,7132639,7124167,7055246,7905257283,7160752,669894,6768318,7088009,6931468,1112,7164819,6935331,7905157016,7102759,7905156160,7905157007,6764808,7905293510,6764926,7089188,7077254,7905227086,7905107434,7078136,747702,6784774,7905152524,6935348,6780692,7124191,6934285,7905287714,7905106656,6939510,7077370,7124184,7905106591,7905106673,7905106665,7077117,829546,7089551,7905238369,7153701,6935620,7124702,6931777,7160732,669706,7160727,669965,7905215715,7905144653,988175,7905164808,6931496,7905144605,6931493,669684,6766132,6935342,6764826,678,7905227029,6935769,7905107507,7905106576,669714,7054924,6764673,7124730,6934016,7054737,613,6789086,7089104,7055167,7180402,7087942,7905233570,7054688,7905154729,6784048,2200,7905289256,670190,7132028,7905107510,6764295,6934080,6764852,7077124,6766678,7054907,7905164827,7077269,7905106633,7077079,7905110218,7124164,7124318,7124112,7055098,6935549,7180424,2199,370,7905214221,7153741,7905107463,7132664,7905227071,6695065,720322,6696612,7905106641,6788370,7123770,6928421,7089232,657583,7124677,657874,7123744,6934297,7124400,6935657,2201,7905229243,7077057,6766277,6935352,6581284,6931981,7905293498,657616,7905152521,7055233,7905110230,7160739,7089198,6952878,6766690,6780683,7905157020,6784750,669724,7905164845,7089199,6935254,6769106,6764801,7077075,6764948,7089179,7077245,7054938,7905106543,7153765,669693,6934449,7124755,6935391,7055249,7905115678,7054946,1038124,7055111,7905243307,7085481,7905155598,669372,7089568,7905110222,661237,7089113,810222,6934209,6935609,7124338,7124026,7055283,7096179,7160767,661250,6935009,7905110209,6780688,7905229515,7054826,7905164783,6768328,7905227361,7905215442,816030,6764818,1104,6784614,6934216,7077303,7905106567,7170159,7905102936,7905115780,7124715,6935531,6792366,6952866,7905238982,7905102943,7055153,7905215456,7087904,664053,7180399,7905227041,6784056,6934601,6764773,6931502,7055183,7077409,7905227022,7905154481,6764864,7077076,6764919,7054898,6931978,6934288,7905106624,7905287743,7905106693,6739001,6934435,1935,7055089,6935401,7091762,1824,7089576,7905214213,7153727,7905107500,7160796,7905227063,7905227024,712596,661622,2342,6767349,6991642,6788366,6934221,7089557,7124430,657883,7054693,7905106385,7124411,6935699,6784125,6934048,7077137,657421,7124764,2314,7153697,821767,7088012,7164490,7055220,7905164806,7087937,7905293506,7905228943,7085463,668907,2012,6784101,7096091,7905289080,7077412,7905157051,7180366,6764793,7905144624,6764943,7089170,7132055,6989313,7905106531,7153756,669694,756277,7124729,6935418,7055196,7905238395,7054847,6739010,7055102,7905243297,7085477,7905237936,7132641,7905216230,6784026,7078153,6784043,7123722,7905237791,6935386,7905156149,6989312,7089262,669768,658920,7054703,7077378,7124032,6935675,7077339,7089544,6935340,7905238371,7905227365,7054622,1774,6764901,1193697,661734,7089193,7077291,7077316,7905106558,6934172,7905144599,6934820,7124700,6935435,7055270,7905115689,6738998,814118,7055139,7905243322,7087881,664028,7164833,7124136,6934087,7078144,6934063,700,6784047,7905238388,7123782,7089532,7077045,756249,6764395,6939513,6934433,7905288158,7905106590,7905287734,7054820,1085,7905106396,7059477,6935562,7180417,6935632,7124796,7905214201,7153730,7905110214,7160786,670002,6767496,7905144663,7905228439,669417,7905214193,6766234,7055185,7077382,7089139,7905154494,657902,7054695,7905106376,7124405,6935691,6696267,6935754,7077100,7905110234,7124751,659142,7054741,657820,6789074,7905106686,7059501,7123969,7087941,6784773,7905106371,7096189,7055178,7164502,7905237761,7055204,6784042,6989210,6989301,7180356,6764851,7180460,6764938,7089161,7077058,7054727,6935726,7153747,7905107475,7905152480,7124698,6935412,7055147,6935535,7054833,6938510,7059482,7905214219,7087905,6785075,667063,7905227045,7905115941,7077420,6784038,7124171,7905228869,7905238377,6931506,7089234,839380,7077094,764760,7123758,6934309,756288,6935679,742411,7089560,1534,657847,7905115904,662761,7905106353,6935573,6935708,7905164795,7055260,7124099,7160758,669941,7123777,7905228946,669544,6784132,7124771,6935427,7055254,6934002,6935642,1310,7055130,7905243312,7087900,7905238683,7164577,6768440,7905107437,7084309,668667,7077260,7905257272,7077398,7905157006,661650,6934284,391,6764400,6939523,7905164819,7124181,7905106518,658849,6720341,7905237782,7905106489,7180355,6587620,7055292,6935627,7124785,7905188313,7905107363,7905115788,7160734,669977,7905215721,7905144658,7054869,740,6952871,7132033,6952869,7077358,7905106672,7905106480,6764832,7164826,7905215453,7123725,7905107509,7905106581,7153706,7054929,6934171,7124738,6934044,7054744,668949,6789024,669736,7055198,7124170,7087931,664035,6738990,7905227058,756160,6935360,7905152503,670198,7905287710,669685,6932389,7905154491,6764843,7153717,6766669,7054912,7170166,7077277,7905106638,7077082,7096159,7096104,7124320,7124114,7055121,6935544,7180432,669753,7905106499,7905214227,6934441,7096164,6931986,7905227077,702840,7077452,6934076,6780694,7181194,7181213,7905164840,7089217,657570,7124682,7181206,7123749,6934300,756291,6935664,389,6787505,7180400,795,7905106510,756140,7905115773,660101,7180350,6935210,7055242,7905107465,7160744,669884,1161504,7180439,6928442,6934090,6932394,6934830,7089143,823674,7180150,6952872,6764804,7077110,6764929,7089184,7077250,7054943,7905106548,6934139,7905216218,7054787,7905106675,7077361,657892,7054691,7077372,7089263,6935667,7905215447,1931,7077114,661246,7089109,658722,6935701,6935614,7124780,6802902,7055288,7077091,7160723,661286,7164813,7905144649,7124214,659173,6784036,7905110246,6931491,7905227371,7905157055,7124215,6764824,7905293509,7905227025,6935766,7077257,7905106572,7905115669,7054920,7905288954,7124723,6935527,6792365,661374,6789076,6928171,7055158,7905188312,7084332,664044,6934051,7905227090,6784074,6935374,7054676,1954,7124172,7905293502,7905164841,7905154489,6764868,7077129,6766681,7054903,7123762,7077262,7905106632,7905287749,7905216247,7905110244,7124310,7124108,7055094,6935553,7180418,669747,7905110273,7905214218,7153737,7905107459,7905214237,7905227068,6934162,747811,6766159,662420,6788368,7905157040,7905288145,7089224,6934049,7124673,657884,7054712,6934293,7124397,6935651,662126,827577,7089540,6934482,7124772,668672,7905106357,7905293343,7087948,7054720,7055225,7124157,7160736,7905293496,668906,7087910,6694858,6933999,6784095,7905257296,7905238375,7905106369,980312,668940,6764797,7905144629,6764952,7089175,7077241,7054934,7905106538,7153761,6932368,7054782,7124743,7124122,7059492,7905287981,7054948,2344,7055107,7905243302,7085472,7905155595,7905107370,7905227082,6784032,7078140,988128,7096086,7905215437,6720213,7164489,742412,7124334,7905228368,7055272,7096175,7160763,669927,669806,7905144667,6784044,7905227030,6934178,6739004,6788361,7905227359,6932846,658472,6764816,7905257285,657858,6934219,7077296,6935319,7905106563,6934261,7096067,7905115776,7124708,6935393,7055278,909,7089201,657507,7055145,7905243327,7087887,7905229477,7905216215,670167,6784023,7077438,6931790,663218,6934456,7905106366,7905237802,7905154483,7077051,756273,6764922,6939518,7180386,7089533,6935733,7905287739,7905106683,658475,756244,7055085,6935399,7164505,6935637,899275,7905214206,7153735,7905107496,7160791,7905227059,7905257264,6764210,668660,7132118,7905287720,6931788,7905106349,7123735,7905237781,7124426,7905257280,7054714,7905106381,7124413,6935698,6780695,6935752,7077096,7160778,7124758,6934802,7054751,6935203,7123765,7905216251,7055216,6932411,7087928,1162,7905288140,6766685,7905156142,658479,7087991,7055211,6931510,6935370,6935217,7180358,6764787,7905144633,6764939,7089166,7077106,7077321,7905106526,7153752,7905107457,7077414,7124716,7124120,7055160,7905238391,7054845,6938519,7059487,7160769,7085455,7905110238,7160711,7905243497,6934070,7077418,695473,7123740,6767524,6935357,7124101,7089239,668945,669773,7905106658,7054697,6934314,7054828,6935681,816033,7089564,7905115684,7087923,7905115897,714457,369,6935593,7089189,7077286,7077310,7905106553,6934144,7905243294,7054793,7124694,7124127,7055266,6720343,7153698,661919,7055135,7905243317,7087878,664026,7096193,7054825,7905107440,7084310,7905226896,7077326,6766170,6935380,7096113,7905152496,6764839,661442,6764405,6939528,7077028,7124175,7905106584,7905287730,657067,7077385,7905106389,7055078,7124162,7055297,6935623,7124791,7132018,819854,7132658,7160782,661247,7905164792,7905144642,7055187,7905288155,7180398,7905115770,7089535,6938500,6696608,7905152522,657899,7164831,7905107362,7123730,6935688,7124031,7153711,931,7077067,7124745,658565,7054771,2185,6789021,7160713,7059497,7123965,7087924,7905288068,7054687,7096181,695569,7164498,7089529,6931972,7153679,6935349,6931499,6932370,6764850,7905144617,6764937,7089157,7905152506,7077282,7905106515,7077141,7905107471,7905228432,7124328,6935410,7055126,6935539,7180441,6938502,7905106358,7905214232,7180421,7905228864,7164824,7905227037,6766231,7084303,6695024,814133,7181203,6934432,6784760,7089222,7054819,7124688,764766,7123754,6934305,756284,6935671,1929,7089570,7905102937,911,7905115895,665247,7153699,6935569,6931984,7096105,7055247,7905237775,7160750,669914,6784037,7088008,7180155,6784133,7164820,6935329,7905157004,7102758,7905156161,7905157008,6764900,7905216237,6764927,6932618,6789052,6771079,6792359,6771069,7905229065,6771056,1603,6789049,7087944,6768584,7905215368,6771074,6771063,663250,7905238429,6766279,6789053,6771080,7905229066,6792360,6771075,6771047,657606,7905238424,7087919,7124097,670237,6771067,6771064,6738386,6771057,7160706,6789054,6771081,659532,6792361,6771071,6771060,756296,7905238425,7087918,7180408,6789050,6771077,657619,6771059,7905229060,6788180,658893,6789045,6771082,657604,6792356,6771072,6771061,756295,7905238427,6771058,659222,6789051,6771084,6792358,6771068,7905229062,6771055,1602,6789047,6771083,657605,6792357,6771073,6771062,7055195,7905238428,6771053)  
AND  ( z.cena > 0 AND  z.aktivni='y'  AND z.vypnuto='n' )  AND z.dph =d.id_dph AND d.id_obchodu='2106'   
GROUP BY 
 z.id  

 ORDER BY ord_zakazat_nakup, rank DESC, z.poradi, z.id , z.id DESC
 LIMIT 3000