SELECT COUNT(*) AS total FROM (
                                    SELECT
                                        DISTINCT p.id,
                                        location,
                                        shop,
                                        detection,
                                        scandate,
                                        nama
                                    FROM SsPalletInCKD p WITH (NOLOCK)
                                ) AS tab