select p.products_id, p.products_image, p.products_price from PRODUCTS p left join PRODUCTS_TO_CATEGORIES p2c on p.products_id = p2c.products_id left join CATEGORIES c on p2c.categories_id = c.categories_id left join CATEGORIES cf on c.parent_id = cf.categories_id left join CATEGORIES cf2 on cf.parent_id = cf2.categories_id where (c.parent_id = '683' or cf.parent_id = '683' or cf2.parent_id = '683' ) and p.products_status = '1'
