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=362458
		 AND P.product_category_id = 103
		AND pc.show_in_search = 1

	 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE_FORMAT(P.arrival_date,'%Y-%m-%d %H')   DESC  ,P.code asc
Future Releases | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Future Releases



Found 16 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

Syhart Decal SY48106
1:48
Re-printed! Dassault-Mirage 2000EG/EGM, BG/BGM, -5EG, -5BG "Hellenic Air Force" (Included : Dassault-Mirage 2000EGM nƒšé°239 "25 Years 332Sqn" 2014)
Aircraft decals (military)
Future Releases
£13.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
Syhart Decal SY48127
Dassault-Rafale M #5 "70 years Flottille 12F" 2018 The Flottille 12F was created in 1948, heir to the AC2 Squadron of which it kept the badge, it took part in many conflicts such as Indochina, or in North Africa from the aircraft carriers Arromanches and Bois-Belleau, but also from land bases. The Flottille 12F, was successively equipped with Seafire, Hellcat, Corsair, then was converted on F-8 Crusader from 1964 after a y...
Aircraft decals and paint masks (military)
Future Releases
£12.00
£10.80
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
Syhart Decal SY48128
1:48
Dassault Rafale M #30 "100 years arrested landing" CEPA 10S 2020 On October 20, 1920 in Toulon harbor, Lieutenant de Vaisseau Teste, experimented the first arrested deck landing, on the battleship Bƒ©arn aboard a Hanriot HD2 equipped with hooks, To mark the centenary of this event which will mark the beginning of modern naval aviation, the CEPA 10S (practical experimentation Center naval aviation) based on Hyƒ"res NAS deco...
Aircraft decals and paint masks (military)
Future Releases
£12.00
£10.80
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
Syhart Decal SY48135
1:48
McDonnell F-4F Phantom II 37+16 & Panavia Tornado IDS 45+03 "50 Jahre WTD-61" 2007 This decals set contains all markings to complete two aircrafts Faced with the need to evaluate the aircraft of the future Luftwaffe, Wehrtechnische Dienststelle 61 (WTD 61) , literally "military technical center" was created in 1957. It is the dedicated flight test and development center for all German military aircraft, based in Manching...
Aircraft decals (military)
Future Releases
£16.00
£14.40
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
Syhart Decal SY48149
1:48
Dassault-Mirage 2000N 4-BA "La Fayette tail art" EC 2/4 "La Fayette" 1998
Aircraft decals (military)
Future Releases
£13.00
£11.70
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
Syhart Decal SY48150
1:48
Lockheed-Martin F-16AM Falcon FA-87 "Tigermeet 2011-2012" "31 Tigers" Belgian AF
Aircraft decals (military)
Future Releases
£25.00
£22.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
Syhart Decal SY48919
Dassault-Mirage 2000 "Stencils" - (all versions) - This set 1/48 consists of : - 2 decals sheets (1 large + 1 smaller) - 3 colored pages of instructions (2x A4 + 1x A5) (front / back).
Aircraft decals (military)
Future Releases
£8.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
Syhart Decal SY48921
Dassault Rafale "Export versions" (part 3) - Croatia - "Croatian Air Force" This set 1/48 consists of : - 2 decals sheets - 2 colored pages of instructions (1x A4 + 1x A5) (front / back). - 1 set of masks for anti-skid zones and tail by paint.
Aircraft decals (military)
Future Releases
£8.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
Syhart Decal SY72125
Re-printed! Dassault Rafale M "100 ans Flottille 11F" 2019. The Flottille 11F celebrated its 100th anniversary in September 2019, inheriting the traditions of the B102 Squadron created in 1919. For this centenary it is not less than five Rafale M who received special tails: - The right side is identical on all five aircrafts, with the colors of 100th anniversary of the flottille 11F - The left sides are different for eac...
Aircraft decals (military)
Future Releases
£9.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
Syhart Decal SY72127
1:72
Dassault-Rafale M #5 "70 years Flottille 12F" 2018 The Flottille 12F was created in 1948, heir to the AC2 Squadron of which it kept the badge, it took part in many conflicts such as Indochina, or in North Africa from the aircraft carriers Arromanches and Bois-Belleau, but also from land bases. The Flottille 12F, was successively equipped with Seafire, Hellcat, Corsair, then was converted on F-8 Crusader from 1964 after a y...
Aircraft decals and paint masks (military)
Future Releases
£8.99
£8.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

No Image
Syhart Decal SY72128
Dassault Rafale M #30 "100 years arrested landing" CEPA 10S 2020 On October 20, 1920 in Toulon harbor, Lieutenant de Vaisseau Teste, experimented the first arrested deck landing, on the battleship Bƒ©arn aboard a Hanriot HD2 equipped with hooks, To mark the centenary of this event which will mark the beginning of modern naval aviation, the CEPA 10S (practical experimentation Center naval aviation) based on Hyƒ"res NAS deco...
Aircraft decals and paint masks (military)
Future Releases
£8.99
£8.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

No Image
Syhart Decal SY72149
Dassault-Mirage 2000N 4-BA "La Fayette tail art" EC 2/4 "La Fayette" 1998
Aircraft decals (military)
Future Releases
£10.00
£9.00
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
Syhart Decal SY72150
Lockheed-Martin F-16AM Falcon FA-87 "Tigermeet 2011-2012" "31 Tigers" Belgian AF
Aircraft decals (military)
Future Releases
£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
Syhart Decal SY72915S
Dassault Rafale B/C/M "Standard stencils" (French versions) this decals set contains the "stencils only" allowing you to make other French Rafales, as long as you have registrations and badges left, without needing to get other complete Syhart SY72915V2 decals sets.
Aircraft decals (military)
Future Releases
£6.99
£6.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
Syhart Decal SY72915V2
Dassault Rafale B/C/M standards "Armĩe de l'Air & Marine"(version 2020)
Aircraft decals (military)
Future Releases
£12.99
£11.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
Syhart Decal SY72921
Dassault Rafale "Export versions" (part 3) - Croatia - "Croatian Air Force" - This set 1/72 consists of : - 2 colored pages of instructions (1x A4 + 1x A5) (front / back). - 1 set of masks for anti-skid zones, and tail by paint.
Aircraft decals (military)
Future Releases
£6.99
£6.29
Out of Stock
0


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