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 = 956 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 19 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

No Image
Eduard Big-Ed EBIG72178
Lockheed AC-130J Hercules PART I (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... ED72734 AC-130J exterior ED73811 AC-130J interior EDCX653 AC-130J
Aircraft detailing sets (etched)
Catalogue
£37.99
£34.19
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 EBIG72179
Lockheed AC-130J Hercules PART II (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... ED73812 AC-130J cargo seatbelts ED73813 AC-130J cargo floor ED73814 AC-130J cargo interior
Aircraft detailing sets (etched)
Catalogue
£55.50
£49.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
Eduard Big-Ed EBIG72177
Boeing B-29A Superfortress (designed to be used with Academy and Hobby 2000 kits) This BiG-Ed set includes all these Eduard sets..... ED72732 B-29 exterior ED72733 B-29 bomb bay ED73807 B-29 interior EDSS809 B-29 seatbelts STEEL EDCX018 B-29 canopy paint mask
Aircraft detailing sets (etched)
Catalogue
£64.40
£57.96
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 EBIG72176
Consolidated PBY-5A Catalina (designed to be used with Academy and Hobby 2000 kits) This BiG-Ed set includes all these Eduard sets..... ED72731 PBY-5A exterior ED73806 PBY-5A EDCX115 PBY-5 Catalina
Aircraft detailing sets (etched)
Catalogue
£33.50
£30.15
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 EBIG72174
Lockheed C-130J Hercules PART II (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... ED73795 C-130J cargo floor 1/72 ED73796 C-130J cargo seatbelts 1/72 ED73797 C-130J cargo interior 1/72
Aircraft detailing sets (etched)
Catalogue
£57.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

No Image
Eduard Big-Ed EBIG72175
Grumman F-14B Tomcat (designed to be used with Academy kits) This BiG-Ed set includes all these Eduard sets..... ED73044 Remove Before Flight STEEL ED72730 F-14B exterior 1/72 ED73800 F-14B 1/72 EDCX647 F-14B 1/72
Aircraft detailing sets (etched)
Catalogue
£31.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 EBIG72173
Lockheed C-130J Hercules PART I (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... 72728 C-130J exterior 1/72 73794 C-130J interior 1/72 CX643 C-130J 1/72
Aircraft detailing sets (etched)
Catalogue
£34.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

Eduard Big-Ed EBIG72118
RE-RELEASED!!! Boeing B-17G Flying Fortress - PART I. (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... ED73567 B-17G cockpit interior ED73568 B-17G seatbelts STEEL ED73569 B-17G rear interior ED73570 B-17G front interior (Eduard sold out February 2023)
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 EBIG72171
Short Stirling Mk.III ESSENTIAL (designed to be used with Italeri kits) This BiG-Ed set includes all these Eduard sets..... ED72722 Stirling Mk.III exterior 1/72 ED73776 Stirling Mk.III 1/72 EDCX629 Stirling Mk.III 1/72
Aircraft detailing sets (etched)
Catalogue
£34.70
-
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 EBIG72172
Short Stirling Mk.III ADVANCED (designed to be used with Italeri kits) This BiG-Ed set includes all these Eduard sets..... ED72722 Stirling Mk.III exterior 1/72 ED72723 Stirling Mk.III fuselage bomb bay 1/72 ED72724 Stirling Mk.III wings bomb bays 1/72 ED73776 Stirling Mk.III 1/72 EDCX629 Stirling Mk.III 1/72
Aircraft detailing sets (etched)
Catalogue
£90.40
-
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 EBIG72170
Vickers Wellington Mk.II (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... ED72719 Wellington Mk.II bomb bay ED72720 Wellington Mk.II landing flaps ED73766 Wellington Mk.II EDCX619 Wellington Mk.II
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 EBIG72168
Lockheed C-130J-30 Hercules PART I (designed be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... ED72718 C-130J-30 exterior 1/72 ED73759 C-130J-30 interior 1/72 EDCX617 C-130J-30 1/72
Aircraft detailing sets (etched)
Catalogue
£34.70
-
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
Eduard Big-Ed EBIG72169
Lockheed C-130J-30 Hercules PART II (designed be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... ED73760 C-130J-30 cargo floor ED73761 C-130J-30 cargo seatbelts ED73762 C-130J-30 cargo interior
Aircraft detailing sets (etched)
Catalogue
£46.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
Eduard Big-Ed EBIG72166
Hawker Hurricane Mk.IIc (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... 72717 Hurricane Mk.IIc landing flaps 1/72 73753 Hurricane Mk.IIc 1/72 CX607 Hurricane Mk.IIc
Aircraft detailing sets (etched)
Catalogue
£22.60
-
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

Eduard Big-Ed EBIG72121
RE-RELEASED!!! Boeing B-17G Flying Fortress - PART II (designed to be used with Airfix kits) (discontinued Oct 2021) EDCX464 B-17G ED72629 B-17G landing flaps ED72630 B-17G bomb bay ED72631 B-17G exterior
Aircraft detailing sets (etched)
Catalogue
£41.40
£37.26
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 EBIG7267
RE-RELEASED!!! Boeing B-17G Flying Fortress (designed to be used with Revell kits) This BiG-Ed set includes all these Eduard sets..... ED72514 B-17G landing flaps ED72515 B-17G exterior ED72516 B-17G bomb bay ED73019 B-17G seatbelts ED73376 B-17G interior (self adhesive) ED73382 B-17G front interior ED73383 B-17G rear interior EDCX279 B-17G paint mask
Aircraft detailing sets (etched)
Catalogue
£91.20
£82.08
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 EBIG7278
RE-RELEASED!!! Boeing B-17F Flying Fortress (designed to be used with Revell kits) This Big-Ed set includes all these Eduard sets. ED72537 B-17 surface panels (self adhesive) EDED72544 B-17F exterior ED72545 B-17F landing flaps ED72546 B-17F bomb bay ED73460 B-17F interior (self adhesive) ED73461 B-17F front interior ED73462 B-17F rear interior EDCX333 B-17F
Aircraft detailing sets (etched)
Catalogue
£91.20
£82.08
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 EBIG72113
Dassault-Mirage F.1 (designed to be used with Revell and Special Hobby kits) This Big-Ed set includes these Eduard sets.... EDCX450 Mirage F.1 ED73559 Mirage F.1 ED73008 Remove Before Flight [F.1C/CT F.1CG]
Aircraft detailing sets (etched)
Catalogue
£17.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 EBIG72108
1:72
Mikoyan MiG-29A 'Fulcrum' IZDELIYE 9-12 (designed to be used with Trumpeter kits) This BiG-Ed set includes all these Eduard sets.... EDCX433 MiG-29A Izdeliye 9-12 ED73541 MiG-29A Izdeliye 9-12
Aircraft detailing sets (etched)
Catalogue
£14.40
-
In Stock
3


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