子查询

最新推荐文章于 2024-12-02 00:15:00 发布

echo_just_do_it

最新推荐文章于 2024-12-02 00:15:00 发布

阅读量121

点赞数

分类专栏： php

本文链接：https://blog.youkuaiyun.com/qq_27930635/article/details/98335493

版权

php 专栏收录该内容

35 篇文章

订阅专栏

select sale_num,a.user_id as s_id,a.company_name,b.img1,b.id as goods_id,b.g_name,b.g_code,b.good_address,b.car_type,
    b.brand,b.specification,c.ycqyxl_price,c.integral,c.gid,c.status,c.ycsq_price,c.wxqy_status,c.integral_status,
   c.qy_price from wd_user as a,' . $table2 . ' as b,
    (select integral_status,wxqy_status,sale_num,ycqyxl_price,integral,gid,status,ycsq_price,xlqy_price as qy_price from ' . $table3 . ') as c
      where (a.user_id = b.mid and b.id=c.gid ' . $where_type . $where_stock . ') ' . $where_search . '
    order by sale_num desc,b.img1 desc,id desc  limit ' . $start . ',' . $pagesize