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=362928 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 56 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
Lockheed-Martin F-16D VISTA X-62 Decals cover the last option that flew.
Aircraft detailing sets (decal and resin)
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
HELLENIC McDonnell F-4/RF-4E Phantom II Decals cover almost ALL paint camos with basic stencils (like RESCUE in front fuselage) and insignias that F/RF-4E served in HELLENIC AIR FORCE due the almost 50 years in service from early SEA with BIG insignias until late AEGEAN GHOST and LIZARD for EX GERMANS RFs
Aircraft decals (military)
Catalogue
£16.70
£15.03
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
LTV A-7/TA-7 Corsair Greek Air Force Decals have all different front basic stencils, tail numbers and insignias
Aircraft decals (military)
Catalogue
£16.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
Greek Dassault RAFALE insignias and basic stencils. With the english version RESCUE basic stencils and insignias for RAFALE single and two seat planes and numbers FOR FIRST delivered used planes AND THE brand NEW with the squadrons chessboard mark on tail.
Aircraft decals (military)
Catalogue
£10.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
Lockheed-Martin F-16D VISTA X-62 Decals cover the last option that flew.
Aircraft detailing sets (decal and resin)
Catalogue
£25.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
HAF GEN 2 2 A5 sheets covered with basic stencils 4 HAFs generation 2 planes LTV A-7E/H Corsair McDonnell F-4E/RF-4E Lockheed F-104G/TF-104G Northrop F-5A/RF-5A With the basic stencils and insignias with most versions.
Aircraft decals (military)
Catalogue
£18.00
£16.20
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
Greek Dassault RAFALE insignias and basic stencils. With the english version RESCUE basic stencils and insignias for RAFALE single and two seat planes and numbers FOR FIRST delivered used planes AND THE brand NEW with the squadrons chessboard mark on tail.
Aircraft decals (military)
Catalogue
£9.00
-
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
Lockheed-Martin F-16D VISTA X-62 Decals cover the last option that flew.
Aircraft detailing sets (decal and resin)
Catalogue
£20.50
-
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
1:72
HAF GEN 2 2 A5 sheets covered with basic stencils 4 HAFs generation 2 planes LTV A-7E/H Corsair McDonnell F-4E/RF-4E Lockheed F-104G/TF-104G Northrop F-5A/RF-5A With the basic stencils and insignias with most versions.
Aircraft decals (military)
Catalogue
£15.00
-
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
LTV A-7E Corsair USS J.F. KENNEDY VA-72 BLUE HAWKS OPERATION DESERT STORM Decals includes 3 VA-72 aces planes with more than 20 missions each The classic 400 (with the desert camo) and 2 on overall gray with high vis squadrons markings
Aircraft decals (military)
Catalogue
£19.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
64TH AGGRESSORS Lockheed-Martin F-16 WRAITH PAINT. The aircraft painted in the new "Wraith" aggressor paint scheme was aircraft number 48, an Lockheed-Martin F-16C Block 42. This Lockheed-Martin F-16 was already in Air Force inventory, but is new to the 57th Wing's 57th Adversary Tactics Group (57th ATG). The 57th ATG contains the 64th Aggressor Squadron, to which the new "Wraith" Lockheed-Martin F-16C Block 42 is attached.
Aircraft decals (military)
Catalogue
£11.30
-
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
LTV A-7E Corsair USS J.F. KENNEDY VA-72 BLUE HAWKS OPERATION DESERT STORM Decals includes 3 VA-72 aces planes with more than 20 missions each The classic 400 (with the desert camo) and 2 on overall gray with high vis squadrons markings
Aircraft decals (military)
Catalogue
£12.50
£11.25
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
64TH AGGRESSORS Lockheed-Martin F-16 WRAITH PAINT. The aircraft painted in the new "Wraith" aggressor paint scheme was aircraft number 48, an Lockheed-Martin F-16C Block 42. This Lockheed-Martin F-16 was already in Air Force inventory, but is new to the 57th Wing's 57th Adversary Tactics Group (57th ATG). The 57th ATG contains the 64th Aggressor Squadron, to which the new "Wraith" Lockheed-Martin F-16C Block 42 is attached.
Aircraft decals (military)
Catalogue
£9.70
£8.73
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
LTV A-7E Corsair USS J.F. KENNEDY VA-72 BLUE HAWKS OPERATION DESERT STORM Decals includes 3 VA-72 aces planes with more than 20 missions each The classic 400 (with the desert camo) and 2 on overall gray with high vis squadrons markings
Aircraft decals (military)
Catalogue
£10.30
£9.27
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
64TH AGGRESSORS Lockheed-Martin F-16 WRAITH PAINT. The aircraft painted in the new "Wraith" aggressor paint scheme was aircraft number 48, an Lockheed-Martin F-16C Block 42. This Lockheed-Martin F-16 was already in Air Force inventory, but is new to the 57th Wing's 57th Adversary Tactics Group (57th ATG). The 57th ATG contains the 64th Aggressor Squadron, to which the new "Wraith" Lockheed-Martin F-16C Block 42 is attached.
Aircraft decals (military)
Catalogue
£8.10
£7.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
Lockheed-Martin F-16 VIPER STENCILS DATA designed for Greek Vipers (covered ALL BLOCKS) BUT also can used IN ANY Lockheed-Martin F-16 with main stencils color DARK GRAY (FS 36118) also include decals for landing system struts and inside canopy [General-Dynamics Lockheed-Martin]
Aircraft decals (military)
Catalogue
£16.20
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-4E/RF-4E Phantom WALKWAYS The design of decals can cover ALMOST most F-RF/4E camos . The colors of walkways are black and dark gray (tire black) and combinated with the BLACK DARK GRAY and WHITE LINES you can have almost any type of Es walkways EVEN FOR GREEK F-4E AUP (the dark gray lines)
Aircraft decals (military)
Catalogue
£12.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
Lockheed-Martin F-16 VIPER STENCILS DATA designed for Greek Vipers (covered ALL BLOCKS) BUT also can used IN ANY Lockheed-Martin F-16 with main stencils color DARK GRAY (FS 36118) also include decals for landing system struts and inside canopy [General-Dynamics Lockheed-Martin]
Aircraft decals (military)
Catalogue
£13.50
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-4E/RF-4E WALKWAYS The design of decals can cover ALMOST most F-RF/4E camos . The colors of walkways are black and dark gray (tire black) and combinated with the BLACK DARK GRAY and WHITE LINES you can have almost any type of Es walkways EVEN FOR GREEK F-4E AUP (the dark gray lines)
Aircraft decals (military)
Catalogue
£10.80
-
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
Lockheed-Martin F-16 VIPER STENCILS DATA designed for Greek Vipers (covered ALL BLOCKS) BUT also can used IN ANY Lockheed-Martin F-16 with main stencils color DARK GRAY (FS 36118) also include decals for landing system struts and inside canopy [General-Dynamics Lockheed-Martin]
Aircraft decals (military)
Catalogue
£10.80
-
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
1:72
McDonnell F-4E/RF-4E Phantoms WALKWAYS The design of decals can cover ALMOST most F-RF/4E camos . The colors of walkways are black and dark gray (tire black) and combinated with the BLACK DARK GRAY and WHITE LINES you can have almost any type of Es walkways EVEN FOR GREEK F-4E AUP (the dark gray lines)
Aircraft decals (military)
Catalogue
£8.60
-
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
Hellenic (Greek Air Force) F-16C Squadron Tail marking, Roundels and numbers for all squadrons in the last 30 years. All Blocks (30-50-52+ 52ADV). Plus THE ONLY AND WORLDWIDE UNIQUE with serial number 1045 that is an Block 50 BUT have ALL THE UPGRADES of Block 52 and that because was the test plane goes to U.S for the system confirmation
Aircraft decals (military)
Catalogue
£20.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
HELLENIC Lockheed-Martin F-16C SQUADRONS TAIL MARKS + ROUNDERS AND NUMBERS a complete COMBO collection of ALL SQUADRONS AND TAIL MARKS ever PLACED from all GREEK F-16 squadrons ALL THAT 30 years. All BLOCKS (30-50-52+ 52ADV) plus THE ONLY AND WORLDWIDE UNIQUE with serial number 1045 that is an Block 50 BUT have ALL THE UPGRADES of Block 52 and that because was the test plane goes to U.S for the system confirmation.
Aircraft decals (military)
Catalogue
£17.80
-
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
McDonnell F-4E Phantom 338 Sqn ARES callsign PIOU... the name is taken from a person in a famous commercial on Greek television and was the paint for the squadrons 60 years anniversary. Also on the same plane was painted the 66 years squadrons anniversary this was the same time that plane ended it's operational life.
Aircraft decals (military)
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
McDonnell F-4E Phantom 339 SQ AT RIAT 2016 The paint that 339SQN use for the participation on RIAT AIR SHOW 2016
Aircraft decals (military)
Catalogue
£13.99
-
In Stock
5+