Attention

count(): Parameter must be an array or an object that implements Countable

SELECT sd.sPedimento, sd.sFactura, sd.sInbond, 'USA' AS Origen, sd.sOrigen AS Ori, sd.sHTS, SUM(sd.doCantidad) AS Cantidad, SUM(sd.doCostoUSD) AS CostoUSD, SUM(sd.doPeso) AS Peso,. sd.sTransport AS Transport FROM shipper_detail AS sd WHERE sd.nidShipperOrder = AND (sd.sOrigen = 'US' OR sd.sOrigen = 'USA') GROUP BY sd.sHTS,sd.sOrigen,sd.sFactura,sd.sInbond HAVING CostoUSD >= 0 UNION SELECT sd.sPedimento, sd.sFactura, sd.sInbond, 'OTRO' AS Origen, sd.sOrigen AS Ori, sd.sHTS, SUM(sd.doCantidad) AS Cantidad, SUM(sd.doCostoUSD) AS CostoUSD, SUM(sd.doPeso) AS Peso, sd.sTransport AS Transport FROM shipper_detail AS sd WHERE sd.nidShipperOrder = AND (sd.sOrigen <> 'US' AND sd.sOrigen <> 'USA') GROUP BY sd.sHTS,sd.sFactura,sd.sInbond HAVING CostoUSD >= 0