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=362639
		 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 18 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
DK Decals DKD32042
Bell P-39/P-400 Airacobra 1. P-39N Airacobra, Capt. G.A. Hilbert, 41st FS, 35th FG, New Guinea 1943 2. P-400 Airacobra, AP356, Lt. J. Kurt, 35th FS, 8th FG, New Guinea 1942/43 3. P-39Q, 42-19993, Lt. P. McDermott, 82nd TRS, 71st TRG, New Guinea 1944
Aircraft decals (military)
Future Releases
£22.50
£20.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

DK Decals DKD48015
Re-print! Spitfire Mk.IXc/Mk.IXe Aces 1. Spitfire Mk.IX, EN398, W/Cdr E.J.Johnson 2. Spitfire Mk.IX, MK392, W/Cdr E.J.Johnson 3. Spitfire Mk.IX, BS240, W/Cdr R.M.Milne 4. Spitfire Mk.IX, BS430, S/L F.H.Boulton 5. Spitfire Mk.IX, EN473, S/L D.E.Kingaby 6. Spitfire Mk.IX, ML214, S/L J. Plagis 7. Spitfire Mk.IX, MK144, S/L A.G.Page 8. Spitfire Mk.IX, MH434, F/O H.P.Lardner-Burke 9. Spitfire Mk.IX, BS538, Sgt P.H.Closterm...
Aircraft decals (military)
Future Releases
£18.40
£16.56
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

DK Decals DKD48018
Re-print! Supermarine Spitfire Mk.I/II Aces 1. Spitfire Mk.IIA, P8084, No.64 Sq. RAF, F/Lt J.J. O'Meara, victory 11+2 - 4 - 11+1 2. Spitfire Mk.IA, N3180, No.54 Sq. RAF, P/O A.C. Deere, victory 17+1 - 4 7+1 3. Spitfire Mk.IIA, P7966, Tangmere Wing, W/Cdr D.R.S. Bader, victory 20+4 - 6+1 - 11 4. Spitfire Mk.IA, N3093, No.616 Sq. RAF, F/Lt D.E. Gillam, victory 7+1 - 3 - 6 5. Spitfire Mk.IA, X4036, No.234 Sq. RAF, P/O R.F.T....
Aircraft decals (military)
Future Releases
£18.40
£16.56
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
DK Decals DKD48040
RE-PRINTED!!! North-American P-51A/A-36A over China, Burma and India 1. P-51A-1 Mustang, pilot Capt. J.J. England, 530th FS, 311th FG, India 1944 2. P-51A-10 Mustang, pilot Lt. C. Bray, 530th FS, 311th FG, India 1944 3. P-51A-1 Mustang, pilot Maj. R.T. Smith, 1st ACG, India 1944 4. P-51A-1 Mustang, pilot Capt. P. Forcey, 1st ACG, India 1944 5. P-51A-1 Mustang, 76th FS, 23rd FG, China 1943 6. P-51A-1 Mustang, 76th FS, 23r...
Aircraft decals (military)
Future Releases
£15.80
£14.22
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
DK Decals DKD48055
WWII RAAF Twins Pt.2: Bristol Beaufighter, Douglas Boston, North-American Mitchell 1. Beaufighter Mk.21, A8-14, No.31 Sq. RAAF, Morotai 1945é 2. A-20G Boston, A28-60, No.22 Sq. RAAF, New Guinea 1944é 3. B-25J Mitchell, A47-27, No.2 Sq. RAAF, Australia 1944
Aircraft decals (military)
Future Releases
£13.99
£12.59
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
DK Decals DKD48056
WWII RAAF Twins Pt.3: Ventura, Anson, Catalina 1. PV-1 Ventura, A59-89, No.13 Sq. RAAF, Australia 1944é 2. Anson Mk.I, AX261, No.73 Sq. RAAF, Australia 1944é 3. PBY-5A Catalina, A24-112, ASR Flight, Australia 1945é
Aircraft decals (military)
Future Releases
£13.30
£11.97
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
DK Decals DKD48057
WWII RAAF Twins Pt.4: Wellington, Ventura, Baltimore 1. Wellington Mk.VIII, HX509, No.458 (RAAF) Sq., MTO 1943é 2. Ventura GR Mk.V, FP612, No.459 (RAAF) Sq., MTO 1943é 3. Baltimore Mk.IV, FA603, No.454 (RAAF) Sq., MTO 1943é
Aircraft decals (military)
Future Releases
£13.99
£12.59
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
DK Decals DKD48064
Bell P-39/P-400 Airacobra 1. P-400 Airacobra, BW146, 67th FS, 347th FG, Guadalcanal 1942 2. P-39N Airacobra, 42-18812, Lt. E.W. Kyro, 41st FS, 35th FG, New Guinea 1943 3. P-39D, 41-38338, Lt. D.C. McGee, 36th FS, 8th FG, New Guinea 1942/1943é 4. P-39Q, 42-19993, Lt. P. McDermott, 82nd TRS, 71st TRG, New Guinea 1944é 5. P-39D, 41-38401, Maj. N.G. Morris, New Guinea 1942/43é 6. P-39D Airacobra, 333rd FS, 318th FG, Hawai...
Aircraft decals (military)
Future Releases
£20.50
£18.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
DK Decals DKD48065
Early Strafers 'The Grim Reapers' 1942-43 1. A-20A Havoc, 40-101, 89th BS, New Guinea 1942é 2. A-20A Havoc, 40-3151, 89th BS, New Guinea 1942 3. A-20A Havoc, 40-170, 89th BS, New Guinea 1942é 4. North-American B-25C Mitchell, 41-12946, 90th BS, Australia 1942é 5. North-American B-25C Mitchell, 41-12437, 90th BS, New Guinea 1943é 6. North-American B-25D Mitchell, 41-30766, 13th BS, New Guinea 1943é
Aircraft decals (military)
Future Releases
£19.40
£17.46
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
DK Decals DKD48066
North-American B-25C/D Mitchell 'The Grim Reapers' 1942 1. North-American B-25C Mitchell, 41-12962, 13th BS, Australia 1942 2. North-American B-25D Mitchell, 41-29709, 13th BS, New Guinea 1942 3. North-American B-25C, 41-12443, 13th BS, 1/Lt. R.A. Price, New Guinea 1942 4. North-American B-25C, 41-12449, 90th BS, Capt. W.R. Johnson, New Guinea 1942 5. North-American B-25D Mitchell, 41-29737, 13th BS, Australia 1942é 6. ...
Aircraft decals (military)
Future Releases
£18.40
£16.56
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
DK Decals DKD48067
A-20A Havoc 'The Grim Reapers' 1942 1. A-20A Havoc, 40-146, 89th BS, Lt. Langley, New Guinea 1942é 2. A-20A Havoc, 40-173, 89th BS, Lt. J.B. Roan, New Guinea 1942é 3. A-20A Havoc, 40-143, 89th BS, New Guinea 1942é 4. A-20A Havoc, 40-109, 89th BS, New Guinea 1942 5. A-20A Havoc, 40-139, 89th BS, New Guinea 1942 6. A-20A Havoc, 40-094, 89th BS, Ch. Mayo, New Guinea 1942
Aircraft decals (military)
Future Releases
£19.40
£17.46
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
DK Decals DKD48068
North-American P-51B/P-51C Mustang over CBI China, Burma and India 1. P-51B Mustang, 43-7060, 74th FS, 23rd FG, Maj. J.C. Herbst, China 1945 2. P-51B Mustang, 43-7060, 74th FS, 23rd FG, Maj. J.C. Herbst, China 1945 3. P-51C Mustang, 75th FS, 23rd FG, Lt. C.W. Mahannah, China 1944 4. P-51B Mustang, 43-12405, 76th FS, 23rd FG, Col. D.L. Hill, China 1944 5. F-6C Mustang, 118th TRS, Lt.Col. E.O. McComas, China 1945 6. P...
Aircraft decals (military)
Future Releases
£TBA
£TBA
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

DK Decals DKD72005
RE-PRINTED!!! Dornier Do-24T & Catalina in RAAF and NEIAF (2 + 6 camouflage schemes) 1. Consolidated PBY-5A Catalina, A24-91, No.111 ASR Flight, 1945 2. Consolidated PBY-5A Catalina, A24-64, No.43 Sq. RAAF, Australia 1943 3. Consolidated PBY-4 Catalina, A24-29, No.20 Sq. RAAF, New Guinea 1943 4. Consolidated PBY-5A Catalina, A24-65, No.43 Sq. RAAF, Australia 1943 5. Consolidated PBY-5A Catalina, A24-17, No.11 Sq. RAAF, 19...
Aircraft decals (military)
Future Releases
£17.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

DK Decals DKD72041
Re-print! 345th BG North-American B-25 Mitchells over the Pacific. 1. B-25D-10 Mitchell, 41-30315, 498th BS, New Guinea 1944 2. B-25D-10 Mitchell, 41-30176, 498th BS, New Guinea 1943 3. B-25J-22 Mitchell, 44-29577, 498th BS, the Philippines 1945 4. B-25H-1 Mitchell, 43-4345, 498th BS, New Guinea 1944 5. B-25C Mitchell, 41-12971, 499th BS, New Guinea 1943 6. B-25D-10 Mitchell, 41-30276, 499th BS, the Philippines 1945 7...
Aircraft decals (military)
Future Releases
£20.30
£18.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

DK Decals DKD72043
Re-print! American B-25 Mk.II/Mk.III Mitchell in RAF Service 1. Mitchell Mk.II, FV-905, No.226 Sq. RAF 2. Mitchell Mk.II, FW-111, No.226 Sq. RAF 3. Mitchell Mk.II, FV-938, No.98 Sq. RAF 4. Mitchell Mk.II, FW-189, No.98 Sq. RAF 5. Mitchell Mk.II, FL-176, No.98 Sq. RAF 6. Mitchell Mk.II, FW-218, No.98 Sq. RAF 7. Mitchell Mk.II, FR189, No.320 (Dutch) Sq. RAF 8. Mitchell Mk.III, HD392, No.320 (Dutch) Sq. RAF 9. Mitchell...
Aircraft decals (military)
Future Releases
£14.85
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

DK Decals DKD72051
Re-print! Curtiss P-40E/P-40F/P-40K in over the Pacific (Includes 18 camouflage schemes) 1. P-40E Warhawk, 9th FS, 49th FG, Capt. J.J. Kruzel, Australia 1942 2. P-40E Warhawk, 8th FS, 49th FG, Capt. C.C.Johnson, Australia 1942 3. P-40E Warhawk, 68th FS, 13rd AAF, Tongatabu 1942 4. P-40E Warhawk, 72nd FS, 15th FG, Hawaii 1942 5. P-40K Warhawk, 78th FS, 15th FG, Kauai Island 1943 6. P-40K Warhawk, 45th FS, 15th FG, CVE B...
Aircraft decals (military)
Future Releases
£18.40
£16.56
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

DK Decals DKD72052
Re-print! Curtiss P-40K/P-40M/P-40N 1. P-40F Warhawk, 44th FS, 18th FG, Guadalcanal 1943 2. P-40M Warhawk, 44th FS, 18th FG, Capt F. Gaunt, New Georgia 1943 3. P-40N Warhawk, 110th TRS, Leyte 1944 4. P-40N Warhawk, 72nd TRG, New Guinea 1944 5. P-40N Warhawk, 8th FS, 49th FG, CO E. Harris, New Guinea 1943 6. P-40N Warhawk, 8th FS, 49th FG, Lt. M. Felt, New Guinea 1944 7. P-40N Warhawk, 35th FS, 8th FG, 1st Lt R.L. Wes...
Aircraft decals (military)
Future Releases
£18.40
£16.56
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

DK Decals DKD72056
1:72
Re-print! Supermarine Spitfire MTO Aces (35 camouflage schemes) 1. Spitfire Mk.VB ER652, F/O A.F. Aikman 2. Spitfire Mk.VC BR392, F/O M.R.B. Ingram 3. Spitfire Mk.VC ER486, S/L J. Morgan 4. Spitfire Mk.VC BR476, S/L J.H. Wedgwood 5. Spitfire Mk.VB ER220, F/O N.F. Duke 6. Spitfire Mk.VB, ER821, F/L N.F. Duke 7. Spitfire Mk.VB EP401, P/O J.L. Waddy 8. Spitfire Mk.VB ES252, S/L L.C. Wade 9. Spitfire Mk.VC BR175, P/O D. Ib...
Aircraft decals (military)
Future Releases
£18.40
£16.56
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