Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,991
    Thanks
    120
    Thanked 76 Times in 76 Posts

    Need some extra eyes ...

    Code:
    select distinct  a.term,'','manual' from 
    (select distinct term from tezaver_taxonomy) as a
    left join tezaver t on t.term = a.term and t.l2 = 'la'
    where t.id_tezaver is null
    like 3000 records

    Code:
    insert ignore into another_table
    (
    select distinct  a.term,'','manual' from 
    (select distinct term from tezaver_taxonomy) as a
    left join tezaver t on t.term = a.term and t.l2 = 'la'
    where t.id_tezaver is null
    )
    and only 16 records gets there ?
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,991
    Thanks
    120
    Thanked 76 Times in 76 Posts
    ahh forget that, had a filter on output table in client .....
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •