Untitled

 avatar
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