Query: SELECT `Product`.`number`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `mediums` AS `Medium` ON (`Product`.`medium_id` = `Medium`.`id`) WHERE category_id = AND `Product`.`number` < NULL ORDER BY `Product`.`number` DESC LIMIT 1
Query: SELECT `Product`.`number`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `mediums` AS `Medium` ON (`Product`.`medium_id` = `Medium`.`id`) WHERE category_id = AND `Product`.`number` > NULL ORDER BY `Product`.`number` ASC LIMIT 1
Carved in Stone - Anything But Ordinary - Products