Advanced Find to locate all Issues you own that are either a 'base' number and/or Variation 'A' that has had a corresponding 'NS' (newsstand) variation added.

[Steven L. Dasinger]

This will allow you to find the issues that should have their cover examined to determine if it is a 'NS' cover or a 'Direct Market' cover.

(NOTE: This is a 'beta' version but I think it will work (I made my own test cases but the actual Update may add something I didn't test for.)

Assumptions:
A 'Direct Market' issues can only be issue number 1 or 1/A. If you do NOT own a #1 or #1/A (i.e. you own #1/B) it will NOT be displayed.
If you own ONLY #1 OR #1/A, only the one you own will display.
If you own BOTH #1 AND #1/A, they will both be displayed (to difficult with the current 'brain dead' SQL implementation to just get only one to display (I know why it is 'brain dead' and I mostly agree but that doesn't change the face).

I.Title || I.IssueNum || I.ItemType || I.Printing
  IN (
      SELECT B.Title || B.IssueNum || B.ItemType || B.Printing
      FROM ComicIssues B
      WHERE B.Title || B.IssueNum || B.ItemType || B.Printing
        IN (
            SELECT A.Title || A.IssueNum || A.ItemType || A.Printing
            FROM ComicIssues A
            WHERE A.Variation = 'NS'
           )
        AND B.Variation IN ('', 'A')
        AND B.QtyInStock >= 1
     )
   AND I.Variation IN ('', 'A')
OR
I.Title || I.IssueNum || I.ItemType || I.Printing
  IN (
      SELECT B.Title || B.IssueNum || B.ItemType || B.Printing
      FROM ComicIssues B
      WHERE B.Title || B.IssueNum || B.ItemType || B.Printing
        IN (
            SELECT A.Title || A.IssueNum || A.ItemType || A.Printing
            FROM ComicIssues A
            WHERE A.Variation = 'NS'
           )
        AND B.Variation IN ('', 'A')
        AND B.QtyInStock >= 1
     )
   AND I.Variation IN ('NS')

If you are interested what this does it:
Before the OR
In the deepest sub-query, it finds all the NS issues.
It uses this to filter out all Titles/Issues that don't have NS issues and find any Title/Issues that you own 'no variation' (regular) issues and/or an 'A' Variation issue.
This is then used to only display those owned 'no variation' and/or 'A/ Variations.
After the OR it uses similar logic to display 'NS' issues that you own 'no-variation' and/or 'A' variation issues:
In the deepest sub-query, it finds all the NS issues.
It uses this to filter out all the Titles/Issues That don't have NS issues and any Title/Issues that you own 'no variation or 'A' variation issues.
This is then used to display only the NS issues that you own 'no-variation' or A.variations.

If this does not return what you want, please explain (in as much detail as possible) what you want and I might be able to modify this (no promises  (see 'brain dead' SQL...)

 

[Steven L. Dasinger]

PS It works better if you first Save the Search. If not , the SQL is so long, with the unnamed version is run the display tries to display all of it and breaks.

Instead if you save the search, close the Advanced find, then Load the Search, it will display the name of the search you saved it as (which should be MUCH shorter than the actual SQL and it won't break the display.

[Scott J. Promish]

So, I just got a report that Amazing Spider-Man #193/A is no longer recognized.  The cover for that issue has a line through the bar code and a diamond price and number box, indicating direct sales.  Is this now #193, and the cover for that issue simply hasn't been updated yet?  (I can submit my own scan, if needed.)

[Scott J. Promish]

And do I really have to switch all my old newsstand copies to the NS record??

[Steven L. Dasinger]

Correct. That is issue #197 (direct market).

That is the major problem with these changes. While the database text can be fix/corrected, it can't fix the covers. HC is in the process of reviewing this but with 60,000ish issues, it could take awhile (and probably wouldn't be easily added to user databases until a Picture update is put out.

Yes, if you can supply a cover, they (and we) would appreciate it.

 

[Steven L. Dasinger]

Unfortunately, Yes. For Marvel, it appears that on/after Jun 1979 #1 is considered the direct Market, and 1/NS is the Newsstand.

However, if you want to ignore most of this, you can choose to display NS (newsstand) issues or not via the View->Items to Show option.

(Not sure how all of this will work in the future. Will NS and DM be updated with different values.)

I think if you don't sell on Atomic Avenue, you can just Not Show Newsstand issues and ignore that there is a difference. That way if you have Amazing Spider-Man #197 and don't care if it is considered a NS or DM you can (gets a little tricky if you have a NS cover and send it as an Update for #197 (as an example) and that, being a DM has a different cover). Hope that is not to confusing.

PS For Marvel, it appears that on or after Jun 1979 and for DC that on or after Oct 1980 that there is a 'demarcation line' where DM and NS split (yes, there were some Direct market issues before those dates and Direct Market was coined used in the early 70s but it was hit or miss (or multi-pack poly-bagged) issues (to really over simplify this)).

 

[Scott J. Promish]

Sorry, picture upload not working.  I tried.

As for any other newsstand issues I might have for sale, I'll cross those bridges when I come to them.