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=339360 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 1,162 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
Kits-World KW3D172027
1:72
Grumman F-14A GRU-7 Kitsworld Full Colour 3D Seat Belt decals. (Martin-Baker Mk7) Ejection Seat belts and Cushions.
3D printed decal
Catalogue
£5.99
-
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
Kits-World KW3D1321046
Hawker Hunter F.6 -3D Full colour Instrument Panels - (designed to be used with Revell kits)
3D printed decal
Catalogue
£14.99
-
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
Kits-World KW3D1481006
1:48
North-American P-51D 3D Full colour Instrument Panel (designed to be used with Tamiya kits)
3D printed decal
Catalogue
£3.99
-
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
Kits-World KW3D1481034
Vickers Wellington Mk.IC/Mk.III 3D Full colour Instrument Panel (designed to be used with Trumpeter kits)
3D printed decal
Catalogue
£12.99
-
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
Kits-World KW3D1481060
Hawker Hunter F.4,F.5,(J34) 3D Full colour Instrument Panels - Recommended Kit " Airfix.
3D printed decal
Catalogue
£9.99
-
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
Kits-World KW3D1481061
Hawker Hunter F.6 instrument panels - 3D Full colour Instrument Panels - Recommended Kit " Airfix.
3D printed decal
Catalogue
£9.99
-
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
Kits-World KW3D172024
Bomber Command Bombers Cockpit & Turrets Wellington, Stirling, Halifax, Lancaster, Hampden, Blenheim Full Colour 3D Seat Belt decals.
3D printed decal
Catalogue
£5.99
-
In Stock
10

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
Kits-World KW3D172025
Martin-Baker Ejection Seat Mk.3, Hawker Hunter, Canberra,Vampire, Victor, Vulcan Gloster Javelin Valiant.Full Colour 3D Seat Belt decals.
3D printed decal
Catalogue
£5.99
-
In Stock
10

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
Kits-World KW3D172026
Martin-Baker Ejection Seat Mk.5 Kitsworld Full Colour 3D Seat Belt decals.
3D printed decal
Catalogue
£5.99
-
In Stock
10+

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
Kits-World KW3D1721036
Handley-Page Halifax B Mk.III 3D Full colour Instrument Panels - - (designed to be used with Revell kits)
3D printed decal
Catalogue
£9.99
-
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
Kits-World KW3D1721037
Short Stirling - 3D Full colour Instrument Panels - (designed to be used with Italeri
3D printed decal
Catalogue
£9.99
-
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

No Image
Kits-World KW3D1721038
Bae Hawk T1 - 3D Full colour Instrument Panels - (designed to be used with Airfix.
3D printed decal
Catalogue
£7.99
-
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
Kits-World KW3D1721039
Bae Hawk T1 - 3D Full colour Instrument Panels - (designed to be used with Revell.
3D printed decal
Catalogue
£7.99
-
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
Kits-World KWB144-481
Soviet Union/Warsaw Pact/People's Republic of China- People's Liberation Army Air Force: Hexagonal slab dispersal/parking area, 1.8 metre radius type, 1950's to early 1970's. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) This model represents the 1.8 metre slab type that replaced the earlier 1.2 metre hexagonal slab in use from the 1930's to the late 1940's, and the 1.5 metre hexagonal slabs in use from the late 1940's to the...
Vinyl Bases
Catalogue
£7.99
-
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

No Image
Kits-World KWB144-483
1:144
Soviet Union/Russia/Warsaw Pact/People's Republic of China: PAG-14 pre-stressed concrete slab- early 1970's to present. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) This model represents the 6 metre by 2 metre slab type that replaced the earlier 1.8 metre hexagonal slab in use from the 1950's to the early 1970's. By the 1980's, most Soviet/Russian and WarPac bases had been relaid with this type which provided much better loa...
Vinyl Bases
Catalogue
£7.99
-
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
Kits-World KWB144-491
23rd Air Base (23 Baza Lotnicza), Polish Air Force, Miƒ...aâé-zsk Mazowiecki, Poland, 2001 onwards. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The base was first formed in 2001, with 1 Eskadra Lotnictwa Taktycznego (1.ELT) being the main unit stationed there flying the Mikoyan MiG-29 (9.12A) and MiG-29UB (9.51A). The units primary role is that of air defence covering both Polish and wider NATO airspace, including that of Eston...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-493
Plain Grass (Worn). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) A base of worn grass that can serve a number of functions. Applications could include military and civilian airfields and aerodromes from the dawn of flight to the present day and even bases for vehicle displays. The base can also be used for 1/72nd displays, is large enough to be cut into smaller sections to create a number of separate bases. Suggested subj...
Vinyl Bases
Catalogue
£7.99
-
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

No Image
Kits-World KWB144-495
Korat Royal Thai Air Force Base, Thailand, 1972. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Korat can trace its ancestry back to the days of the Japanese Occupation of Thailand when a small airfield was built for use by the Japanese Imperial Army. After the end of the war, the airfield was passed to the Thai government who continued its use as a base for the Royal Thai Air Force. During the early 1960's, the United Sta...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-496
1st Strategic Air Depot, USAAF, (RAF Honington) Suffolk, England, 1942-46. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Honington was established in 1937 as a Royal Air Force base operating under RAF Bomber Command. It was passed over to the USAAF in June 1942 as Station 375. Stationed at the base were the 383rd, 384th and 385th Fighter Squadrons of the 364th Fighter Group, which arrived in early 1944 operating P-51 Mustangs...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-497
Aalborg Air Base (Flyvestation Aalborg), Royal Danish Air Force, 1983-2001. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Aalborg Airport was opened in 1938. In April 1940, the base was captured by Fallschirmjƒ¤ger during Operation Weserƒ¼bung, the German invasion of Denmark and Norway. Once captured, the Germans used the airport as a main location for troops and equipment for the invasion of Norway and also as a refuelling b...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-498
Eighth Air Force, England 1942-45. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The Eighth Air Force started offensive operations against German targets in July 1942 when crews of the 15th Bombardment Squadron (Light) flying RAF Douglas A-20 Bostons attacked targets in the Netherlands. The 'Mighty Eighth' commenced operations with the Boeing B-17E Flying Fortress in August of the same year, flying from RAF Grafton Underwood ...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-506
Great War Battlefield. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The war witnessed an unprecedented horror never before seen and bought war on an industrial scale to mankind. The trench system came into effect as early as September 1914, when the Allied and Central Powers Commands began to realise that war would not be the short-term battle they had initially envisioned. As the war drew on, the trench system expanded, eve...
Vinyl Bases
Catalogue
£7.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
Kits-World KWB144-508
PAG-14 Pre-Stressed Concrete Slab- Blurred 225mm(W) x 225mm(H) 9inches(W) x 9inches(H)
Vinyl Bases
Catalogue
£7.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
Kits-World KWB48-483
Soviet Union/Russia/Warsaw Pact/People's Republic of China: PAG-14 pre-stressed concrete slab- early 1970's to present. 675mm(W) x 675mm(H) 26inches(W) x 26inches(H). This model represents the 6 metre by 2 metre slab type that replaced the earlier 1.8 metre hexagonal slab in use from the 1950's to the early 1970's. By the 1980's, most Soviet/Russian and WarPac bases had been relaid with this type which provided much better ...
Vinyl Bases
Catalogue
£19.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
Kits-World KWB48-495
Korat Royal Thai Air Force Base, Thailand, 1972. 675mm(W) x 675mm(H) 26inches(W) x 26inches(H). Korat can trace its ancestry back to the days of the Japanese Occupation of Thailand when a small airfield was built for use by the Japanese Imperial Army. After the end of the war, the airfield was passed to the Thai government who continued its use as a base for the Royal Thai Air Force. During the early 1960's, the United ...
Vinyl Bases
Catalogue
£19.99
-
In Stock
1

[1]   «      9   |   10   |   11   |   12   |   13      »      [47]
-10 | +10 +20

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