Untitled

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=713 )

                                      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.i_content_flags & 1 = 0  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 ## 'online|letenky|auto|reality'

                                      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 (145677,136061,150543,143297) then 2.5 + ((t_campaign.n_id_customer%31)&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,

                    (coalesce(i_context_ad_ctr,40)*(i_bid*coalesce(i_premium_site_modifier,100))) 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 = 71816137 ) 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=713 )

                    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.i_content_flags & 1 = 0  AND (t_all_keyword.n_id_campaign_type&31) != 2

                    AND n_id_context_ad_url = 71816137  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