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=8167 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 152 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 113
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

Planet Models PLA21948
Westland Welkin NF.II
Aircraft kits (resin)
Catalogue
£103.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

Planet Models PLA08532
1:32
Bucker Bu-133 Jungmeister
Aircraft kits (resin)
Catalogue
£62.30
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

Planet Models PLA11272
1:72
Martin-Baker MB.5
Aircraft kits (resin)
Catalogue
£41.60
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

Planet Models PLA21648
Vought XF5U-1 Flying Pancake
Aircraft kits (resin)
Catalogue
£64.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
Planet Models PLAMV101
R-1 (Praga AH-IV-R) WWII Tankette
Military vehicle kits (resin)
Catalogue
£13.30
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
Planet Models PLAMV133
Morris CS9 British Light Armored Car 'North African Campaign' Developed in the pre-war years, this armoured vehicle was built in a hundred examples. It was armed with either an anti-tank rifle or a machine gun. The British Army used a few of these vehicles during the Battle of France in 1940 and all of them were eventually destroyed or abandoned. The remaining cars went later to North Africa. Our second release of the Morris p...
Military vehicle kits (resin)
Catalogue
£19.80
£17.82
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

Planet Models PLA03872
Focke-Wulf Fw-191
Aircraft kits (resin)
Catalogue
£59.85
-
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
Planet Models PLAMV134
1:72
Fordson WOT2 E (15CWT) 'Wooden Cargo Bed' The WOT2 light-weight military lorry was in production with the British Ford company at Dagenham since 1939 and several versions of the type was constructed. The total production number reached some 60 000 examples which served with the British Army, RAF as well as with the Royal Navy until the end of the 1950s. In the war times, these vehicles offered support to British forces in West...
Military vehicle kits (resin)
Catalogue
£18.99
-
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
Planet Models PLAMV131
Elektrischer Generator 8kw fƒ¼r Flak Sw-36) mit Sd.Ah.51. A German portable electric generator that was used to power the 60cm Flak Scheinwerfer searchlights assembly. Like the searchlight itself, the generator used the Sd.Ah51 trolley for transport. The trolley is also in the kit, all parts of which are 3D-Printed.
Military vehicle kits (resin)
Catalogue
£15.75
-
In Stock
6

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
Planet Models PLAMV132
1:72
Morris CS9 British Light Armored Car 'Battle of France' Developed during the pre-war years, this armoured vehicle was then built in hundred examples. It was armed with either an anti-tank rifle or a machine gun. The British Army used a few of these vehicles during the Battle of France in 1940 and all of them were eventually destroyed or abandoned. The remaining cars went later to North Africa. Our model offers the European var...
Military vehicle kits (resin)
Catalogue
£18.99
-
In Stock
11

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
Planet Models PLAMV130
60 cm Flak Scheinwerfer (Flak Sw-36) mit Sd.Ah.51 / Svetlomet 60N s vlekem . German WW2 searchlight with 60cm parabolic reflector. Used both by the Luftwaffe and Wehrmacht to search for enemy aircraft during night raids as well as to illuminate airfields at night. The kit including the Sd.Ah51 transport trolley is 3D-Printed. The assembled searchlight can be put on the trolley and removed again. The device was also used after ...
Military vehicle kits (resin)
Catalogue
£15.75
-
In Stock
20+

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

Planet Models PLA10272
GAL-49 Hamilcar glider (gliders)>>>
Aircraft kits (resin)
Catalogue
£92.50
-
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

Planet Models PLA12772
Avro Manchester Mk.I >>>
Aircraft kits (resin)
Catalogue
£98.80
-
In Stock
4

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

Planet Models PLA13072
Avro Manchester Mk.IA >>>
Aircraft kits (resin)
Catalogue
£98.80
-
In Stock
4

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

Planet Models PLA16072
GAL-58 Hamilcar X with engines >>>
Aircraft kits (resin)
Catalogue
£97.20
-
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

Planet Models PLA24772
General Aircraft GAL-41 >>>
Aircraft kits (resin)
Catalogue
£41.60
-
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

Planet Models PLA26072
1:72
Gloster F.9/37 >>>
Aircraft kits (resin)
Catalogue
£57.20
-
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

Planet Models PLA26272
Handley-Page H.P.75 Manx full resin kit. Cast resin model of Britsh experimental tailed aircraft developed during WW2. The HP.75 Manx was built to evaluate flight characteristics for much larger tails aircraft to be used as a miltary bomber. The plane flew with two types of engine cowlings and undercariage legs. The model contains detailed resin parts including both types of engine cowlings and undercariage, white-...
Aircraft kits (resin)
Catalogue
£41.40
-
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

Planet Models PLA26772
1:72
Miles M.35 Libellula Before the outbreak of the Second World War, Philips & Powis Aircraft Ltd. was associated with several light civil and training aircraft designs. The chief designer, technical director, later also managing director an co-owner of the firm was Frederick George Miles and thus the company desings were produced under his name. In 1943 when Rolls Royce's interests were bought out, the firm became Miles Aircraft...
Aircraft kits (resin)
Catalogue
£41.60
-
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

Planet Models PLA01472
Lippisch P 20 'Comet' TL Jage
Aircraft kits (resin)
Catalogue
£41.60
-
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
Planet Models PLA27948
HESA Shahid 136 / Geran-2 Iranian The Iran-made HESA Shahid 136 / Geran-2 drone is used by the Russian military to terrorize Ukraine and to attack its civil infrastructure. Our model is resin cast and comes with a few 3D-Printed parts and is available in the Planet Model range. It also has a sheet of decals.
Aircraft kits (resin)
Catalogue
£20.25
-
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
Planet Models PLA27772
1:72
HESA Shahid 136 / Geran-2 Iranian The Iran-made HESA Shahid 136 / Geran-2 drone is used by the Russian military to terrorize Ukraine and to attack its civil infrastructure. Our model is resin cast and comes with a few 3D-Printed parts and is available in the Planet Model range. It also has a sheet of decals.
Aircraft kits (resin)
Catalogue
£13.50
-
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

Planet Models PLA14848
CAC CA-6 Wackett. Full-resin kit of WWII RAAF trainer aircraft. Wacketts held considerable part in RAAF pilot training program. The kit contains vacu canopy and decals for two RAAF aircraft.
Aircraft kits (resin)
Catalogue
£59.99
-
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
Planet Models PLA25948
Back in stock! CAC CA-25 Vinjeel ll resin kit of the Australian trainer aeroplane which was in service from the 1950s well into the 1980s and many a future military pilot or forward air controller learned their way to the skies in it. The kit offers resin parts, vacuum-formed canopy, etches, white metal and clear resin parts. The decal sheet caters for two training and two FAC machines.
Aircraft kits (resin)
Catalogue
£64.99
-
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
Planet Models PLA21148
Back in stock! GAL-48 Hotspur Mk.II All-resin kit of the British WW2 training glider. The Hotspur Mk.I was originally developed as an assault glider. Due to the limited number of troop carried the glider had to be redesigned into the Mk.II trainer version. Had it not been for the large number of glider pilots trained on Hotspurs, the Invasion would not have developed the way we know it today. The model brings a nice level of d...
Aircraft kits (resin)
Catalogue
£59.20
-
In Stock
4

   1   |   2   |   3   |   4   |   5      »      [7]

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