Detectors

Fire

Accessories (20)

Bases (35)

CO (7)

Conventional

Duct (15)

Fire Beam Detector (1)

Flame (1)

Flow (18)

Gas (4)

Heat (45)

Interfase Module (2)

Multicriteria (2)

Pressure (3)

Smoke (56)

Smoke & CO (10)

Smoke & Heat (19)

Sorting

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price

from ( products p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id , products_description pd, categories c, products_to_categories p2c

where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '96' or p2c.categories_id = '97' or p2c.categories_id = '98' or p2c.categories_id = '112' or p2c.categories_id = '107' or p2c.categories_id = '108' or p2c.categories_id = '176' or p2c.categories_id = '117' or p2c.categories_id = '118' or p2c.categories_id = '168' or p2c.categories_id = '164' or p2c.categories_id = '165' or p2c.categories_id = '333' or p2c.categories_id = '169' or p2c.categories_id = '170' or p2c.categories_id = '334' or p2c.categories_id = '171' or p2c.categories_id = '172' or p2c.categories_id = '173' or p2c.categories_id = '335' or p2c.categories_id = '174' or p2c.categories_id = '175' or p2c.categories_id = '183' or p2c.categories_id = '184' or p2c.categories_id = '232' or p2c.categories_id = '233' or p2c.categories_id = '278' or p2c.categories_id = '279' or p2c.categories_id = '284' or p2c.categories_id = '285' or p2c.categories_id = '355' or p2c.categories_id = '383' or p2c.categories_id = '384' or p2c.categories_id = '386' or p2c.categories_id = '385') and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")

group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name

Kewords:

Plural keywords: