Catalogue

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=362475 AND ps.id = 956 AND P.price_set = 1 AND P.product_category_id = 102 AND pc.show_in_search = 1 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE(P.arrival_date) 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

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

Furball Aero-Design FBD72012

1:72

"F-35 Anthology Part IV" (72-012). This set has options for 26 F-35As, and enough stencils are included to build 4 models. Here's a rundown of the covered aircraft: -F-35A 18-5354, 354TH FW FLAGSHIP, EIELSON AFB, 2020 -F-35A 18-5376, 356TH FS, EIELSON AFB, 2020 -F-35A 19-5481, 355TH FS, EIELSON AFB, 2021 -F-35A 18-5355, 355TH FS FLAGSHIP, EIELSON AFB, 2021 -F-35A 15-5200, 421ST FS FLAGSHIP, HILL AFB, 2021 -F-...

Aircraft decals (military)

Catalogue

£17.99

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

Furball Aero-Design FBD72011

Boeing P-8A Poseidons of the US Navy" features 14 options for the 1/72 BPK P-8A kit. Here's the list of aircraft included in this mega set: -VP-4 P-8A 168851, NAS Whidbey Island, 2021 -VP-5 P-8A 169551, NAS Jacksonville, 2021 -VP-8 P-8A 168760, NAS Jacksonville, 2019 (lo-viz unit markings) -VP-8 P-8A 169570, NAS Jacksonville, 2021 (hi-viz unit markings) -VP-9 P-8A 169548, NAS Whidbey Island, 2021 -VP-10 P-8A ...

Aircraft decals (military)

Catalogue

~~£25.99~~
£23.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

Furball Aero-Design FBDS7205

Grumman Hellcat. sized for the Eduard kits. 'Colors and Markings of US Navy F6F Hellcats Part 2'. This set options for 12 F6F-5 Hellcats in the Glossy Sea Blue scheme: - F6F-5 VF-7, USS HANCOCK 1944 "White 17" - F6F-5 VF-9, USS YORKTOWN, 1945 "White 9" - F6F-5 VF-11, USS HORNET, 1944 "White 9" -F6F-5 VBF-12, USS RANDOLPH, 1945 "White 32" -F6F-5 VF-20, USS ENTERPRISE, 1944 "White 69" -F6F-5 VF-27, USS PRINCETON, 1944 "Whi...

Aircraft decals (military)

Catalogue

£15.99

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

Furball Aero-Design FBDS7204

Grumman Hellcat This set options for 12 F6F-5 Hellcats in the Glossy Sea Blue scheme: It is sized for the Eduard kits. -F6F-5, VF-17, USS Hornet, 1945 "White 35" -F6F-5, VF-23, USS Langley, 1945 "White 24" -F6F-5, VF-31, USS Cabot, 1944 "White 12" -F6F-5, VF-32, USS Cabot, 1945 "White 15" -F6F-5, VF-36, USS Siboney, 1945 "White 9" -F6F-5, VF-36, USS Siboney, 1945 "White 9" -F6F-5, VF-40, USS Suwanee, 1945 "D 15" -F6F-...

Aircraft decals (military)

Catalogue

£15.99

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

Furball Aero-Design FBDS7202

Options for 10 aircraft and enough stencil data is included to build 2 complete models. Here's a rundown of the jets covered: -461st TFS, North-American F-100D Super Sabre 55-2894, BIEN HOA AB, 1965 -461st TFS, F-100D 55-3797, BIEN HOA AB, 1965 -461st TFS, F-100D 55-3604, BIEN HOA AB, 1966 -461st TFS, F-100D 55-3535, BIEN HOA AB, 1966 -307TH TFS, F-100D 56-3405, TUY HOA AB, 1966 -307TH TFS, F-100D 55-3712, TU...

Aircraft decals (military)

Catalogue

£15.99

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