SELECT DISTINCT store.*, kv.value_txt AS store_status, brand.name AS brand, IF(store.price_curr_id>0 ,IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price) AS price_calc, 1 AS rel FROM {DBNICK}_store store JOIN {DBNICK}_topic_store ts ON ts.store_id = store.id LEFT JOIN {DBNICK}_key_value kv ON ( store.status_key = kv.key_name AND kv.key_code = 'STORE_STATUS_KEY' ) LEFT JOIN {DBNICK}_currency curr ON store.price_curr_id = curr.id LEFT JOIN {DBNICK}_brand brand ON store.brand_id = brand.id WHERE store.id IN(198236,240303,240304,240966,197995,243590,243627,243676,244908,205488,244943,245074,123811,254652,255980,259507,259508,259510,261212,261279,205539,175124,111045,266184,267827,267799,269153,272012,273143,274035,265893,276486,276774,278609,278622,259224,277949,280304,123819,116274,256852,280107,267978,267997,255714,282870,264759,255721,188226,244907,242004,244938,244942,205464,241654,244937,254484,289216,289310,278950,286172,291078,291181,291120,285778,291397,273796,291998,294472,294456,293959,293508,263141,292713,295008,295109,295775,205479,295465,295649,295573,295624,295214,295791,205399,295906,295853,296005,297561,297562,297565,131827,293005,293054,293055,293080,293081,293137,293239,293270,293350,293371,293404,293406,293434,293435,293455,293458,293523,293551,293582,293612,293671,293703,293734,293786,293818,293820,293843,293008,293032,293033,293034,293082,293109,293141,293167,293189,293190,293272,293323,293324,293459,293527,293528,293583,293616,293674,293704,293789,293790,293844,293144,299457,299463,299467,299491,299438,299455,299460,299471,299468,299473,299474,299482,299496,299503,299436,299437,299448,299456,299464,299508,299452,299487,299505,299441,299453,299507,299427,299428,299432,299434,299442,299445,299461,299484,299509,299454,299459,299483,299499,299504,299430,299500,299506,299439,299465,299488,299497,299268,124372,302133,293816,299498,302492,303618,303825,303822,303831,303833,93875,127417,150366,286625,62800,303977,89465,94515,125641,129990,178478,68327,205449,259509,267994,62785,124389,273781,58035,131736,62851,306128,305291,305284,305287,306124,280036,303102,187169,306205,62809,306126,257357,62751,62768,62762,62811,275638,65044,177174,133537,133538,133539,293757,134045,175982,149294,134531,89374,178070,264078,279920,279986,284332,141422,267993,288906,264276,263140,273784,33275,265932,267967,271660,279975,131781,295666,286718,280120,253223,62839,65024,89463,116268,280106,297737,306147,284302,62737,265775,268031,124384,141423,152465,265912,288342,245756,264076,269358,288907,244906,303100,127866,192686,308208,308209,265913,292872,303643,62791,93868,65266,65017,65019,65022,65047,65066,68310,89449,205335,205431,265753,267958,305294,269383,267984,268019,279972,279989,131802,303816,265785,275279,280121,301973,297748,308531,115206,279908,303609,281549,205337,303823,177513,65159,117012,291182,62789,62820,308907,308911,308912,308915,308919,308923,308926,308914,265788,62755,62796,62797,62724,89460,62740,62741,62775,124367,205394,308921,308917,308920,293874,62763,149283,308904,269384,293366,98896,308910,268016,269357,131801,236517,278586,309650,242005,89425,273805,295200,295250,295686,68332,284300,284311,291180,295713,296591,131786,205370,266760,291176,293761,293015,284309,284316,293795,295630,305292,131793,178564,266764,291140,239874,291177,292989,295473,305293,293856,131770,205388,291203,293267,296578,299475,299479,299433,124382,205414,239872,286709,293372,293374,297100,116327,117015,265894,295550,296462,117016,159030,159137,178071,291083,293139,293456,65165,293058,293615,308924,159141,205536,244944,62780,62786,300978,303098,62764,305192,62821,65052,62806,65065,62782,65144,89457,94548,131876,65161,94554,125652,62787,62869,116241,65288,205474,265782,265786,293407,65056,89439,94565,296341,62846,116284,116292,141419,89423,89424,116287,268027,272155,308792,125662,187173,308218,127414,205369,245757,62828,152464,160278,161102,116251,267979,279526,279942,280073,280037,264658,65287,286713,264080,265743,267966,268009,268020,275637,267976,279919,288908,303096,62777,62794,62798,89452,89459,152458,89448,62722,62736,62743,89466,62781,62784,62808,65011,116266,268010,205408,205410,254490,273815,278588,273795,291089,291112,291139,266770,291178,131771,284315,286721,286722,124363,205430,205451,205457,291056,236515,267975,65081,116275,125649,279529,62757,252352,279974,302132,302134,62802,94567,286143,62813,187170,205323,265765,265895,300999,303095,280074,292874,62742,62766,62767,62876,62878,264662,264666,265777,62817,62860,65050,68323,116248,116276,125639,65131,264077,279960,62826,65032,65061,62721,65114,62852,62877,116269,125645,125650,254651,125651,131881,187172,229622,131882,187174,265783,265923,268002,311537,268030,187176,205346,264660,267977,297744,205351,257292,267961,306522,265792,269359,292871,297735,303110,65087,279900,280000,140574,259566,311009,89446,289062,311905,292915,292919,290943,289803,131872,312037,289164,313063,313068,284172,312917,281963,312894,281345,313084,277876,62805,62799,62818,116253,264064,279906,292876,62739,62747,62750,62759,62801,62815,62838,65034,65158,68313,89438,238359,62726,62735,62790,62835,62840,62844,62864,65014,65043,94516,279528,62727,62774,94518,94539,94564,116271,116303,124387,124393,127413,265748,132371,125646,116264,124385,280038,131885,228860,264065,265779,265798,279527,313824,89279,265781,313908,316231,308925,308928,279909,306534,316349,316230,266124,316232,316226,316227,316238,316236,316234,316225,316233,293271,295832,299451,295790,291170,295242,299472,159140,159085,286729,292988,293016,272088,286725,293524,293764,299494,291174,293130,293585,116255,316520,264775,307689,316310,280136,318831,318832,318941,318940,318946,318964,319871,62723,267999,308975,297740,62776,306529,65080,125656,125661,131880,131884,140575,140576,180894,205331,205338,205342,228861,228862,228863,238821,252350,254650,255694,256854,265778,267962,279878,279999,280047,280104,297746,303091,303104,303109,306518,307686,308981,316575,62761,62765,62834,65016,65071,65105,68303,89461,116261,116277,116299,131871,279990,65157,125643,125653,125658,259569,306521,252349,264079,272156,272157,280011,305194,303092,316576,316577,116272,116273,187168,205344,228865,267959,291059,324108,280019,268001,303105,307691,325760,325637,325870,325871,325872,325873,245063,243930,245054,254493,267972,308980,318967,318966,318969,116304,240475,240469,240470,241025,241035,241076,256881,260086,241075,253021,263734,263735,263736,253020,271797,274016,199466,274175,252256,288720,290361,264807,293442,177479,175188,175200,266103,294485,293907,290505,293079,293240,293650,299258,299211,299446,286543,293241,293261,300938,303724,305304,305790,57952,267974,181120,306211,296849,307839,265907,137424,308918,100187,305736,159020,273790,311024,274387,313519,293110,293777,293821,308908,293074,318074,317591,316393,289057,289077,318935,289013,318944,289019,318937,318915,318921,88617,294262,324025,303838,325688,325698) GROUP BY store.id ORDER BY kv.pos, store.create_time DESC LIMIT 0, 48 Результаты поиска

Результати пошуку

Сортування
Тип товару
Вид товару
Категорія
Жанр
Клас
Вік
Предмет
Сортування
Показати товари в наявності Найдено 933 результатa