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=7880 AND ps.id = 89514 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
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 43 results
| View per page
Refine your search

Deprecated: Creation of dynamic property Hannants\SearchFilters::$searchDirection is deprecated in /mnt/vault/Sync/Dessol/Sites/hannants.co.uk/php_includes/classes/SearchFilters.php on line 115
Manufacturer & Catalogue No ASC DESC
Scale ASC DESC
Description ASC DESC
Type ASC DESC
Department ASC DESC
Price ASC DESC
Watch
Stock ASC DESC
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

No Image
ADH Publishing MIM148
Military Illustrated Modeller (Issue 148) AFV Edition 4 NEWS Military scale-modelling news 8 HALFTRACK HAT-TRICK! MIM get its hands on Tamiyas three re-issued 1:35 halftracks 10 RUN LIKE A CHEETAH Tamiyas 1:35 Flakpanzer Gepard converted to Ukrainian service 20 BROTHERS A highly evocative Russian-Ukrainian War vignette in 1:35 Cover story 28 JOSEF VERSUS GOLIATH Two Dragon 1:35 JS-2s join Tamiyas Golia...
Magazines
Catalogue
£6.95
Out of Stock
0

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

No Image
ADH Publishing MIM147
Military Illustrated Modeller (Issue 146) 4 NEWS New release announcements 6 REFERENCE Messerschmitt Bf-109G-2 Black 6 by Matthew Starr 16 PREVIEW Eduard 1:48 Z-326 Trener Master 18 GUSTAV IN GREEN Pt.1 Revells 1:32 Bf-109G-2 by Brett Green 32 GREEN PEARL OF THE SOLOMON ISLANDS Pt.1 Josef Blazeks Eduard 1:48 scale Nakajima A6M2-N Rufe. 46 BOELCKES BACKDATE Wingnut Wings 1:32 Fokker E.IV by Gary Edmunds...
Magazines
Catalogue
£6.95
Out of Stock
0

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

No Image
ADH Publishing MIM146
Military Illustrated Modeller (Issue 146) 4 NEWS Military scale-modelling news 8 ROOM FOR MANOEUVRE Tamiyas updated 1:35 Type 16 MCV C5, previewed 10 IN THE POCKET MiniArts 1:35 MB Type 170V Cabrio Saloon and US WLA Motorcycle in a Colmar Pocket scene 18 AT THE CROSSROADS July 31st, 1944, at a crossroads in the Sartilly sector, Normandyaāé-¦ Cover story 20 TWELVE-POINTED STAR Hobbyboss 1:35 T-26 converted to ...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM145
Military Illustrated Modeller (Issue 145) 4 NEWS New release announcements 6 PREVIEW Eduard 1:48 Focke-Wulf Fw-190A-4 Cover story 8 SIDELINED SHARK Clear Prop! 1:48 Skyshark by Jakub Chlodek 22 TANTE JU Brett Green's 1:48 scale Revell Junkers Ju-52. 36 PENINSULA PONY Pt. 3 Mark Casiglia paints and weathers his Tamiya 1:32 North-American F-51D Mustang. 50 STEEL PIGEON Wingnut Wings 1:32 Stahltaube by Gary Edmun...
Magazines
Catalogue
£6.95
-
In Stock
1

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

No Image
ADH Publishing MIM144
Military Illustrated Modeller: Issue 144 4 NEWS Military scale-modelling news 8 THE MOST IMPORTANT TANK OF THE SECOND WORLD WAR? MiniArt's latest T-34/85, previewed 10 SHOWTIME IN SHIZUOKA, PART 2 MIM takes a look at the new armour models shown at the 61st Shizuoka Hobby Show 18 MULTI LAUNCH ROCKET SYSTEM: THE MIGHTY 9K57 URAGAN Zack Sex and Arthuras Skyrius tackle the Trumpeter 1:35 BM-27 Uragan 26 FOR YOU, TH...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM143
Military Illustrated Modeller Issue 143 4 NEWS New release announcements 6 PREVIEW Kotare 1:32 Spitfire Mk.I Cover story 12 TANK BUSTING YAK ICM 1:32 Yak-9T by Brett Green 34 PENINSULA PONY Pt. 2 Mark Casiglia completes construction of Tamiya's 1:32 F-51D Mustang 48 MODELLING TOOLS Kamil Feliks Sztarbala builds Arma Hobby's 1:72 scale PZL P.11c using AK Interactive's Basic Tools Set 62 PREVIEW Clear Prop! 1:72 ...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM142
Military Illustrated Modeller Issue 142 4 NEWS Military scale-modelling news 6 MORRIS C9/B BOFORS Thunder Models' new 1:35 Morris C9/B Bofors is here 8 SHIZUOKA SHOWSTOPPERS! MIM flies to Japan to report from the big hobby show Cover story 18 HIMARS, I'M HOME The M142 HIMAR MLRS in Ukrainian service 28 SHIN'Yƒ......'-CLASS SUICIDE MOTORBOAT Building a resin model of the Shin'yƒ...é Boat in 1:35 38 REFERENCES Shin'y...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM140
Military Illustrated Modeller (issue 140) 4 NEWS Military scale-modelling news 8 IRON DOME AIR DEFENCE SYSTEM Magic Factory 1:35 kit, previewed 10 NUREMBERG TOY FAIR 2023 MIM returns to the Toy Fair after a three-year absence 16 ZIMM THAT THING!! The process of Zimmeriting a Dragon 1:35 Jagdtiger 26 TAMIYA GERMAN INFANTRY SET (LATE WWII) Tamiya's latest 1:35 figure set, previewed Cover story 28 DRAGON TI...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM138
Military illustrated Modeller issue 138 4 NEWS Military scale-modelling news 8 EASY EIGHT IN THE ETO A dramatic scene using a converted Tamiya HVSS Sherman 14 US HOWITZER MOTOR CARRIAGE M8 Tamiya's all-new US WW2 M8 'Howitzer Motor Carriage, previewed 16 A SHO'T IN THE DARK Visually attractive weathering on AFV CLub's 1:35 IDF Sho't Kal Centurion 24 BONJOUR MES AMIS! A column of American infantrymen of the 9th U...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM137
Military Illustrated Modeller Issue 137 4 NEWS New release announcements 6 WILDCAT! THE FIRST OF GRUMMAN'S CATS Pt.2 Eduard 1:48 F4F-3 Wildcat by Josef Blazek 18 PREVIEW Sword 1:72 G4M1 Betty 20 KAWASAKI'S EAGLE Pt. 1 Mark Casiglia builds Tamiya's 1:48 scale Kawasaki Ki-61Hien 32 JET FIGHTER FLEDGLING Italeri's 1:48 Macchi MB.326 by Brett Green 40 PREVIEW Kinetic 1:48 F-16C USAF COVER STORY 42 CANADIAN LEGACY ...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM135
No Scale
Military illustrated modeller 4 NEWS What's happening in modelling and aviation COVER STORY 6 WILDCAT! THE FIRST OF GRUMMAN'S CATS Pt.1 Eduard 1:48 F4F-3 Wildcat by Josef Blazek 16 PREVIEW Arma Hobby 1:72 P-39 Airacobra 18 BIPLANE DUSK Mark Casiglia builds ICM's 1:32 Gloster Gladiator Mk. I 40 THE FLYING PENCIL ICM 1:48 scale Do 17 Z-2 by Gary Edmundson 50 PREVIEW ICM's 1:32 Yak-9T 52 SPECIAL DELIVERY Hasegawa...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing ADH180
How To Build... Tamiya's 1:48 Lockheed P-38 Lightning by Marcus Nicholl. 84 pages, all in colour [P-38F/G P-38J]
Aircraft books (on modelling aircraft)
Catalogue
£15.95
Out of Stock
0

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

No Image
ADH Publishing MIM131
Military illustrated modeller Issue 131 4 NEWS What's happening in modelling and aviation 6 PREVIEW Eduard 1:48 Sopwith Camel F.1 8 ALBATROS! Gary Edmundson builds Wingnut Wings 1:32 Albatros 18 PREVIEW Eduard 1:72 CS-199 Two Seater 20 A JOY FOREVER Mark Casiglia builds Tamiya's 1:32 F4U-1 Birdcage Corsair 34 REFERENCE P-40N-1 Warhawk restored and in flight 36 PACIFIC HARASSER Part Two Trumpeter's 1:32 P-40N-1 ...
Magazines
Catalogue
£6.95
-
In Stock
5+

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

No Image
ADH Publishing MIM127
Military Illustrated Modeller (Issue 127) 4 NEWS What's happening in modelling and aviation 6 PREVIEW Dora Wings' 1:48 CW-21A Interceptor COVER STORY 8 TORA! TORA! TORA! Part One Eduard's 1:48 A6M2 Zero by Josef Blazek 22 REFERENCE Heinkel Heinkel He-162 by Zack Sex. 28 THE PEOPLE'S FIGHTER Part One Special Hobby 1:72 Heinkel Heinkel He-162 by Kamil Feliks Sztarbala 38 PREVIEW IBG 1:72 Focke-Wulf Fw-190 D-9 ...
Magazines
Catalogue
£6.75
-
In Stock
2

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

No Image
ADH Publishing MIM125
4 NEWS What's happening in modelling and aviation 6 PREVIEW Brengun 1:32 MQ-8B Fire Scout 8 REFERENCE Mil Mi-24 Hind by Zack Sex COVER STORY 14 TURBO STALLION Halberd Models 1:48 Cavalier Turbo Mustang III conversion by Brett Green 30 MALTESE BEAU Tamiya 1:48 Beaufighter Mk.VI by Mark Casiglia 42 WICK-ED EMIL Part Two Special Hobby 1:72 Messerschmitt Bf-109 E-4 by Kamil Feliks Sztarbala 52 THE PHANTOM PIRATE Al...
Magazines
Catalogue
£6.75
-
In Stock
3

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

No Image
ADH Publishing MIM123
Military Illustrated Modeller (issue 123) December 2021 (Aircraft Edition) 4 NEWS What's happening in modelling and aviation 6 PREVIEW Arma Hobby 1:72 F4F-4 Wildcat COVER STORY 8 THOROUGHBRED Eduard's 1:48 scale early version P-51D-5 Mustang by Brett Green 28 AN AMERICAN IN TUNISIA Tamiya 1:32 Supermarine Spitfire Mk.IXc by Mark Casiglia 40 WICK-ED EMIL Part One Special Hobby 1:72 Messerschmitt Bf-109 E-4 by Kam...
Magazines
Catalogue
£6.75
-
In Stock
1

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

No Image
ADH Publishing MIM121
Military Illustrated Modeller (issue 121) October 2021 (Aircraft Edition) 'Fork-Tailed Devil' Tamiya's 1:48 Scale P-38F/G Lightning. 4 NEWS What's happening in modelling and aviation 6 REFERENCE Messerschmitt Bf-109 E-7 at Chino 12 PREVIEW Zvezda 1:48 Il-2 Shturmovik 14 EARLY EMIL Wingsy Kits' 1:48 scale Messerschmitt Bf-109 E-1 by Brett Green COVER STORY 30 FORK-TAILED DEVIL Tamiya 1:48 P-38F/G Lightning by Ton...
Magazines
Catalogue
£6.75
Out of Stock
0

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

No Image
ADH Publishing MIM119
Military Illustrated Modeller (issue 119) August 2021 (Aircraft Edition) 4 NEWS What's happening in modelling and aviation 6 REFERENCE de Havilland Mosquito Restoration 10 PREVIEW Kinetic 1:24 Thunderbolt Mk.I 12 WOODEN WONDER Tamiya 1:32 de Havilland Mosquito FB Mk. VI by Mark Casiglia 26 WILDCAT IN WHITE Part One Arma Hobby 1:72 General-Motors FM-2 Wildcat Expert Set by Kamil Feliks Sztarbala COVER STORY 40 BUF...
Magazines
Catalogue
£6.75
-
In Stock
5+

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

No Image
ADH Publishing MIM113
Military Illustrated Modeller (issue 113) February 2021 (Aircraft Edition) 'The Little Gramper - Hasegawa 1:72 B-24D Assembly Ship' 4 NEWS What's happening in modelling and aviation 6 REFERENCE Messerschmitt Bf-109EClose-Up 14 PREVIEW Eduard 1:48 Adlerangriff 16 GALLAND'S MOUNT Eduard 1:32 Messerschmitt Bf-109Eby Brett Green 26 PREVIEW Kinetic 1:48 Harrier GR.1/3 COVER STORY 28 THE LITTLE GRAMPER Hasegawa 1:...
Magazines
Catalogue
£6.75
-
In Stock
2

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

No Image
ADH Publishing MIM117
Military Illustrated Modeller (issue 117) June 2021 (Aircraft Edition) 'Little Brown Jug - Dora Wings' 1:48 scale Republic P-43 Lancer' 4 NEWS What's happening in modelling and aviation 6 REFERENCE Republic P-43 Lancer 12 PREVIEW ARMA 1:48 PZL P.11c COVER STORY 14 LITTLE BROWN JUG Dora Wings' 1:48 P-43 Lancer by Brett Green 26 PREVIEW Airfix 1:72 Britol Beaufort Mk.I 28 KIWI CORSAIR Tamiya 1:32 F4U-1A Corsair...
Magazines
Catalogue
£6.75
Out of Stock
0

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

No Image
ADH Publishing ADHFC07
Firefly Collection No.7 Sturmgeschutz/StuG . ADH Publishing, in collaboration with The Oliver Publishing Group, is proud to announce a new series of books for the modeller, military enthusiast and general reader. Each title will include Superbly rendered and meticulously researched colour profiles Black and white period photographs sourced from the world's major archives and private collections Background histo...
Military vehicle books (on modelling)
Catalogue
£14.99
Out of Stock
0

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

No Image
ADH Publishing MIM115
Military Illustrated Modeller (issue 115) April 2021 (Aircraft Edition) 'Classic Wurger - Roy Sutherland's Hasegawa 1:48 Focke-Wulf FW-190A-6' 4 NEWS What's happening in modelling and aviation 6 REFERENCE Focke-Wulf Fw-190 A-6 and A-8 12 PREVIEW Clear Prop 1:72 La-5 COVER STORY 14 CLASSIC WURGER Hasegawa 1:48 Focke-Wulf Fw-190 A-6 by Roy Sutherland 24 PREVIEW Kinetic 1:48 IA-58 Pucara 26 THE GLORY OF THE TWE...
Magazines
Catalogue
£6.75
-
In Stock
1

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

No Image
ADH Publishing MIM112
Military Illustrated Modeller (issue 112) January 2021 (AFV Edition) 4 NEWS Military modelling news 6 NEWS EXTRA Tamiya's almost all-new 1:35 Pz.IV Ausf. F 8 A MOST UNCIVIL WAR The painting and weathering processes on the AMMO 1:16 Pz.I Breda 16 BERLIN CALLING! Getting funk-y with Dragon's 1:35 Kleiner Panzerbefehlswagen radio tank COVER STORY 26 COWS ARE NOT AFRAID OF FIREFLIES! A Sherman Firefly VC...
Magazines
Catalogue
£6.75
-
In Stock
5+

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

No Image
ADH Publishing MIM111
Military Illustrated Modeller (issue 111) December 2020 (Aircraft Edition) 4 NEWS What's happening in modelling and aviation 6 REFERENCE Spitfire Mk.I Close-Up 10 PREVIEW Dora Wings 1:48 P-43A Lancer COVER STORY 12 THE FEW AND THE FINAL Part One Eduard 1:48 Spitfire Mk.I by Brett Green 24 ANALYSIS 1:48 Spitfire kit comparison 28 PREVIEW Meng 1:32 Fokker DR.I Triplane COVER STORY 30 THE FEW AND THE FINAL Part ...
Magazines
Catalogue
£6.75
-
In Stock
5

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

No Image
ADH Publishing MIM109
Military Illustrated Modeller (issue 109) October 2020 (Aircraft Edition) "Simply Irrestistable -Airfix 1/48 Spitfire FB. Mk.XIV" 4 NEWS What's happening in modelling and aviation 6 SINGLE SEAT SWALLOW Revell 1:32 Messerschmitt Me-262 A-1a by Chris Wauchop 14 PREVIEW ICM 1:32 Gloster Gladiator Mk.I COVER STORY 16 SIMPLY IRRESISTABLE! Airfix 1:48 Spitfire FR. Mk.XIV by Brett Green 34 THE PADDY BIRD FROM CEYLON ...
Magazines
Catalogue
£6.75
-
In Stock
1

   1   |   2      »      [2]

Search Area Manufacturer Item Type Search

Part Number Scale Keywords Results per Page
Exact Match
Sort by:
Sort Direction:
Added Within last week
last 2 weeks
last month
last 6 months
last year