SELECT s.serial_name , p.* FROM ebisu_products p , ebisu_product_serials s WHERE p.serial_id = s.serial_id AND s.is_active = 1 AND (p.is_active = 1 OR p.is_active = 2) AND s.is_delete = 0 AND p.is_delete = 0 AND p.product_id = '170' ORDER BY s.serial_order , p.product_order Line : 1474 File : /var/www/html/admin/includes/util_functions.php