Total MASTER items

Can someone help me with an sql query that will give me a COUNT of the total number of active items that are on web?

that:

Are Parents (not including children) and Are Matrix items (just count the Matrix Master item,, not all the items in the matrix) and Are Solo items with no children or matrix

Parents+Matrix Master+solo that are active and "on web"

I am trying to compare what my Google Base upload file totals are to my actual item count.

Thanks!

Mickie

Reply to
Mickie
Loading thread data ...

Anyone? Come on, I know there are some SQL gurus here. Maybe give me some info about how those items are structured in the tables and I can write it.

Mickie

Mickie wrote:

Reply to
Mickie

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.