Total MASTER items

May 05, 2009 1 Replies

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


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:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required