select
        quotelinei0_.id as col_0_0_
    from
        quote_line_item quotelinei0_
    left outer join
        quote_line_item_quantity quantities1_
            on quotelinei0_.id=quantities1_.quote_line_item_id
            and (
                quantities1_.order_number in (
                    0
                )
            )
    where
        quotelinei0_.quote_id=205
        and (
            (
                select
                    count(quotelinei2_.id)
                from
                    quote_line_item_comment quotelinei2_
                where
                    quotelinei2_.quote_line_item_id=quotelinei0_.id
                    and 1=1
                    and (
                        1=1
                        or quotelinei2_.comment is null
                        or ltrim(rtrim(quotelinei2_.comment))=?
                    )
            )>0
            or  not (exists (select
                quotelinei3_.id
            from
                quote_line_item_comment quotelinei3_
            where
                quotelinei3_.quote_line_item_id=quotelinei0_.id
                and (quotelinei3_.comment is not null)
                and ltrim(rtrim(quotelinei3_.comment))<>?))
        )
        and (
            quotelinei0_.preferred_line is null
            or quotelinei0_.preferred_line=1
        )
        and 1=1
        and (
            quotelinei0_.validation in (
                ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
            )
            or quotelinei0_.validation is null
        )
        and 1=1
        and 1=1
        and 1=1
        and 1=1
        and 1=1
        and 1=1
        and 1=1
    order by
        case
            when quantities1_.ext_cost is null then 1
            else 0
        end asc,
        quantities1_.ext_cost desc