SQL Query:
Select * from `mls_group_access`

SQL Query:
Select * from `mls_group_config`

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 *,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 p.*, img.image AS image, c.id AS company_id, c.company_name  FROM `mls_products` AS p
                  LEFT JOIN (
                      SELECT MIN(id) as id, productid, image FROM `mls_product_image` 
                      WHERE status = 1 GROUP BY productid
                  ) AS img ON img.productid = p.id
                  LEFT JOIN `mls_company` AS c ON c.id = p.company_id WHERE p.status = 1 AND p.company_id IN (
            SELECT DISTINCT c_id FROM `mls_company_user`
            WHERE u_id IN (
                SELECT userid FROM `mls_users` WHERE status = 1
            )
        ) AND c.membercode_id IN (
                SELECT id FROM `mls_member_code` WHERE status = 1 AND membercode_status = 'active'
            ) AND p.id IN (
                    SELECT DISTINCT productid FROM `mls_product_category`
                    WHERE categoryid IN ('1044','1045','1046','1047','1048','1049','1050','1051','1052','1053','1054','1055','1056','1057','1058','1059','1060','1061','1062','1063','1064','1065','1066','1067','1068')
                ) ORDER BY p.id desc LIMIT -12, 12