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"