SELECT `products`.`id`, `products`.`name`, `products`.`description`, `products`.`name_en`, `products`.`description_en`, `products`.`price`, `products`.`media`, `products`.`price`, `products`.`special_price`, `products`.`referencia`, `products`.`gadgets`, `products`.`promos`, `products`.`weight`
FROM `wp_wpsc_item_category_assoc` AS `cats`
JOIN `wp_wpsc_product_list` as `products`
ON `cats`.`product_id` = `products`.`id`
WHERE `cats`.`category_id` = '848'
AND `products`.`publish`='1'
-- AND `products`.`promociones` IN ('0') AND `products`.`avances` IN ('0')
AND `products`.`active` = '1' ORDER BY `products`.`weight` DESC, `products`.`date_added` DESC
*0*