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=85838 AND ps.id = 953 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 23 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

Eduard Big-Ed EBIG3333
RE-RELEASED!!! Boeing B-17G Flying Fortress. - PART II. (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets.... ED32337 B-17G landing flaps ED32338 B-17G engines ED32342 B-17G undercarriage ED32340 B-17G exterior ED32790 B-17 placards
Aircraft detailing sets (etched)
Catalogue
£98.99
-
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

Eduard Big-Ed EBIG3374
RE-RELEASED!!! Boeing B-17E/F Flying Fortress PART 1 (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets.... ED32397 B-17E/F engines ED32897 B-17E/F seatbelts STEEL ED32399 B-17E/F undercarriage ED32400 B-17E/F bomb bay
Aircraft detailing sets (etched)
Catalogue
£47.50
£42.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

Eduard Big-Ed EBIG3375
RE-RELEASED!!! Boeing B-17E/F Flying Fortress PART 2 (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets.... ED32899 B-17E/F Flying Fortress bomb rack ED32900 B-17E/F interior ED32901 B-17E/F front interior ED32904 B-17E/F radio compartment
Aircraft detailing sets (etched)
Catalogue
£55.80
-
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
Eduard Big-Ed EBIG33157
Douglas TBD-1 Devastator (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets..... ED321013 TBD-1 1/32 ED32486 TBD-1 exterior 1/32 ED32487 TBD-1 landing flaps 1/32 ED33358 TBD-1 seatbelts STEEL
Aircraft detailing sets (etched)
Catalogue
£54.20
£48.78
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
Eduard Big-Ed EBIG33158
1:32
Macchi MC.202 Folgore (designed to be used with Italeri kits) This BiG-Ed set includes all these Eduard sets..... ED321014 MC.202 1/32 ED32488 MC.202 landing flaps 1/32 ED33360 MC.202 seatbelts STEEL 1/32 EDJX318 MC.202 1/32
Aircraft detailing sets (etched)
Catalogue
£46.99
£42.29
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
Eduard Big-Ed EBIG33156
1:32
Douglas A-20G Havoc (designed to be used with Hong Kong Model kits) This BiG-Ed set includes all these Eduard sets..... ED321012 A-20G 1/32 ED32484 A-20G bomb bay 1/32 ED32485 A-20G main wheel wells 1/32 ED33356 A-20G seatbelts STEEL 1/32 EDJX315 A-20G 1/32
Aircraft detailing sets (etched)
Catalogue
£69.99
-
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
Eduard Big-Ed EBIG33155
Lockheed-Martin F-35A Lightning II This BiG-Ed set includes all these Eduard sets..... (designed to be used with Trumpeter kits) ED32886 Remove Before Flight STEEL ED321011 F-35A ED33354 F-35A seatbelts STEEL EDJX313 F-35A
Aircraft detailing sets (etched)
Catalogue
£33.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
Eduard Big-Ed EBIG33153
Supermarine Spitfire Mk.I (designed to be used with Kotare Models kits) This BiG-Ed set includes all these Eduard sets..... ED32483 Spitfire Mk.I landing flaps 1/32 ED321009 SpitfireMk.I 1/32 ED33350 Spitfire Mk.I seatbelts STEEL 1/32 EDJX309 Spitfire Mk.I 1/32
Aircraft detailing sets (etched)
Catalogue
£39.40
-
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
Eduard Big-Ed EBIG33154
Boeing/Hughes AH-64E (designed to be used with Takom kits) This BiG-Ed set includes all these Eduard sets..... ED321010 AH-64E 1/35 ED33352 AH-64E seatbelts STEEL EDJX311 AH-64E 1/35
Aircraft detailing sets (etched)
Catalogue
£25.50
-
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
Eduard Big-Ed EBIG33151
Hawker Hurricane Mk.IIb (designed to be used with Revell kits) This BiG-Ed set includes all these Eduard sets..... ED32481 Hurricane Mk.IIb landing flaps 1/32 ED321006 Hurricane Mk.IIb 1/32 ED33344 Hurricane Mk.IIb seatbelts STEEL 1/32 EDJX305 Hurricane Mk.IIb 1/32
Aircraft detailing sets (etched)
Catalogue
£42.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
Eduard Big-Ed EBIG33150
Panavia Tornado IDS (designed to be used with Italeri kits) This BiG-Ed set includes all these Eduard sets.....
Aircraft detailing sets (etched)
Catalogue
£66.80
-
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
Eduard Big-Ed EBIG33148
1:32
Messerschmitt Bf-109G-2/4 (designed to be used with Revell kits) This BiG-Ed set includes all these Eduard sets..... ED321002 Bf-109G-2/4 ED33338 Bf-109G-2/4 seatbelts STEEL EDJX299 Bf-109G-2/4
Aircraft detailing sets (etched)
Catalogue
£27.70
-
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
Eduard Big-Ed EBIG33149
Yakovlev Yak-9K (designed to be used with ICM kits) This BiG-Ed set includes all these Eduard sets..... ED3149 Yak-9K 1/32 ICM ED32479 Yak-9K landing flaps 1/32 ED321003 Yak-9K 1/32 ED33340 Yak-9K seatbelts STEEL 1/32 EDJX301 Yak-9K 1/32
Aircraft detailing sets (etched)
Catalogue
£40.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
Eduard Big-Ed EBIG33147
1:32
Lockheed-Martin F-35C Lightning II (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets..... ED32886 Remove Before Flight STEEL ED321001 F-35C ED33336 F-35C seatbelts STEEL EDJX297 F-35C
Aircraft detailing sets (etched)
Catalogue
£34.70
-
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
Eduard Big-Ed EBIG33144
Yakovlev Yak-9T (designed to be used with ICM kits) This BiG-Ed set includes all these Eduard sets..... ED32478 Yak-9T landing flaps 1/32 ED32998 Yak-9T 1/32 ED33300 Yak-9T seatbelts STEEL 1/32 EDJX293 Yak-9T 1/32
Aircraft detailing sets (etched)
Catalogue
£42.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
Eduard Big-Ed EBIG33142
1:32
Panavia Tornado ECR (designed be used with Italeri kits) This BiG-Ed set includes all these Eduard sets..... ED32476 Tornado ECR exterior 1/32 ED32994 Tornado ECR interior 1/32 ED32995 Tornado ECR undercarriage 1/32 ED33294 Tornado ECR seatbelts STEEL EDJX285 Tornado ECR
Aircraft detailing sets (etched)
Catalogue
£66.80
-
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
Eduard Big-Ed EBIG33143
North-American B-25H Mitchell (designed be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets..... ED32477 B-25H exterior 1/32 ED32996 B-25H interior 1/32 ED33296 B-25H seatbelts STEEL 1/32 EDJX287 B-25H
Aircraft detailing sets (etched)
Catalogue
£55.80
-
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
Eduard Big-Ed EBIG33136
1:32
North-American F-100C PART I (designed to be used with Trumpeter kits)
Aircraft detailing sets (etched)
Catalogue
£55.80
-
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
Eduard Big-Ed EBIG33137
North-American F-100C PART II (designed to be used with Trumpeter kits)
Aircraft detailing sets (etched)
Catalogue
£79.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
Eduard Big-Ed EBIG33135
Boeing PT-13 Kaydet (designed to be used with Roden kits) This BiG-Ed set includes all these Eduard sets..... ED32987 PT-13 Kaydet ED33281 PT-13 Kaydet seatbelts STEEL EDJX274 PT-13 Kaydet
Aircraft detailing sets (etched)
Catalogue
£21.40
-
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
Eduard Big-Ed EBIG33131
Douglas A-26C Invader PART II (designed to be used with Hobby Boss kits) This BiG-Ed set includes all these Eduard sets..... ED32463 A-26C Invader bomb bay 1/32 ED32464 A-26C Invader undercarriage 1/32 EDJX271 A-26C Invader 1/32
Aircraft detailing sets (etched)
Catalogue
£55.50
-
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

Eduard Big-Ed EBIG3332
RE-RELEASED!!! Boeing B-17G Flying Fortress. - PART I. (designed to be used with Hong Kong Models kits) This BiG-Ed set contains all these Eduard sets.... EDJX155 B-17G Mask ED32336 B-17G bomb bay ED32764 B-17G seatbelts ED32774 B-17G interior (self adhesive) ED32775 B-17G front interior (self adhesive) ED32779 B-17G radio compartment (self adhesive) ED32780 B-17G waist section ED32782 B-17G bomb rack
Aircraft detailing sets (etched)
Catalogue
£98.99
£89.09
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

Eduard Big-Ed EBIG3371
1:32
Mitsubishi A6M5c Zero (designed to be used with Hasegawa kits) This BiG-Ed set includes all these Eduard sets.... EDJX194 A6M5c ED32393 A6M5c landing flaps ED32882 A6M5c ED32883 A6M5c seatbelts STEEL
Aircraft detailing sets (etched)
Catalogue
£40.99
-
In Stock
4


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