56,675
社区成员
发帖
与我相关
我的任务
分享
SELECT c.id,c.credits,c.companyName,c.companyId
FROM((
SELECT cr.id,(CASE WHEN cr.credits IS NULL THEN 0 ELSE cr.credits END) AS credits ,c.name AS companyName,c.id AS companyId
FROM companies c
LEFT JOIN g_credit_company cr ON cr.companyId = c.id WHERE c.name IS NOT NULL ) AS c)
WHERE 1=1 AND c.companyName LIKE '%的公司%' ORDER BY c.credits DESC LIMIT 0,7 ;
SELECT c.id,c.credits,c.companyName,c.companyId
FROM((
SELECT cr.id,(CASE WHEN cr.credits IS NULL THEN 0 ELSE cr.credits END) AS credits ,c.name AS companyName,c.id AS companyId
FROM companies c
LEFT JOIN g_credit_company cr ON cr.companyId = c.id WHERE c.name IS NOT NULL ) AS c)
WHERE 1=1 AND c.companyName LIKE '%豆豆的公司%' ORDER BY c.credits DESC
SELECT c.id,c.credits,c.companyName,c.companyId
FROM((
SELECT cr.id,(CASE WHEN cr.credits IS NULL THEN 0 ELSE cr.credits END) AS credits ,c.name AS companyName,c.id AS companyId
FROM companies c
LEFT JOIN g_credit_company cr ON cr.companyId = c.id WHERE c.name IS NOT NULL ) AS c)
WHERE 1=1 AND c.companyName LIKE '%豆豆的公司%' ORDER BY c.credits DESC LIMIT 0,7
SELECT c.id,c.credits,c.companyName,c.companyId
FROM((
SELECT cr.id,(CASE WHEN cr.credits IS NULL THEN 0 ELSE cr.credits END) AS credits ,c.name AS companyName,c.id AS companyId
FROM companies c
LEFT JOIN g_credit_company cr ON cr.companyId = c.id WHERE c.name IS NOT NULL ) AS c)
WHERE 1=1 AND c.companyName LIKE '%豆豆的公司%' ORDER BY c.credits DESC LIMIT 7,7