- Àα⿩ÇàÁö
- ±¹³»
- Áß±¹
- ÀϺ»
- º£Æ®³²
- Çʸ®ÇÉ
- ¾Æ½Ã¾Æ
- À¯·´
- ¿À¼¼¾Æ´Ï¾Æ
- ºÏ¾Æ¸Þ¸®Ä«
- ½ºÅ¸ÀÏ
- ·¹ÀÌÇ÷¿
- Ä«Å»·Î±×ºÏ
- ¼ÒÇÁÆ®ºÏ
- ÆäÀÌÆÛºÏ
- DIY
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
query | select distinct *, (select price1 from mini_goods_opt where goodsno=b.goodsno and price1 > 0 limit 1) price, (select primeprice from mini_goods_opt where goodsno=b.goodsno and type=0 and idx=0 order by no limit 1) primeprice from mini_goods_link a left join mini_goods b on a.goodsno=b.goodsno where INSTR(a.catno,'100004013') and state > -1 and b.goodsno <> '27129' order by rand() limit 4 |
file | /home/jumbo/public_html/goods/view.php (line:776) /home/jumbo/public_html/lib/template_/Template_.class.php (line:89) /home/jumbo/public_html/lib/template_/Template_.class.php (line:155) /home/jumbo/public_html/_compile/fashion/goods/view_2.htm.php (line:838) /home/jumbo/public_html/lib/template_/tpl_plugin/function.f_getRelGoods.php (line:42) |