New Arrivals

SELECT /* MAIN SEARCH QUERY */ pm.name AS manufacturer, pm.name AS manufacturer_name, P.id, P.id AS product_id, P.code, P.cost_price, P.vat_enabled, P.description, P.sold_retail, P.sold_trade, P.sold_wholesale, P.country_origin_code, P.commodity_code, P.price_set, P.width, P.height, P.length, P.product_scale_id, P.reorder_level, P.release_date, P.weight, P.restriction, P.restriction_bit, P.active, P.minimum_level, P.second_hand, P.limited_availability, P.can_reorder, P.warehouse_zone_id, P.wholesale_customers, P.new_price, P.big_postage, P.disable_min_order_amount, P.last_updated, P.notes, P.old_product_scale_txt, P.has_image_200, P.has_image_400, P.last_purchase_order_stock, P.last_purchase_order_date, P.first_delivered_date, P.last_moved, P.scale_string, P.keywords, P.finished_date, P.availability, P.sold, P.sold_total, P.sold_retail, P.sold_trade, P.sold_wholesale, P.base_price, P.base_export_price, P.retail_discount, P.eu_price, P.export_price, P.trade_price, P.trade_export, P.wholesale_price, P.wholesale_export, P.discount, P.backorder_retail_discount, P.backorder_discount, P.trade_discount, P.wholesale_discount, P.product_category_id, P.product_division_id, P.product_type_id, P.product_manufacturer_id, GROUP_CONCAT(DISTINCT ps.scale ORDER BY ps.scale ASC SEPARATOR ', ') AS scale, UNIX_TIMESTAMP(P.date_added) AS date_added, UNIX_TIMESTAMP(P.arrival_date) AS arrival_date , DATE(P.arrival_date) AS real_arrival_date , pt.name AS product_type, pt.name AS type_name, media.filename, IF (pp.id is null,0,1) as pending, if( coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) ) , 0 ) >= 0 , if( coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) >= P.show_stock, P.show_stock , coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) ) , 0 ) as available, COALESCE(sl.count,0) as stock_level, COALESCE(sc.product_quantity,0) AS stock_committed, COALESCE(bv.backorders,0) AS backorders, COALESCE(bv.free_backorders,0) AS free_backorders, pc.id as department_id, pc.name as department, pc.name as department_name, P.show_stock, if( pc.name = 'Future Releases', true, false ) AS future, unix_timestamp(media.date_uploaded) as unixtime FROM product P LEFT JOIN stock_level sl on P.id = sl.product_id LEFT JOIN stock_committed sc on sc.product_id = P.id LEFT JOIN backorder_values bv ON bv.product_id = P.id LEFT JOIN product_category pc on P.product_category_id = pc.id LEFT JOIN product_manufacturer pm ON P.product_manufacturer_id = pm.id LEFT JOIN product_media media ON P.id = media.product_id AND `media`.`order` = 0 JOIN product_scale_map AS psm ON (psm.product_id = P.id) LEFT JOIN product_scale ps ON (psm.scale_id = ps.id) LEFT JOIN product_type pt ON P.product_type_id = pt.id LEFT JOIN pending_product pp ON P.id = pp.id WHERE 1 AND P.restriction_bit & 1 = 1 AND P.product_manufacturer_id=362108 AND ps.id = 956 AND P.price_set = 1 AND P.product_category_id = 105 AND pc.show_in_search = 1 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE_FORMAT(P.arrival_date,"%Y-%m-%d %H") DESC , P.code

Cookie name	Description
existing_user	Stores the email address used to previously log into the site, used to prefill forms like on the reset password screen
authchallenge	Authentication security checks
hcart	Stores the anonymous customer\'s cart token. If items are added to the card while not logged in, if you log in the items will be added to the customer\'s existing cart
hannants	Stores the session information while you remain on the site
pricer	Stores if the export or eu prices is selected on the catalogue page
hidefilter	Stores if the search filter panel is hidden or shown
AWSELB	Stores which server you\'re connected to so to access the same server while you navigate around the site
__utma __utmb __utmc __utmz	Google analytics related cookies

Scale

Description

Type

Department

Delivered

Price

Watch

Stock

Buy

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Print Scale PSL72510

Nieuport N.17- N.24 1. Nieuport 24 né° N 4663 du Sgt Andr�� L��vy - Dessin David M��chin. 2. Nieuport 21E1 No. 4227 Advanced Pilots School In Grudziadz, July 1921. 3. Nieuport 23 Russian, 2nd Lt.K. Krauzes, 8th Fighter Airborne Sqn, Summer 1917. 4. Nieuport 23 aircraft No. 2903 assigned to Escadrille N 562-SPA 561, piloted by Slt Marcel Robert, of the French forces in Venice, Italy during the Summer 1917. 5...

Aircraft decals (military)

New Arrivals

19/03/2024

~~£15.99~~
£14.39

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Print Scale PSL72507

1:72

Messerschmitt Bf-109 Roumains Part 1 1. Bf-109E-3 No. 39, Capt. Av. Vasiliu Gheorghe, Squadron 58, Group 7 Fighters, Bessarabia, June 1941. 2. Bf-109E-3 No. 47, 58 Squadron, 7th Fighter Group, Nikolaev Ukraine November 1942. 3. Bf-109E-3 No. 35 W.No. 2480, Squadron 58, Group 7 Fighters, Bucharest-Pipera, summer 1942. 4. Bf-109G-2 Lieutenant Toma Lucians. 5. Bf-109G-4 Captain Constantin Cantacuzinos. 6....

Aircraft decals (military)

New Arrivals

29/02/2024

~~£16.50~~
£14.85

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Print Scale PSL72508

Messerschmitt Bf-109 Roumains Part 2 1. Bf-109E-3 FARR 7 Group Yellow 37 Bucharest, 1941. 2. Bf-109E-3. No. 23, Adj. Av. Stefan Greceanu, Squadron 57, Group 7 Fighters. 3. Bf-109E-3. No. 48,a�é-Don Pedroa�é- Lt. Av. Peter Protopopescu, Squadron 58, Group 7 Fighters, Bucharest-Pipera, summer 1942. 4. Bf-109E-7, No 54, WNr3538 "Alice" Flown by Stefan Greceanu, Squadron 57, summer 1942. 5. Bf-109E-7, No 63, WNr1482 "Al...

Aircraft decals (military)

New Arrivals

29/02/2024

~~£16.50~~
£14.85

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Print Scale PSL72511

1:72

Grumman TBF-TBM Avenger Units of World War II 1. TBF-1C Yellow E16 of an unidentified Operational Training Unit, USS Mission Bay (CVE 59) November 1943. 2. TBM-3 Yellpw 57 of VMTB-132, USS Cape Gloucester (CVE 109), July 1945. 3. TBF-1C Black 58-C-26 Len-Sharon of VC-58, USS Block Island (CVE 21), January 1944. 4. TBF-1C White 95 of VT-2, USS Hornet (CV 12), August 1944. 5. TBM-3 White 53 of VMTB-233, USS Block I...

Aircraft decals (military)

New Arrivals

29/02/2024

~~£17.40~~
£15.66

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Print Scale PSL72512

Grumman EA-6 Prowler Part 4 1. EA-6B Prowler (VAQ-131 / CVW-2) embarked on USS Abraham Lincoln (CVN 72) - October 2010. 2. EA-6B Prowler (VAQ-131 a�é-l"Lancersa�é-) USS Abraham Lincoln CVW-2. 2006. 3. EA-6B Prowler (VAQ-131 a�é-l"Lancersa�é-) USS Abraham Lincoln CVW-2. 2011.

Aircraft decals (military)

New Arrivals

29/02/2024

~~£19.99~~
£17.99

Add to watchlist

Search Area	Manufacturer		Item Type

Part Number	Scale	Keywords	Results per Page	Only discounted retail price
		Exact Match
Only Show Items In Stock	Only Show Items With Pictures	Sort by: Sort Direction:

Cookies