• Facebook
  • Google+
  • Twitter
  • YouTube
  • InstaGram
  • Pinterest
Tombstone Tactical Blog
Tombstone Tactical

800-606-0370

Tombstone Tactical Logo

Tombstone Tactical

800-606-0370

ERROR: - SELECT SQL_NO_CACHE DISTINCT product_id,product_category,product_manufacturer,product_partno,product_active,product_status,product_name,product_title,product_url,product_markup,product_cost,product_sale,product_msrp,product_reserved,product_shipping,product_transfer,product_price,product_quantity,CONCAT_WS(' ',m.manufacturer_name, p.product_partno, p.product_name) AS product_dispname, (COALESCE(NULLIF(p.product_map,'0.00'), NULLIF(p.product_sale,'0.00'), NULLIF(p.product_price, '0.00'), ROUND(p.product_cost * (1 + p.product_markup/100), 2))) AS product_showprice, model.pattr_product_value AS product_model, caliber.pattr_product_value AS product_caliber, action.pattr_product_value AS product_action FROM (product p) INNER JOIN manufacturer m ON manufacturer_id = product_manufacturer AND m.manufacturer_status > 0 LEFT JOIN product_attr_products model ON model.pattr_product_product = p.product_id AND model.pattr_product_attr = 1001 LEFT JOIN product_attr_products caliber ON caliber.pattr_product_product = p.product_id AND caliber.pattr_product_attr = 1002 LEFT JOIN product_attr_products action ON action.pattr_product_product = p.product_id AND action.pattr_product_attr = 1003 WHERE p.product_active = 1 AND m.manufacturer_id = 1058 AND p.product_category IN (1006,1007,1013,1024,1015) AND model.pattr_product_value = 1156 ORDER BY product_quantity DESC