SELECT * FROM `inventory_products` WHERE (keywords LIKE '%_Crankshaft_%') AND (status != 'deactive' AND status != 'pending') AND oem_part_id IS NULL ORDER BY created_at DESC, is_sold DESC LIMIT 0, 30