SELECT products.* , main_sec.name as main_sec_name, sub_sec1.name as sub_sec1_name FROM products left join main_sec on products.id_main_sec = main_sec.id_main_sec left join sub_sec1 on products.id_sub_sec1 = sub_sec1.id_sub_sec1 where products.id_main_sec= 1