Модели автомобилей, самолетов, кораблей, военной техники
При заказе от 7500 руб.
{{ cart.count }}

Голландская распродажа

Ежедневное снижение цен!

*на модели из списка

Стартовая скидка 5%

Каждый день цены будут снижаться на 1%!

до конца сентября или пока не закончатся все модели

    
            SELECT 
                Product.PRODUCT_ID,
                Product.ARTICUL, 
                Product.PRODUCT_NAME,
                Product.PRODUCT_ALIAS_NAME,
                Product.IMAGE,
                Product.SCALE,
                Product.PRICE,
                Product.PRICE_SPECIAL,
                Product.TRADE_PRICE,
                IF(Product.PRICE_SPECIAL > 0, Product.PRICE_SPECIAL, Product.PRICE) AS ORDERED_PRICE,
                IF(DATEDIFF(NOW(), Product.SALE_AGAIN_DATE) < 15, 1, 0) AS IS_NEWLY_ITEM,
                Product.STORE,
                Product.IS_VIRTUAL_STORE,
                Product.IS_NEW,
                Product.IS_FUTURE,
                Product.IS_GIFT,
                Product.IS_SPECIAL,
                Product.IS_MARKED,
                Product.IS_EXPIRED,
                Product.FREE_DELIVERY,
                UNIX_TIMESTAMP(Product.CREATED) AS CREATED_DATE,
                IF(Product.NEW_DATE IS NOT NULL, UNIX_TIMESTAMP(Product.NEW_DATE), 0) AS NEW_DATE,
                IF(Product.SALE_AGAIN_DATE IS NOT NULL, UNIX_TIMESTAMP(Product.SALE_AGAIN_DATE), 0) AS SALE_AGAIN_DATE,
                Cart.ITEM_AMOUNT AS AMOUNT_IN_CART, 
                Album.DEFAULT_IMAGE, 
                Album.FOLDER, 
                Brand.VENDOR_ID,
                Brand.VENDOR_NAME,
                Brand.VENDOR_ALIAS_NAME
            FROM deProducts AS Product
            INNER JOIN deActions AS Action ON Action.ACTION_KEY = Product.ACTION_KEY
            LEFT JOIN deAlbums AS Album ON Product.ALBUM_ID = Album.ALBUM_ID
            LEFT JOIN deCarts AS Cart ON (Product.PRODUCT_ID = Cart.ITEM_ID AND Cart.CART_ID = '737b19f0e229aae69dd933187face9ce')
            INNER JOIN deCatalog AS Catalog ON Catalog.CATALOG_ID = Product.CATALOG_ID
            INNER JOIN deVendors AS Brand ON Brand.VENDOR_ID = Product.VENDOR_ID
            LEFT JOIN deMarks AS Model ON Product.MARK_ID = Model.MARK_ID
            WHERE 
                Product.IS_PUBLISHED = 1
                AND Product.IS_EXPIRED != 1
                AND (Product.STORE > 0 OR Product.IS_VIRTUAL_STORE = 1) 
                AND Action.ACTION_KEY = 'KITSALE' 
                AND Action.DATE_START <= NOW()
                AND Action.DATE_END > NOW()
                AND Action.IS_ACTIVE = 1
                AND Product.IS_DELETED != 1
                AND Brand.IS_DELETED != 1
                AND Brand.IS_PUBLISHED = 1
                AND Catalog.IS_DELETED != 1
                AND Catalog.IS_PUBLISHED = 1
            GROUP BY Product.PRODUCT_ID
            ORDER BY Product.PRODUCT_ID DESC 
        
В продаже сейчас 48 товаров по акции
2 500 1 725₽
Fujimi, 126425
260 179₽
MENG Models, SPS-008
884 610₽
Heller, 80213
2 210 1 525₽
MENG Models, PS-002
2 050 1 415₽
Academy, 13505
345 238₽
AirFix, A02335
1 745 1 204₽
HobbyBoss, 82405
1 117 771₽
HobbyBoss, 83413
270 186₽
Звезда, 6811
1 050 725₽
Forces of Valor, 87006
2 803 1 934₽
Моделист, 602423
5 600 3 864₽
Dragon, 3544
730 504₽
Звезда, 4806
1 823 1 258₽
Hasegawa, 9072
360 248₽
Звезда, 8026
430 297₽
Звезда, 7304
500 345₽
Звезда, 7259
180 124₽
Звезда, 6157
1 085 749₽
Hasegawa, 49707
590 407₽
Звезда, 7276