Banner1 Banner1
 
here==>SELECT `dsp`.`sku`, `dsp`.`vendor`, `dsp`.`price`,`pinfo`.`unit_of_measure`,`pinfo`.`category_name`,`pinfo`.`desc_short`,`pinfo`.`desc_title`,`pinfo`.`manufacturer_name`, `pinfo`.`desc_long`, `pinfo`.`image_name_thumbnail`, `pinfo`.`image_name_large`,`ve`.`vendor_name` FROM `dealer_special` `dsp`, `product_info` `pinfo`, `vendors` `ve` , `contract_price_12` AS `crp` WHERE `dsp`.`start_date` <= '2017-12-14' AND `dsp`.`expiration_date` >= '2017-12-14' AND `dsp`.`status`='Active' AND `dsp`.`sku`=`pinfo`.`sku` AND `dsp`.`vendor`=`pinfo`.`vendor` AND `pinfo`.`vendor`=`ve`.`vendor_id` AND `dsp`.`vendor`=`ve`.`vendor_id` AND `crp`.`sku`=`pinfo`.`sku` order by `dsp`.`pick_order` limit 0, 5here==>SELECT `dsp`.`sku`, `dsp`.`vendor`, `dsp`.`price`,`pinfo`.`unit_of_measure`,`pinfo`.`category_name`,`pinfo`.`desc_short`,`pinfo`.`desc_title`,`pinfo`.`manufacturer_name`, `pinfo`.`desc_long`, `pinfo`.`image_name_thumbnail`, `pinfo`.`image_name_large`,`ve`.`vendor_name` FROM `dealer_special` `dsp`, `product_info` `pinfo`, `vendors` `ve` , `contract_price_12` AS `crp` WHERE `dsp`.`start_date` <= '2017-12-14' AND `dsp`.`expiration_date` >= '2017-12-14' AND `dsp`.`status`='Active' AND `dsp`.`sku`=`pinfo`.`sku` AND `dsp`.`vendor`=`pinfo`.`vendor` AND `pinfo`.`vendor`=`ve`.`vendor_id` AND `dsp`.`vendor`=`ve`.`vendor_id` AND `crp`.`sku`=`pinfo`.`sku` order by `dsp`.`pick_order` limit 5, 3

Your Shopping Cart is Empty


Add one of our Special Product.

Specials

 
 

© 2017-2018 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved