Untitled

                ORDER BY typ_cielenia, i_bid DESC, i_bid DESC

ERROR:  syntax error at OR near "as" at character 148

STATEMENT:  /*  */SELECT * FROM (SELECT t_campaign.n_id_customer,n_id_campaign,s_title,s_description,n_id_keyword,(i_bid*coalesce(i_premium_site_modifier,100) AS i_bid),t_campaign.s_url,1 AS score,i_keywords,i_context_ad_ctr,1 AS typ_cielenia,b_dynamic,b_logo,t_all_keyword.n_id_campaign_type, b_add_analytics_data, t_campaign.i_rotation_flags, t_campaign.s_rotation_data

                                      FROM t_campaign,t_all_keyword LEFT JOIN t_customer_portal_list_block ON (t_customer_portal_list_block.n_id_customer=t_all_keyword.n_id_customer

                                      AND  n_id_portal_list=52 )

                                      WHERE n_id_country = 1

                                      AND n_id_campaign=id_campaign

                                      AND t_all_keyword.b_display_type_flags&4=0

                                      AND i_keywords<4

                                      AND n_id_keyword>0

                                      AND i_exact_match<2

                                       AND (t_all_keyword.n_id_campaign_type&31) != 2

                                       AND (n_id_customer_partner_block_type&1028=0 OR n_id_customer_partner_block_type IS NULL)  AND b_thursday_flags & 4096 = 0

                                       AND keyidx ## 'nokia|mobil'

                                      GROUP BY 1,2,3,4,5,6,7,8,9,10,b_dynamic,b_logo,t_all_keyword.n_id_campaign_type, b_add_analytics_data, t_campaign.i_rotation_flags, t_campaign.s_rotation_data

                                      HAVING count(*)=i_keywords

                                      ORDER BY i_context_ad_ctr*i_bid DESC

                                       LIMIT 1) AS prefoo

                                      UNION  

                SELECT foo.n_id_customer,n_id_campaign,s_title,s_description,n_id_keyword,i_bid,t_campaign.s_url,score,i_clicks,i_context_ad_ctr, (case when n_id_campaign IN (148164,150818,149404,150762,142304,149622,150455,150534,150544,117301,150638,132569) then 2.5 + ((t_campaign.n_id_customer%10)&3)::float/7 else 2 end)  AS typ_cielenia,b_dynamic,b_logo,t_campaign.n_id_campaign_type, b_add_analytics_data, i_rotation_flags, s_rotation_data

                FROM t_campaign,(

                    SELECT t_all_keyword.n_id_customer,t_all_keyword.n_id_campaign,t_all_keyword.n_id_keyword,(i_bid*coalesce(i_premium_site_modifier,100))/100 AS i_bid,

                    (3*i_clicks+i_score+(i_bid*coalesce(i_premium_site_modifier,100))/500+((t_context_ad_cache.n_id_keyword+50)&15)*1) AS score,i_clicks,i_context_ad_ctr

                    FROM (t_all_keyword JOIN t_context_ad_cache ON  t_context_ad_cache.n_id_keyword = t_all_keyword.n_id_keyword AND n_id_context_ad_url = 71771706 ) LEFT JOIN t_customer_portal_list_block

                      ON (t_customer_portal_list_block.n_id_customer=t_all_keyword.n_id_customer AND  n_id_portal_list=52 )

                    WHERE t_context_ad_cache.n_id_keyword = t_all_keyword.n_id_keyword

                     AND (n_id_customer_partner_block_type&1028=0 OR n_id_customer_partner_block_type IS NULL)

                    AND t_all_keyword.b_display_type_flags&4=0

                    AND t_all_keyword.i_keywords<4

                     AND (t_all_keyword.n_id_campaign_type&31) != 2

                    AND n_id_context_ad_url = 71771706  AND b_thursday_flags & 4096 = 0

                    AND (i_clicks>0 OR i_views<1000)

                    GROUP BY 1,2,3,4,5,6,7

                    ORDER BY score DESC  LIMIT 7

                    ) AS foo

                WHERE n_id_campaign=id_campaign

                AND n_id_campaign_status=1

                ORDER BY typ_cielenia, score DESC, i_bid DESC