Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT `devices`.*, `inventory`.`quantity`, ROUND(`devices`.`price` - `discounts`.`amount`,2) AS `sort_price` FROM `devices` LEFT JOIN `inventory` ON `inventory`.`sku`=`devices`.`sku` LEFT JOIN `device_discounts_xref` ON `device_discounts_xref`.`device_id`=`devices`.`id` LEFT JOIN `discounts` ON `discounts`.`id`=`device_discounts_xref`.`discount_id` WHERE `devices`.`active`='1' ORDER BY `sort_price`
Join the community of 500,000 technology professionals and ask your questions.