webJobs Copyright 2011, Web Scribble Solutions, Inc. All Rights Reserved. Classified ads software Classifieds script

| | |

 

™
©

Query Count: 39
1.) show tables like 'cl_zipcodes'
Access denied for user 'thewelis'@'localhost' (using password: NO)

2.) SELECT 1 FROM cl_translations LIMIT 1
Access denied for user 'thewelis'@'localhost' (using password: NO)

3.) SELECT 1 FROM cl_site_themes WHERE theme='iphone'
Access denied for user 'thewelis'@'localhost' (using password: NO)

4.) SELECT 1 FROM cl_banners LIMIT 1
Access denied for user 'thewelis'@'localhost' (using password: NO)

5.) SELECT name FROM cl_badwords
Access denied for user 'thewelis'@'localhost' (using password: NO)

6.) SELECT * FROM webclassifieds_bd_scheduler WHERE id='1'
Access denied for user 'thewelis'@'localhost' (using password: NO)

7.) SELECT * FROM cl_ads WHERE status = '-1' AND ad_modified <= '1369124807'
Access denied for user 'thewelis'@'localhost' (using password: NO)

8.) SELECT a.id, a.member_id, a.catid, a.title, a.ad_end, m.email, m.first_name, m.last_name FROM cl_ads a, cl_members m WHERE a.member_id=m.id AND (a.status='1' OR a.status='6') AND a.ad_end<='1369132007'
Access denied for user 'thewelis'@'localhost' (using password: NO)

9.) UPDATE cl_promo_codes SET status = '0' WHERE uses = '0' OR expiration <= '1369132007'
Access denied for user 'thewelis'@'localhost' (using password: NO)

10.) SELECT * FROM cl_members WHERE balance > '0' AND balance_timestamp + 604800 > '1369132007' AND balance_timestamp + 604800 < '1369391207' AND balance_notification = '0'
Access denied for user 'thewelis'@'localhost' (using password: NO)

11.) SELECT * FROM cl_members WHERE balance > '0' AND balance_timestamp + 604800 <= '1369132007' AND balance_notification = '1'
Access denied for user 'thewelis'@'localhost' (using password: NO)

12.) SELECT m.*, bp.name FROM cl_members m, cl_billing_plans bp WHERE bp.id=m.billing_plan_id AND m.billing_plan_id <> '0' AND (m.subscription_expiration <= '1369132007' OR m.subscription_credits <= '0')
Access denied for user 'thewelis'@'localhost' (using password: NO)

13.) SELECT * FROM cl_queue ORDER BY timestamp ASC LIMIT 0, 20
Access denied for user 'thewelis'@'localhost' (using password: NO)

14.) UPDATE cl_categories SET ad_count = '0'
Access denied for user 'thewelis'@'localhost' (using password: NO)

15.) SELECT * FROM cl_ads WHERE status = '1' OR status = '6'
Access denied for user 'thewelis'@'localhost' (using password: NO)

16.) UPDATE webclassifieds_bd_scheduler SET timestamp = '1369132007' WHERE id = '1'
Access denied for user 'thewelis'@'localhost' (using password: NO)

17.) SELECT * FROM webclassifieds_bd_scheduler WHERE id='2'
Access denied for user 'thewelis'@'localhost' (using password: NO)

18.) SELECT DISTINCT af.member_id, m.email FROM cl_ad_finder_pending af, cl_members m WHERE af.member_id = m.id LIMIT 10
Access denied for user 'thewelis'@'localhost' (using password: NO)

19.) DELETE FROM cl_ad_finder_pending WHERE id IN (0)
Access denied for user 'thewelis'@'localhost' (using password: NO)

20.) SELECT COUNT(*) as num_rows FROM cl_ad_finder_pending
Access denied for user 'thewelis'@'localhost' (using password: NO)

21.) UPDATE webclassifieds_bd_scheduler SET timestamp = '1369132007' WHERE id = '2'
Access denied for user 'thewelis'@'localhost' (using password: NO)

22.) SELECT * FROM cl_countries LIMIT 1
Access denied for user 'thewelis'@'localhost' (using password: NO)

23.) SELECT theme_dir, css_location FROM cl_site_themes WHERE active='1' AND iphone_theme='0'
Access denied for user 'thewelis'@'localhost' (using password: NO)

24.) SELECT theme_dir, css_location FROM cl_site_themes WHERE `default`='1'
Access denied for user 'thewelis'@'localhost' (using password: NO)

25.) SET NAMES UTF8
Access denied for user 'thewelis'@'localhost' (using password: NO)

26.) SELECT id, type, filename, text_id, text_en FROM cl_translations
Access denied for user 'thewelis'@'localhost' (using password: NO)

27.) SELECT id, name, abv, iso_code FROM cl_langs WHERE abv='en'
Access denied for user 'thewelis'@'localhost' (using password: NO)

28.) SELECT c.* FROM cl_categories AS c WHERE c.breadcrumbs LIKE '%/0/%' AND c.status = '0' GROUP BY c.id ORDER BY c.relative_order ASC
Access denied for user 'thewelis'@'localhost' (using password: NO)

29.) SELECT name FROM cl_cities WHERE id=''
Access denied for user 'thewelis'@'localhost' (using password: NO)

30.) SHOW TABLES LIKE 'int_products'
Access denied for user 'thewelis'@'localhost' (using password: NO)

31.) SELECT * FROM cl_langs WHERE enabled = '1' AND icon = '1' ORDER BY id ASC
Access denied for user 'thewelis'@'localhost' (using password: NO)

32.) SELECT name, id FROM cl_categories WHERE parent_id='0' AND status='0' ORDER BY relative_order ASC
Access denied for user 'thewelis'@'localhost' (using password: NO)

33.) SELECT a.* FROM cl_ads a, cl_ads_attributes aa WHERE a.id=aa.ad_id AND a.calculated_status='1' AND aa.featured='1' ORDER BY RAND() LIMIT 50
Access denied for user 'thewelis'@'localhost' (using password: NO)

34.) SELECT c.*, COUNT(a.catid) AS ad_count_all FROM cl_categories AS c LEFT JOIN cl_ads AS a ON (a.catid=c.id AND (a.calculated_status=1) ) WHERE c.status = '0' GROUP BY c.id ORDER BY c.relative_order ASC
Access denied for user 'thewelis'@'localhost' (using password: NO)

35.) SELECT name FROM cl_cities WHERE id=''
Access denied for user 'thewelis'@'localhost' (using password: NO)

36.) SELECT name FROM cl_cities WHERE id=''
Access denied for user 'thewelis'@'localhost' (using password: NO)

37.) SELECT id, name AS name FROM cl_countries ORDER BY relative_order
Access denied for user 'thewelis'@'localhost' (using password: NO)

38.) SELECT id, parent_id, name AS name FROM cl_states WHERE 1 ORDER BY relative_order
Access denied for user 'thewelis'@'localhost' (using password: NO)

39.) SELECT STRAIGHT_JOIN a.* FROM cl_ads a, cl_ads_attributes aa, cl_categories AS c WHERE a.id=aa.ad_id AND a.catid=c.id AND (a.calculated_status='1') ORDER BY ad_begin DESC LIMIT 10
Access denied for user 'thewelis'@'localhost' (using password: NO)