{"data":[],"pags":0,"sql":"\n\t\t\tSELECT\n\t\t\t\tP.ID, P.Ref, PL.Cabecalho, PL.Subtitulo, PL.Texto1, PL.Texto3, PO.obj_pvp, PO.obj_val2, PI.img_ext, PP.prod_id AS PERSONALIZACAO, SUBSTRING(SOUNDEX(P.Ref), 1, 1) AS FirstChar, PFT.doc_name, PFT.doc_ext\n\t\t\tFROM\n\t\t\t\tproducts P\n\t\t\t\tINNER JOIN products_lang PL on PL.ID_PAI=P.ID\n\t\t\t\tINNER JOIN products_fichastec PFT on P.ID=PFT.ID_ORG\n\t\t\t\tINNER JOIN products_objs PO on PO.obj_type_id=P.ID\n\t\t\t\tLEFT JOIN products_images PI on PI.ID_ORG=P.ID\n\t\t\t\tLEFT JOIN products_personalizacao2 PP on PP.prod_id=P.ID\n\t\t\tWHERE\n\t\t\t\tPO.obj_val2 = 0\n\t\t\t\tAND \n\t\t\t\t(\n\t\t\t\t\tPI.img_ext is NULL\n\t\t\t\t\tOR (PO.obj_pvp = 0)\n\t\t\t\t\tOR PL.Texto1 = ''\n\t\t\t\t\tOR PP.prod_id is NULL\n\t\t\t\t)\n\t\t\t\tAND PFT.lang='pt' AND PL.Lang='pt'\n\t\t\t\t AND SUBSTRING(SOUNDEX(P.Ref), 1, 1)=\"A\" \n\t\t\tGROUP BY P.ID\n\t\t\t\n\t\t\t ---  AND SUBSTRING(SOUNDEX(P.Ref), 1, 1)=\"A\"  --- ","key_selecionar_tudo":"SELECIONAR TUDO","key_guardar_tudo":"GUARDAR TUDO","key_sem_resultados_para":"Sem Resultados para"}