SEOClerks

Discussions about Emaillist

Showing page: 1 of 1

Recently I've gotten more into eCommerce and I've been trying to figure out how I can build my lists much larger without investing a lot of extra time into what I'm already doing. I wanted to build my list with the traf...

  • TommyCarey
    TommyCarey Level X3
  • 6 9 years ago

    I've been thinking about this for a while and I'm not 100% sure if it would work because I'm not an email campaign "Guru" lol. So I'm posting here to see if anyone can help me out My theory, or method, is that I can...

  • TommyCarey
    TommyCarey Level X3
  • 6 9 years ago

    Size doesn't matter. TRUE or FALSE? Hey people, Let me debunk this myth for you right away. - Size doesn't matter at all. And obviously, if you're a "naughty" person, you'll probably smile, laugh or grow red r...

  • hitmeasap
    hitmeasap Level X5
  • 8 9 years ago

    Hey guys.. "The money is in the list!" - We've all heard it by now.. Right? -Sure we have! It's a very common answer for anyone who's asking questions regarding money online. I'm actually kind of sick of answers ...

  • hitmeasap
    hitmeasap Level X5
  • 8 9 years ago

    It seems to me that email marketing is a method that is being avoided or not made good use of by many. Many seem to think that it is useless, and that emails simply get filtered as spam, or that recipients delete them as...

  • EliteWriter
    EliteWriter Level 3
  • 5 10 years ago

    I was just over at Lynne's awesome discussion thread HERE and started to ponder what you all are using for your email list service. You know, to send newsletters out to your customers: Mailchimp, etc.. If you don't mi...

  • bobjoehax3
    bobjoehax3 Level 1
  • 6 10 years ago
    Order Now
    Process Time: 0.11718702316284

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Emaillist %' OR A.tags LIKE 'Emaillist %' OR A.tags LIKE '% Emaillist' OR A.tags='Emaillist') LIMIT 11SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Emaillist %' OR A.tags LIKE 'Emaillist %' OR A.tags LIKE '% Emaillist' OR A.tags='Emaillist') LIMIT 1

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Emaillist %' OR A.tags LIKE 'Emaillist %' OR A.tags LIKE '% Emaillist' OR A.tags='Emaillist') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Emaillist %' OR A.tags LIKE 'Emaillist %' OR A.tags LIKE '% Emaillist' OR A.tags='Emaillist') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='19821'1SELECT profilepicture FROM seoclerks.members WHERE USERID='19821'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='6160'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6160'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='212316'1SELECT profilepicture FROM seoclerks.members WHERE USERID='212316'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='449398'1SELECT profilepicture FROM seoclerks.members WHERE USERID='449398'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.2622261SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (16) AND gtags like'%contenwriting%' AND type !=99 0.2622260.262226
    0.1088481SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%degitalmarketer%') ORDER BY total_recommendations desc LIMIT 0,400.1088480.108848
    0.0704861SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%degitalmarketer%') 0.0704860.070486