Цена
от
до
select SQL_CALC_FOUND_ROWS l.* from jos_wmart_trade_lot as l inner join jos_wmart_trade_product as p on p.id=l.product_id inner join jos_wmart_trade_stock_quantity as tsc2 on tsc2.lot_id=l.id and tsc2.quantity>0 and tsc2.stock_id in ("1") where p.category_id in ("18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "33", "34", "1") and l.active=1 and l.iactive=1 group by l.id order by l.hits limit 0,42 Disk full (/tmp/#sql-temptable-1962d3-20caaa-411b2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")