There was an issue with the database. Technical advisors have been notified and this issue will be repaired shortly.
DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -1 [message] => DB Error: unknown error [userinfo] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] [backtrace] => Array ( [0] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB.php [line] => 741 [function] => PEAR_Error [class] => PEAR_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => DB Error: unknown error [1] => -1 [2] => 1 [3] => 1024 [4] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] ) ) [1] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/PEAR.php [line] => 536 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -1 [1] => 1 [2] => 1024 [3] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] ) ) [2] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/common.php [line] => 500 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => [1] => -1 [2] => [3] => [4] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/mysql.php [line] => 776 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => -1 [1] => [2] => [3] => [4] => 1242 ** Subquery returns more than 1 row ) ) [4] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/mysql.php [line] => 228 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/common.php [line] => 1144 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol ) ) [6] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/common.php [line] => 1595 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol ) ) [7] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/code/display.offers.function.php [line] => 229 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Low Interest Credit Cards') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Low Interest Credit Cards' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Low Interest Credit Cards') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Low Interest Credit Cards' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(58028) #order by r.RankId,randcol ) ) [8] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/code/display.offers.function.php [line] => 34 [function] => FetchOffers [args] => Array ( [0] => Low Interest Credit Cards [1] => 0 [2] => 1 [3] => 0 ) ) [9] => Array ( [file] => /home/k5xnaih3yd0s/public_html/lowest-interest-credit-cards.php [line] => 62 [function] => DisplayOffers [args] => Array ( [0] => Low Interest Credit Cards [1] => 20 [2] => 1 [3] => 1 [4] => 1 [5] => lowest-interest-credit-cards ) ) ) [callback] => )