The query is giving 100000 records instead of only 13 records. Need the suggestion regarding this query [closed]

select  nvl(a.acct_no, 'NIL') as acct_no,
nvl(a.cont_no, 'NIL') as cont_no,
nvl(a.cust_name,f.cust_name) as cust_name,
nvl(a.cust_id,f.cust_id) as cust_id,
c.sub_no as phon_no, 
from   temp_hl_on_order b inner join temp_hl_on_od c
on b.order_status = c.on_status and b.order_status <> 'CN' 
and b.order_no = c.order_no and b.order_status = c.on_status
inner join temp_csm016 a
on a.acct_no = b.acct_no and a.cont_no = b.cont_no 
inner join temp_line_job_queue d
on c.order_no = d.order_no and c.sub_no = d.sub_no
left outer join temp_hl_on_apply f
on b.appl_no = f.appl_no
and b.order_status <> 'CN'
and c.sub_no in (
select b.ref_phone_no from img.dm_doc_imag a join img.dm_np_doc_assoc b on a.doc_id = b.doc_id
where b.doc_id like '20091106%');

BitNumeral Airdrop – $1000.00 – Distribution 10 March 2021

* Airdrop Description:
Participate in #BTN #Airdrop and receieve $BTN tokens worth $1000 and $5 per friend you refer.

* Steps:
– Join BitNumeral Chat Community on Telegram
– Join BitNumeral News Channel on Telegram
– Follow on Twitter – Like & retweet pinned post
– Submit Wallet Address (Erc20 compatible)
– Submit Twitter Username

* Requirements:
– Twitter Account
– Telegram Account

* Estimated Value: $1000.00

* 1st Distribution Date: 10 March…

Read more

provide spam free 100,000, gsa backlinks, top google ranking for $5

provide spam free 100,000, gsa backlinks, top google ranking

I am providing 100,000+ high quality multi-level Gsa backlinks that will assist you to boost up your website search engine ranking without any error. This Gsa ser backlinks service is Perfect for ranking websites, YouTube videos, Niche sites, Amazon Pages, eBay Pages, Web 2.0s (Like WordPress/Blogger), Tier 2/3 Links, Articles, Facebook, Twitter, other social media, and a lot more.

Benefits for your Site:

  • Increase your Authority
  • Increase Trust Level
  • PageRank
  • Link Juice
  • Boost in rankings
  • Traffic
  • Perfect for Money/Tier 1 sites
  • Spam Words Protection
  • Low OBL’s

Feature of this service?

✔️ Verified Backlinks

✔️ Links from over 300 Platform

✔️ Mix Nofollow/ Dofollow Backlinks (Maximum Links are Dofollow)

✔️ Anchor Text Variations

✔️ High Majestic TF and Moz Domain Authority

✔️ Fast Support

✔️ 24/7 Support

✔️ URL & keywords (Unlimited Accepted)

✔️ Faster Indexing- Using Paid Indexing Service

✔️ Safe, 100% Buyer Satisfaction

✔️Always over-deliver

Note: You need to wait a few days to get the results after creating gsa backlinks. Because Google takes some time to get index your created backlink.

==> Contact me if you have any questions ==>


❕NEWS – Famous Fund Manager: Bitcoin Price Target $ 100,000 | Proxies-free

Anthony Scaramucci, founder of investment firm SkyBridge Capital, said Bitcoin could rise much more in the current cycle. In a new interview with Yahoo Finance, Scaramucci stated that Bitcoin could easily exceed $ 100,000.
According to her, given the macroeconomic backdrop, the Bitcoin price could reach $ 100,000 by February 2022.
What do you think of this prediction?

Real and Organic 100,000 USA Website Traffic for 1 month for $10

Real and Organic 100,000 USA Website Traffic for 1 month

2500-3500 Daily Visitors for 1 Month

Worldwide Organic Traffic for we offer High-Quality Human Real Visitors traffic at a really reasonable price to extend your website’s quality and visibility.

If you think that , you would like to urge 100% safe and real traffic with none penalty for your site or advertiser, And if you would like program improvement with ranking, so this service absolutely right for you.

But if you expect software traffic or proxy traffic or fake traffic please don’t purchase our service. We are only Providing real traffic without using any software or proxies or bot or using any panel at an inexpensive price

1 month daily visits with no limits

2500-3500 daily visits to your website or a complete of 100,000+ visitors

Websites, Blogs, CPA, Rev Share, Affiliations, etc. are welcome.

Direct/social media sites views and 100% Adsense SAFE

Improve your website visibility and brand exposure

Give your business more credibility

Most of them USA visitors

SEO complementary

Tracking link provided

24/7 Customer support

When placing an order please send me your real website URL. don’t send shortener URL.

I don’t use web traffic exchange, bot, spam, proxy, blackhat method

Not guaranteed: Ad Clicks, Conversions
Not allowed: SEOClerk Gigs, YouTube videos,, Squeeze Pages, Links or Websites with slow loading pages, Social Media, SoundCloud.


100000 USA web traffic, real organic visitors for $8

100000 USA web traffic, real organic visitors


Here is the best traffic service in seoclearks. The traffic will be started within 6 hours or less since you place the order, regardless the number of orders in queue and we will deliver the tracking as well.

Key Features:

  • Order will start process within 24 hours
  • ONLY USA visitors ( not world wide)
  • Organic, social visits with unique ip. No bots
  • Long Visit Duration
  • Sub Page Visitors
  • Low Bounce Rate
  • Daily USA Visitors
  • Maximum 15 Keywords Target Traffic
  • Providing Possible Tracking link With Real-Time Google Analytic
  • Bounce Rate Improvement
  • Targeted Sources
  • Google Organic & Social Traffic Visitors
  • 24 Hour Customer Support

No Rotators, Adfly, Adult, Viruses, Fiver gigs and Adult content

You might receive sales/opt-ins but they cannot be guaranteed. we cant control visitors actions, so please understand this before purchasing.

“A FREE tracking link will be provided with each order”


I want to make $100,000 USD by 2022

To make a long story short …

Here are what I want to do to earn this much …

  1. Build a website like Flippa and sell it in 1 year for $50,000 – $100,000 Dollars.
  2. Build templates and sell them directly from my site.

I want to make the right choice …

What should I do? Should I focus on building a site like Flippa or sell website templates?

Thanks :]

❕NEWS – Twitter poll revealed bitcoin to rise to $100,000 by 2021 | Proxies-free

According to opinion poll conducted by Crypto analyst expert called Plan B shows that 51% of bitcoin Investors believed that bitcoin will rise to $100, 000 by 2021, the percentage increased compared to July opinion where 17% that believed it will rise to $100,000.
What do you think people used or consider in making prediction ?.

❓ASK – Bitcoin could hit $100,000 | Proxies-free

i don’t need to invest in bitcoin i earn it for free :D well, i have to work for it online to claim on faucets and bitcoin-ptcs .
I know bitcoin since last summer when 1 :BTC: was 600-700$ when i stopped activity on most $-ptcs and saw less scam risks on faucets and better opportunity to earn better with 0 risk of losing money from pocket.
You need patience to earn from micro earning websites and if you wait for a better opportunity to earn more satoshi for free with risk 0 ,you won’t find it , unless you have some skillz as freelancer and get paid in bitcoin.
Investing in bitcoin, by investing i understand purchasing it and keeping it for long time not “invest” in hyips or ponzi, is kinda risky due to volatility . Also history can prove that bitcoin is a very sensitive crypto to fake news or rumors . I’m skeptical in recommending to purchase bitcoin, but for ETH i recommend it to purchase it since it was 63$ because i was almost sure that will reach 100+$.
But if the bitcoin has already reached $2800 in the past days, im sure can reach it again and very soon if it is more wanted in japan.
Remember to invest what you can afford to lose and not to spend college money .
If a millionaire would ask me now if its good to invest NOW in crypto i would recommend him to purchase bitcoin but in a small amount and in ETH to purchase in bigger amount. And to not invest in other crypto yet.


ANNOUNCEMENT – WIN $1500! Invite Your Friends! Celebrating 100,000 Members on Proxies-free | Proxies-free

Dear BMFers,

Thank you so much for all the support we just passed 100.000 registered members, thank you for joining previous contests, first $1225 contest, 2nd $1500 contest, prizes sent on Livestream, no b/s, video call via skype for full transparency. Proofs of payments from each forum member. When we give away money we actually do it!

View attachment 139840

Today we are happy to announce the 3rd referral contest on Proxies-free

Total winnings: $1,500 USD
Total winners: 20
Timeframe: 60 days
Start Day: 01.09.2020

The member with the most referrals wins the biggest prize worth $600 USD = 600.000 BMF Points.
Prizes will be awarded automatically on 31.10.2020 to the first 20 positions.
Check “Tools” and start promoting your referral link to win at least one of the prizes!

Check Top Referrers:

Contest end date: 31.10.2020


(1) 600000 BMF Tokens = $600 USD
(2) 300000 BMF Tokens = $300 USD
(3) 200000 BMF Tokens = $200 USD
(4) 100000 BMF Tokens = $100 USD
(5) 50000 BMF Tokens = $50 USD
(6) 25000 BMF Tokens = $25 USD
(7) 25000 BMF Tokens = $25 USD
(8) 25000 BMF Tokens = $25 USD
(9) 25000 BMF Tokens = $25 USD
(10) 25000 BMF Tokens = $25 USD
(11) 15000 BMF Tokens = $15 USD
(12) 15000 BMF Tokens = $15 USD
(13) 15000 BMF Tokens = $15 USD
(14) 15000 BMF Tokens = $15 USD
(15) 15000 BMF Tokens = $15 USD
(16) 10000 BMF Tokens = $10 USD
(17) 10000 BMF Tokens = $10 USD
(18) 10000 BMF Tokens = $10 USD
(19) 10000 BMF Tokens = $10 USD
(20) 10000 BMF Tokens = $10 USD

– you cannot promote on paid to signup such as Picoworkers, Microworkers (we already allowed such on previous contests and too many duplicate accounts)
– you can promote on Youtube, Facebook, Twitter, forums, pay to click sites, and any type of real traffic is accepted
– do not use VPN/PROXY to create fake inactive accounts, don’t waste your time, we have full control over search over anyone referrals list, and if found cheating you get banned before the contest ends.
– rules on how referrals are counted are not fully displayed to not give ideas to cheaters, rules are subject to change during the contest to ensure only legit referrals are counted and their referrers enjoy the top prize

Good luck BMFers!