Click to Close
Click to Close

Click to Zoom
Hover to Switch

No-Xplode 2.25 lb by BSN

by BSN · #AN12848 ·
Product Options
1 - Can't create/write to file '/tmp/#sql_3c1_0.MYI' (Errcode: 28)

SELECT DISTINCT ps.avid_sku, ps.sku_instock_message, ps.products_id, ps.msrp, ad.avid_dropdowns_name, linked_image, ps.price, IF (ads.avid_dropdowns_subvalues_id IS NOT NULL, (SELECT avid_dropdowns_subvalues_name from avid_dropdowns_subvalues where avid_dropdowns_subvalues_id = ads.avid_dropdowns_subvalues_id), adv.avid_dropdowns_values_name) as avid_dropdowns_values_name FROM products_skus ps LEFT JOIN avid_dropdowns_skus ads ON ps.avid_sku = ads.avid_sku LEFT JOIN avid_dropdowns_values adv ON ads.avid_dropdowns_id = adv.avid_dropdowns_id LEFT JOIN avid_dropdowns ad ON ad.avid_dropdowns_id = ads.avid_dropdowns_id WHERE ps.products_id = '1499' AND adv.avid_dropdowns_id = ads.avid_dropdowns_id AND adv.avid_dropdowns_values_id = ads.avid_dropdowns_values_id AND = 1 ORDER BY avid_sku, avid_dropdowns_name