SELECT SQL_CALC_FOUND_ROWS `productos`.* FROM `cms_productos` as `productos` WHERE (parentNum = ) ORDER BY globalOrder DESC LIMIT 1000