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 pt.id=3080 AND ps.id = 1008 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
X Cookies
Cookies are small text files that are placed on your computer by
websites that you visit. They are widely used in order to make
websites work, or work more efficiently, as well as to provide
information to the owners of the site.
Here is a list of cookies this site uses:
Cookie name
Description
existing_user
Stores the email address used to previously log into the site, used to prefill forms like on the reset password screen
authchallenge
Authentication security checks
hcart
Stores the anonymous customer\'s cart token. If items are added to the card while not logged in, if you log in the items will be added to the customer\'s existing cart
hannants
Stores the session information while you remain on the site
pricer
Stores if the export or eu prices is selected on the catalogue page
hidefilter
Stores if the search filter panel is hidden or shown
AWSELB
Stores which server you\'re connected to so to access the same server while you navigate around the site
__utma
Google analytics related cookies
Catalogue
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
Scale
Product Type
Manufacturer
Added Within
Nedlloyd Lines Rouen
Ship kits, full hull (injection)
Catalogue
£39.99
-
2
1:450
Admiral Nelson Flagship (H.M.S. Victory) New Tool
Ship kits, full hull (injection)
Catalogue
£13.99
-
4
We are sorry but we cannot post aerosols
Advanced Search 
