Untitled
unknown
plain_text
5 months ago
1.4 kB
3
Indexable
SELECT CodCodigo, CodCodigo as id_product, (SELECT Observ FROM DOCOBS WHERE Tabela=3 AND TpLin=1 AND Linha=3 AND AIRec=DivNrReg) AS Nome0, (SELECT Observ FROM DOCOBS WHERE Tabela=3 AND TpLin=1 AND Linha=4 AND AIRec=DivNrReg) AS Observ, CASE WHEN PrcPreco7 > 0 THEN PrcPreco7 WHEN PrcPreco7 = 0 THEN PrcPreco0 END AS PrcPreco0, CASE WHEN IVATab = '3' THEN 54 WHEN IVATab = '2' THEN 53 WHEN IVATab = '1' THEN 55 END IVATab, CASE WHEN DivImagem<>'' THEN rtrim(DivImagem) WHEN DivFichImgRed<>'' THEN rtrim(DivFichImgRed) ELSE 'semimagem.jpg' END AS DivImagem, --'semimagem.jpg' as DivImagem, DivTpEspecie AS TabEspecie, DivTpMutacao AS TabMutacao, CONVERT(IsBitOnINTEGER(FlagApp2, 22),SQL_INTEGER) as suspenso, LogisPBrUnit, CodCat FROM STKFCHEX INNER JOIN STKCAT ON Ai_Categoria1 = Ai_Cat WHERE DivNivFam=0 AND RTRIM(LTRIM((SELECT Observ FROM DOCOBS WHERE Tabela=3 AND TpLin=1 AND Linha=3 AND AIRec=DivNrReg))) <> '' AND CHAR_LENGTH((SELECT Observ FROM DOCOBS WHERE Tabela=3 AND TpLin=1 AND Linha=3 AND AIRec=DivNrReg))>3 --AND ((RTRIM(LTRIM(DivImagem))<>'' OR RTRIM(LTRIM(DivFichImgRed))<>'')) AND IsBitOnINTEGER(FlagApp2, 20)=1 --LIMIT 1 -- 10000-10500 --AND LogisPBrUnit > 0 AND CodCodigo like '2150702'
Editor is loading...
Leave a Comment