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 = 955 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 96 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
1:48
RE-RELEASED!!! Boeing B-17G Flying Fortress PART I (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets..... EDEX678 B-17G ED491057 B-17G cockpit EDFE1058 B-17G seatbelts STEEL DED491061 B-17G nose interior ED491062 B-17G waist section (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Catalogue
£52.30
£47.07
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
RE-RELEASED!!! Boeing B-17G Flying Fortess PART II (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets..... ED481005 Boeing B-17G Flying Fortress engine ED481011 Boeing B-17G Flying Fortress undercarriage & exterior ED491070 Boeing B-17G Flying Fortress bomb bay
Aircraft detailing sets (etched)
Catalogue
£50.50
£45.45
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
RE-RELEASED!!! Boeing B-17G Flying Fortress PART III (designed to be used with Hong Kong Models kits) This Big-Ed set contains all these Eduard sets.... ED481012 Boeing B-17G Flying Fortress ammo feed chutes ED491058 Boeing B-17G Flying Fortress radio compartment ED491072 Boeing B-17G wooden floors & ammo boxes
Aircraft detailing sets (etched)
Catalogue
£37.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
RE-RELEASED!!! Boeing B-17F Flying Fortress part I (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets..... EDEX777 B-17F ED491180 B-17F cockpit ED491181 B-17F nose interior ED491183 B-17F waist section EDFE1181 B-17F seatbelts STEEL 1/48 (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Catalogue
£55.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

No Image
RE-RELEASED!!! Boeing B-17F Flying Fortress part II (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets..... ED481052 B-17F engines ED481054 B-17F undercarriage & exterior ED491184 B-17F bomb bay
Aircraft detailing sets (etched)
Catalogue
£50.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
RE-RELEASED!!! Boeing B-17F Flying Fortress part III (designed to be used with Hong Kong Models kits) This BiG-Ed set includes all these Eduard sets..... ED491182 B-17F radio compartment ED481056 B-17F ammo feed chutes ED491201 B-17F wooden floors & ammo boxes 1
Aircraft detailing sets (etched)
Catalogue
£42.99
£38.69
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
1:48
Hawker Hurricane Mk.IIc (designed to be used with Arma Hobby kits) This BiG-Ed set includes all these Eduard sets.... EDS491382 Hurricane Mk.IIc 1/48 EDFE1383 Hurricane Mk.IIc seatbelts STEEL EDEX980 Hurricane Mk.IIc TFace canopy frame paint mask (inside & outside) 1/48
Aircraft detailing sets (etched)
Catalogue
£20.60
£18.54
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
Hawker Hunter FGA.9 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets.... ED481122 Hunter FGA.9 landing flaps 1/48 ED491388 Hunter FGA.9 1/48 EDFE1391 Hunter FGA.9/FR.10/GA.11 seatbelts STEEL EDEX986 Hunter FGA.9/FR.10/GA.11
Aircraft detailing sets (etched)
Catalogue
£29.50
£26.55
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
1:48
Hawker Hunter FR.10 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets.... ED481123 Hunter FR.10 landing flaps 1/48 ED491389 Hunter FR.10 1/48 EDFE1391 Hunter FGA.9/FR.10/GA.11 seatbelts STEEL EDEX986 Hunter FGA.9/FR.10/GA.11
Aircraft detailing sets (etched)
Catalogue
£29.50
£26.55
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
Hawker Hunter GA.11 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets.... ED481124 Hunter GA.11 landing flaps ED491390 Hunter GA.11 EDFE1391 Hunter FGA.9/FR.10/GA.11 seatbelts STEEL EDEX986 Hunter FGA.9/FR.10/GA.11
Aircraft detailing sets (etched)
Catalogue
£29.50
£26.55
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
1:48
de Havilland Vampire FB.5 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets.... ED491384 Vampire FB.5 1/48 EDFE1386 Vampire FB.5/9 seatbelts STEEL EDEX981 Vampire FB.5/9 1/48
Aircraft detailing sets (etched)
Catalogue
£18.50
£16.65
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
de Havilland Vampire FB.9 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets.... ED491385 Vampire FB.9 1/48 EDFE1386 Vampire FB.5/9 seatbelts STEEL EDEX981 Vampire FB.5/9 wheels and canopy frame paint masks
Aircraft detailing sets (etched)
Catalogue
£18.50
£16.65
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
Yakovlev Yak-9T (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets.... ED491376 Yak-9T1/48 EDFE1377 Yak-9T seatbelts STEEL EDEX974 Yak-9T 1/48
Aircraft detailing sets (etched)
Catalogue
£20.60
£18.54
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
McDonnell F-4G Phantom (designed to be used with Meng Model kits) This BiG-Ed set includes all these Eduard sets.... ED81121 F-4G reinforcement straps & formation lights ED49103 Remove Before Flight STEEL ED491378 F-4G EDFE1379 seatbelts STEEL EDEX972 F-4G
Aircraft detailing sets (etched)
Catalogue
£31.99
£28.79
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
Lockheed-Martin F-16D Fighting Falcon Block 30 (designed to be used with Kinetic Model kits) This BiG-Ed set includes all these Eduard sets.... ED481118 F-16 reinforcement straps STEEL 1/48 ED49103 Remove Before Flight STEEL ED491369 F-16D Block 30 EDFE1372 F-16D Block 30/40/50 seatbelts STEEL EDEX966 F-16D Block 30/40/50
Aircraft detailing sets (etched)
Catalogue
£37.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
Lockheed-Martin F-16D Fighting Falcon Block 40 (designed to be used with Kinetic Model kits) This BiG-Ed set includes all these Eduard sets.... ED481118 F-16 reinforcement straps STEEL ED49103 Remove Before Flight STEEL ED491370 F-16D Block 40 EDFE1372 F-16D Block 30/40/50 seatbelts STEEL EDEX966 F-16D Block 30/40/50 1/48
Aircraft detailing sets (etched)
Catalogue
£37.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
Lockheed-Martin F-16D Fighting Falcon Block 50 (designed to be used with Kinetic Model kits) This BiG-Ed set includes all these Eduard sets.... ED481118 F-16 reinforcement straps STEEL ED49103 Remove Before Flight STEEL ED491371 F-16D Block 50 EDFE1372 F-16D Block 30/40/50 seatbelts EDEX966 F-16D Block 30/40/50
Aircraft detailing sets (etched)
Catalogue
£37.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
Fairchild A-10C (designed to be used with Academy kits) This BiG-Ed set includes all these Eduard sets.... ED481120 A-10C formation lights 1/48 ED49103 Remove Before Flight STEEL ED491373 A-10C 1/48 EDFE1374 A-10C seatbelts STEEL
Aircraft detailing sets (etched)
Catalogue
£27.20
-
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
1:48
Hawker Hurricane Mk.I (designed to be used with Hobby Boss kits) This BiG-Ed set includes all these Eduard sets.... ED481113 Hurricane Mk.I landing flaps ED481114 Hurricane Mk.I gun bays ED491364 Hurricane Mk.I EDFE1365 Hurricane Mk.I seatbelts STEEL
Aircraft detailing sets (etched)
Catalogue
£41.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
Mil Mi-4A (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets.... ED481116 Mi-4A cargo floor ED491362 Mi-4A EDFE1363 Mi-4A seatbelts STEEL EDEX960 Mi-4A
Aircraft detailing sets (etched)
Catalogue
£37.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
McDonnell F-4E Phantom (designed to be used with Meng Model kits) This BiG-Ed set includes all these Eduard sets.... ED481117 F-4E reinforcement straps & formation lights ED49103 Remove Before Flight STEEL ED491358 F-4E EDFE1359 F-4E seatbelts STEEL EDEX949 F-4E
Aircraft detailing sets (etched)
Catalogue
£31.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
Mikoyan MiG-17F (designed to be used with AMMO kits) This BiG-Ed set includes all these Eduard sets.... ED491366 MiG-17F EDFE1367 MiG-17F seatbelts STEEL EDEX957 MiG-17F
Aircraft detailing sets (etched)
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
Lockheed PV-1 Ventura PART II (designed to be used with Academy kits)This BiG-Ed set includes all these Eduard sets.... ED481106 PV-1 exterior ED481107 PV-1 bomb bay ED481108 PV-1 undercarriage
Aircraft detailing sets (etched)
Catalogue
£56.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

No Image
Mil Mi-8MT (designed to be used with Trumpeter kits)This BiG-Ed set includes all these Eduard sets.... ED491356 Mi-8MT1/48 EDFE1357 Mi-8MT seatbelts STEEL EDEX947 Mi-8MT 1/48
Aircraft detailing sets (etched)
Catalogue
£24.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
Mil Mi-8MT CARGO INTERIOR (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets.... ED481111 Mi-8MT cargo floor 1/48 ED481112 Mi-8MT cargo seats 1/48 ED491357 Mi-8MT cargo seatbelts STEEL1/48
Aircraft detailing sets (etched)
Catalogue
£39.40
-
In Stock
2