SELECT G.*, (SELECT fold FROM medtorg_cat WHERE idc = 0 && type='rcat' LIMIT 1) catFold, (SELECT imgmini FROM medtorg_img WHERE idc=G.id && type='goods' && general=1 LIMIT 1) img, C.fold bFold, C.name bName, (SELECT fold FROM medtorg_cat WHERE idc = 0 && type = 'brand' LIMIT 1) bParent, (SELECT fold FROM medtorg_cat WHERE id = G.idc && type='rcat' LIMIT 1) prntFold FROM medtorg_goods as G, medtorg_cat as C WHERE G.idc = 68 && G.hide = 0 && C.id = G.brandID ORDER BY G.num LIMIT -10, 10