| select * ,if(p_soldout_chk='N',p_stock,0) as p_stock from smart_display_main_product as dmp INNER JOIN smart_product as p on dmp_pcode=p.p_code left outer join smart_brand as sb ON p_brand=sb.c_uid where (1) and dmp_dmsuid IN (66,21) AND (p_state_kind ='N' OR (p_state_kind ='O' )) and p_view = 'Y' and p_option_valid_chk = 'Y' ORDER BY p_idx DESC limit 2540, 20 |
| Disk full (/tmp/#sql_3e3bef_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") |
| 1021 |