sql

最新推荐文章于 2025-06-08 20:27:44 发布

转载最新推荐文章于 2025-06-08 20:27:44 发布 · 49 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/258w/p/9648019.html

if(!empty($site) && $site != 9){
    $siteword = $site;
    $sql = 'SELECT c.id, c.name, c.related_page,c.suitable_siteids, REPLACE(suitable_siteids, 0, 1234567)as rn,c.suitable_sex_flag, c.app_order, c.status, g.num FROM wis_hotwords c LEFT JOIN (select hotwords_id, count(hotwords_id) as num
         from wis_hotwords_log as t
         where '.$whereLog.'
         group by(hotwords_id)) as g ON c.id = g.hotwords_id  where  '.$where.' order by '. $orderWhere.' LIMIT '.$offset.' , '.$pageSize;
}else{
    $sql = 'SELECT c.id, c.name, c.related_page,c.suitable_siteids,c.suitable_sex_flag, c.app_order, c.status, g.num FROM wis_hotwords c LEFT JOIN (select hotwords_id, count(hotwords_id) as num
           from wis_hotwords_log as t
           where '.$whereLog.'
           group by(hotwords_id)) as g ON c.id = g.hotwords_id  where  '.$where.' order by '. $orderWhere.' LIMIT '.$offset.' , '.$pageSize;
}

转载于:https://www.cnblogs.com/258w/p/9648019.html