SELECT top 100
            p.product_id,
            p.manufacturer_id,
            p.sku,
            p.image,
            p.price,
            p.adaos,
            pd.name,
            pd.short,
            p.promo,
            p.related, 
            p.tax_class_id,
            pd.alias,
            p.stoc,
            p.old_price,
            s.name as stock,
            p.stock_status_id,
            pp.image AS promo_image,
            pp.price AS promo_price,
            pp.old_price AS promo_old_price,
            pp.from_date,
            pp.to_date,
            pp.status AS promo_status,
            pp.stockout,
            m.name AS brand,
            m.alias AS brand_alias,
            m.image AS brandim,
            p.sd,p.od,p.bd,
            p.promo_black_friday as product_promo_black_friday,
            p2c.category_id
            FROM product AS p
            LEFT JOIN product_description AS pd ON (p.product_id = pd.product_id)
            LEFT JOIN product_to_category AS p2c ON (p.product_id = p2c.product_id)
			LEFT JOIN category_description AS cd ON cd.category_id=p2c.category_id
            LEFT JOIN stock_status AS s ON (s.stock_status_id=p.stock_status_id)
            LEFT JOIN product_promo AS pp ON p.product_id = pp.product_id
            LEFT JOIN manufacturer AS m ON m.manufacturer_id = p.manufacturer_id
            WHERE
            	p.status=1
            	AND p.bundled=0
            	AND p.product_id LIKE '%m%t%'
                AND p.price > 0
                AND NOT p2c.category_id IN (246,205,207)
				AND (pd.name LIKE '%m%t%' 
                      OR pd.description LIKE '%m%t%' OR pd.short LIKE '%m%t%')  AND m.alias IN ('develop','advantech','Linkbasic','Seiko-Instruments','PocketBook','heinner','sharp','adata','allied')  ORDER BY s.`order` ASC  LIMIT 0,16