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 
string(0) "" string(1071) "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 ('944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','966','967','968') ) ORDER BY p.id desc LIMIT -12, 12"