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(31747,31750,31752,31755,31761,31770,128344,128348,189079,85906,85914,90992,116910,128237,94909,94910,107107,93440,93441,116716,116859,141079,141099,118459,118474,118475,149397,77767,116181,125327,125328,128151,128189,128981,140020,140024,140025,140026,161212,161171,161172,272483,272493,273716,161173,112485,118322,128193,128188,84087,137887,137901,79320,83698,125335,125341,126336,140008,140009,140010,149365,149371,149372,149375,149377,188676,188939,189109,196178,196275,161306,175369,177362,181548,161296,160185,160186,160187,160189,160826,160828,177193,177372,181740,186214,187888,187952,188941,196631,196716,196717,197266,198154,198599,198904,199134,199276,199278,229144,230774,243839,199594,227575,228597,228986,229063,229072,229245,229297,229312,237034,242011,242016,243833,254633,116604,240796,161350,237044,243830,243831,244537,246337,246350,252286,253539,253563,254612,254614,254624,254625,64904,254434,116603,64906,56223,87171,282865,282866,283718,283719,283720,283721,283722,283723,283724,79643,87097,128154,279856,79056,84242,56205,56339,79089,161411,203107,79637,39447,127628,84963,129066,16720,85383,16911,79030,79031,79055,79088,79102,79103,79123,79138,79166,79167,85463,85475,127491,127626,139968,175633,83947,84211,84406,150604,15441,15456,15459,15460,15841,78694,79029,79071,79087,79101,79121,86670,86679,110554,125287,118057,91765,90957,117222,127656,107086,99899,94271,107283,118044,118058,125277,125280,125281,125284,125286,125298,125299,125305,125306,125307,125309,126529,127578,99376,117874,99971,117218,254876,127443,99860,283319,79119,289187,289188,289189,289190,289151,290033,188712,188885,290877,290881,290884,290892,290904,76412,233155,234684,149361,149373,112476,118473,291355,294855,181786,140255,79170,198370,308341,308346,111662,308643,308644,308645,308646,308932,308933,308937,308939,309949,309941,310176,150854,310832,310934,232737,234612,234723,235443,141074,177560,160469,202492,235313,233906,300209,300085,300223,310512,86686,86687,125308,79057,93437,93438,15855,99384,79107,125302,125303,79173,86681,31749,31754,31763,130771,82868,141082,141102,247392,118315,309953,128013,91022,78846,125296,125297,107309,199135,188551,84622,107116,90966,157525,175698,118456,79097,79098,79099,125282,125283,99969,237061,272486,128377,127558,90915,84608,318475,117950,237053,118333,94786,99946,286357,310430,94879,84766) GROUP BY store.id ORDER BY kv.pos, store.create_time DESC LIMIT 0, 48 Результаты поиска

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

Сортування
Вид товару
Категорія
Жанр
Клас
Вік
До підручника
Програма
Предмет
Рівень
Сортування
Показати товари в наявності Найдено 349 результатів