SEOClerks



We are hiring forum posters for our site. Super easy work. Fun job. Good pa...

  • robertman11
    robertman11 Level 2
  • Forums Forum Blog

    We are hiring forum posters for our sites. Fun job! Good pay for writers. W...

  • robertman11
    robertman11 Level 2
  • Forum Forumpos Webmaste

    I want to hire a team of programmers PHP to build a clone of the website Bu...

  • robertman11
    robertman11 Level 2
  • Php Clone Programm

    Buyer Reviews


    Recommendations


    Statuses


    Order Now
    Process Time: 0.051102161407471

    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 seoclerks.members WHERE username='robertman11' AND status='1' 1SELECT * FROM seoclerks.members WHERE username='robertman11' AND status='1'

    /opt/clerks-staging/docroot/user.php 54 () ()

    SELECT * FROM seoclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE seller_USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

    SELECT * FROM seoclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE affiliateUserId = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

    SELECT * FROM seoclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

    SELECT * FROM codeclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE seller_USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

    SELECT * FROM codeclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE affiliateUserId = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

    SELECT * FROM codeclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

    SELECT * FROM listingdock.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE seller_USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

    SELECT * FROM listingdock.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE affiliateUserId = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

    SELECT * FROM listingdock.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

    SELECT * FROM pixelclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE seller_USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

    SELECT * FROM pixelclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE affiliateUserId = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

    SELECT * FROM pixelclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

    SELECT * FROM wordclerks.orders WHERE seller_USERID = ?1SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE seller_USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()

    SELECT * FROM wordclerks.orders WHERE affiliateUserId = ?1SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE affiliateUserId = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()

    SELECT * FROM wordclerks.orders WHERE USERID = ?1SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE USERID = ?

    /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()

    UPDATE seoclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'1UPDATE seoclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'

    /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

    UPDATE codeclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'1UPDATE codeclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'

    /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

    UPDATE listingdock.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'1UPDATE listingdock.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'

    /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

    UPDATE pixelclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'1UPDATE pixelclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'

    /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

    UPDATE wordclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'1UPDATE wordclerks.members SET profile_data='{\"userPaymentMethodUpdated\":1676987353,\"userTypeUpdated\":1772550665,\"userType\":{\"main\":\"buyer\",\"0\":\"seller\",\"1\":\"buyer\"},\"paymentMethods\":[\"PayPal\",\"Airtm\",\"Stripe\",\"CustomPay\",\"CustomPay2\",\"CustomPay3\"],\"invoiceTimestamp\":0,\"updateFee\":1,\"invoicePage\":0,\"invoiceForce\":0,\"darkThemeSwitch\":0,\"workTo\":\"\",\"workFrom\":\"\",\"boostPageSeen\":1,\"quickResponse\":{\"1\":{\"title\":\"hello123\",\"description\":\"Hello Friend,\\r\\n\\r\\nMy name is Robert. I am a cool guy. Please send me monies!!!!!\"},\"2\":{\"title\":\"Nice stuff!\",\"description\":\"Love this stuff! This is great stuff\"},\"3\":{\"title\":\"fgsddfgsf\",\"description\":\"sfdsadssdadfsdfsdfsadafsasdfsad\"}},\"invoiceCount\":0,\"block_deposits\":\"0\",\"airtmEmail\":\"[email protected]\",\"airtmEmailActive\":0,\"wise_verified\":0,\"allow_wise_deposit\":0,\"totalRatings\":70,\"lastRatingAddTime\":1686478528,\"totalRatingsCount\":70,\"totalBadRatingsCount\":5,\"totalGoodRatingsCount\":65,\"allow_sound\":\"1\",\"userRatingUpdated\":1686305369,\"entersend\":\"true\",\"universal_coupons\":\"{\\\"1\\\":{\\\"name\\\":\\\"coolyuy\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1},\\\"2\\\":{\\\"name\\\":\\\"ghhghggggh\\\",\\\"discount\\\":\\\"25\\\",\\\"enabled\\\":1},\\\"3\\\":{\\\"name\\\":\\\"universal2\\\",\\\"discount\\\":\\\"5\\\",\\\"enabled\\\":1}}\",\"crypto_only_deposits\":\"0\",\"cryptoNetwork\":\"USDCSOL\",\"cryptoVerified\":0,\"networkAddress\":\"7HcUtjTakdQC6bJ8wF6GP8tGgbafAX8a1j9poCJHDdK\",\"aiQueryLimit\":100,\"aiQueryCount\":0}' WHERE USERID='9'

    /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

    SELECT * FROM seoclerks.members WHERE USERID='9'1SELECT lastlogin FROM seoclerks.members WHERE USERID='9'

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

    SELECT * FROM posts WHERE USERID=91SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=9

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

    SELECT * FROM follow F, members M WHERE F.FOLLOWING=9 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 41SELECT F.USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.FOLLOWING=9 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4

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

    SELECT * FROM follow F, members M WHERE F.USERID=9 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 41SELECT F.FOLLOWING AS USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.USERID=9 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4

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

    SELECT * FROM follow WHERE FOLLOWING=91SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=9

    /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()

    SELECT * FROM follow WHERE USERID=91SELECT COUNT(FID) AS total FROM follow WHERE USERID=9

    /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()

    SELECT * FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99 1SELECT count(A.PID) AS total FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99

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

    SELECT * FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 1SELECT A.*, C.userlevel, C.username, C.ip, C.lip, C.profilepicture FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40

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

    SELECT * FROM categories_software1SELECT * FROM categories_software

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

    SELECT * FROM categories1SELECT * FROM categories

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

    SELECT * FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? 1SELECT count(A.wantid) AS total FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ?

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

    SELECT * FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 401SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40

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

    SELECT * FROM wantbids WHERE active=1 AND wantid='49646'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49646'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM categories_wanttotrade WHERE seo='Buy-Forum-Posts'1SELECT name FROM categories_wanttotrade WHERE seo='Buy-Forum-Posts'

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

    SELECT * FROM wantbids WHERE active=1 AND wantid='49506'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49506'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM wantbids WHERE active=1 AND wantid='22889'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22889'

    /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

    SELECT * FROM categories_wanttotrade WHERE seo='Programming'1SELECT name FROM categories_wanttotrade WHERE seo='Programming'

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

    SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC1SELECT count(A.tradeid) AS total FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC

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

    SELECT * FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 401SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40

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

    SELECT * FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 10

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

    SELECT * FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 10

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

    SELECT * FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 10

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

    SELECT * FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 101SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='9' ORDER BY A.lastgigedit DESC LIMIT 10

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

    SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 11SELECT time FROM inbox2 WHERE MSGFROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1

    /opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() ()

    SELECT * FROM seoclerks.ratings WHERE USERID='9' AND PID != 01SELECT good, bad FROM seoclerks.ratings WHERE USERID='9' AND PID != 0

    /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

    SELECT * FROM codeclerks.ratings WHERE USERID='9' AND PID != 01SELECT good, bad FROM codeclerks.ratings WHERE USERID='9' AND PID != 0

    /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

    SELECT * FROM listingdock.ratings WHERE USERID='9' AND PID != 01SELECT good, bad FROM listingdock.ratings WHERE USERID='9' AND PID != 0

    /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

    SELECT * FROM pixelclerks.ratings WHERE USERID='9' AND PID != 01SELECT good, bad FROM pixelclerks.ratings WHERE USERID='9' AND PID != 0

    /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

    SELECT * FROM wordclerks.ratings WHERE USERID='9' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='9' AND PID != 0

    /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

    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()

    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