| Query SQL | : SELECT DISTINCT
`products`.`alias_cate_parent`,
`products`.`alias`,
`products`.`thumb_img`,
`products`.`thumb_img_id`,
`products`.`sku`,
`products`.`title`,
`products`.`price_old`,
`products`.`price_new`,
`products`.`vote_percent`,
`products`.`sale`,
`products`.`product_length`,
`products`.`product_diameter`,
`products`.`product_power`,
`products`.`product_function`,
`products`.`brand`,
`products`.`who`,
`products`.`product_function`,
`products`.`home`,
`products`.`home2`,
`products`.`shop_75`,
`products`.`hanoi`
FROM
(`products` INNER JOIN `stock_total` ON `products`.`sku` = `stock_total`.`sku`)
WHERE `stock_total`.`qty` > 0 AND `products`.`hide` = 0 AND (`products_cate`.`parent_id`= 1 OR `products_cate`.`id`= 1) AND `products`.`product_function` LIKE '%(7)%' |