SQL Query:
 SELECT *,if(parentid=0,id,parentid) as ordered_sub_category  FROM `mls_product_categorylist`  WHERE status = 1  order by ordered_sub_category , parentid 

SQL Query:
SELECT r.*, c.id as company_id, c.company_name  FROM `mls_requirements` as r  LEFT JOIN `mls_users` as u on u.userid = r.userid  LEFT JOIN `mls_company_user` as cu on cu.u_id = u.userid  LEFT JOIN `mls_company` as c on c.id = cu.c_id  WHERE r.status = 1 AND u.status = 1  AND  r.id IN (SELECT distinct requirementid FROM `mls_requirement_category` WHERE categoryid IN ('1395','1374','1396','1397','1398')) 

SQL Query:
 SELECT *,if(parentid=0,id,parentid) as ordered_sub_category  FROM `mls_product_categorylist`  WHERE status = 1  order by ordered_sub_category , parentid 

SQL Query:
SELECT r.*, c.id as company_id, c.company_name  FROM `mls_requirements` as r  LEFT JOIN `mls_users` as u on u.userid = r.userid  LEFT JOIN `mls_company_user` as cu on cu.u_id = u.userid  LEFT JOIN `mls_company` as c on c.id = cu.c_id  WHERE r.status = 1 AND u.status = 1  AND  r.id IN (SELECT distinct requirementid FROM `mls_requirement_category` WHERE categoryid IN ('1395','1374','1396','1397','1398'))  ORDER BY created_at asc LIMIT -12, 12