string(1797) "(SELECT  0 as int_data, 1 as order, li_cd,co_nome, li_titulo, li_status, li_preco_venda,lg_foto,lg_cache_capa, (li_qtd_minimo + li_reserva) as li_qtd_minimo, lg_cd, lg_cd_gc, lg_local, sum(me_qtd) qtd,
                 		   (select vo_valor from valor where vo_pag_ini <= li_paginas and vo_pag_fim >= li_paginas) li_valor, li_dt_pub
                 		   FROM livro_digital
                 		   INNER JOIN livro ON li_cd = lg_cd_li
                 		   INNER JOIN colecao on li_colecao = co_cd
                 		   INNER JOIN movimentacao_estoque on li_cd = me_livro
                 		   WHERE li_status = 1 AND li_cd != 1 AND li_grupo = 1 and li_colecao = (select cdl_cd_co from colecoes_destaque_loja where cdl_cd = 1)
                 		   GROUP BY li_cd, li_titulo, lg_local, lg_cd, co_nome, li_dt_pub
                 		   HAVING sum(me_qtd) > 0 and sum(me_qtd) > (li_qtd_minimo + li_reserva))
						   union
						   (SELECT 0 as int_data, 2 as order, gc_cd as li_cd, co_nome, gc_nome as li_titulo, lg_status as li_status, NULL as li_preco_venda, lg_foto, lg_cache_capa, (li_qtd_minimo + li_reserva) as li_qtd_minimo,lg_cd, lg_cd_gc, lg_local,
						   2 as qtd, gc_preco_venda as li_valor, gc_dt_pub as li_dt_pub
						   FROM grupo_colecao
						   INNER JOIN colecao on gc_colecao = co_cd
						   INNER JOIN livro_digital ON gc_cd = lg_cd_gc
						   INNER JOIN livro on li_grupo = lg_cd_gc
						   WHERE gc_cd != 1 AND gc_preco_venda != 0 and gc_colecao =(select cdl_cd_co from colecoes_destaque_loja where cdl_cd = 1) and lg_status = 1 AND gc_status = 2 AND lg_cd_li = 1 AND l_gc_op ilike 'insert'
						   GROUP BY gc_cd, co_nome,lg_status,lg_foto,lg_cache_capa,li_qtd_minimo,lg_cd,l_gc_data, li_reserva
						   ORDER BY li_dt_pub DESC)
						   ORDER BY li_dt_pub DESC LIMIT 14"