2013-05-21T12:36:51-07:00

SELECT products.*,
IF(products.url_custom='',products.url_default,products.url_custom) AS product_url,
catalog.name AS cat_name,
IF(catalog.url_custom='',catalog.url_default,catalog.url_custom) AS cat_url,
manufacturer_name
FROM products
INNER JOIN products_categories ON products_categories.pid = products.pid AND ( products_categories.cid='137' OR products_categories.cid='228' OR products_categories.cid='229' OR products_categories.cid='286' OR products_categories.cid='294' OR products_categories.cid='230' OR products_categories.cid='300' OR products_categories.cid='231' OR products_categories.cid='232' OR products_categories.cid='233' OR products_categories.cid='270' OR products_categories.cid='271' OR products_categories.cid='234' OR products_categories.cid='288' OR products_categories.cid='246' OR products_categories.cid='290' OR products_categories.cid='296' OR products_categories.cid='235' OR products_categories.cid='236' OR products_categories.cid='237' OR products_categories.cid='272' OR products_categories.cid='238' OR products_categories.cid='239' OR products_categories.cid='240' OR products_categories.cid='241' OR products_categories.cid='291' OR products_categories.cid='242' OR products_categories.cid='244' OR products_categories.cid='245' OR products_categories.cid='247' OR products_categories.cid='283' OR products_categories.cid='248' OR products_categories.cid='249' OR products_categories.cid='250' OR products_categories.cid='297' OR products_categories.cid='298' OR products_categories.cid='301' OR products_categories.cid='251' OR products_categories.cid='252' OR products_categories.cid='253' OR products_categories.cid='292' OR products_categories.cid='255' OR products_categories.cid='256' OR products_categories.cid='257' OR products_categories.cid='258' )
INNER JOIN catalog ON products.cid=catalog.cid
LEFT JOIN manufacturers ON manufacturers.is_visible='1' AND products.manufacturer_id = manufacturers.manufacturer_id
WHERE products.is_visible='Yes'
AND
(
-- No stock control, pull the data
products.inventory_control = 'No'
OR
-- Has any stock at all
products.stock > 0
OR
-- Has Display Out Of Stock rule
products.inventory_rule = 'OutOfStock'
OR
(products.inventory_control = 'AttrRuleInc' AND products.stock >= 0)
)

GROUP BY products.pid
ORDER BY products.price, products.title
LIMIT 2376, 18

Incorrect key file for table '/tmp/mysqltmp/#sql_134e_1.MYI'; try to repair it