object(DB_Error)#204 (8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-1)
["message"]=>
string(28) "DB Error: wrong "from" param"
["userinfo"]=>
NULL
["backtrace"]=>
array(9) {
[0]=>
array(6) {
["file"]=>
string(24) "/home/ireland/php/DB.php"
["line"]=>
int(970)
["function"]=>
string(11) "__construct"
["class"]=>
string(10) "PEAR_Error"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(28) "DB Error: wrong "from" param"
[1]=>
int(-1)
[2]=>
int(1)
[3]=>
int(1024)
[4]=>
NULL
}
}
[1]=>
array(7) {
["file"]=>
string(26) "/home/ireland/php/PEAR.php"
["line"]=>
int(575)
["function"]=>
string(11) "__construct"
["class"]=>
string(8) "DB_Error"
["object"]=>
*RECURSION*
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
string(18) "wrong "from" param"
[1]=>
int(1)
[2]=>
int(1024)
[3]=>
NULL
}
}
[2]=>
array(5) {
["function"]=>
string(11) "_raiseError"
["class"]=>
string(4) "PEAR"
["object"]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
["type"]=>
string(2) "->"
["args"]=>
array(8) {
[0]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
[1]=>
NULL
[2]=>
string(18) "wrong "from" param"
[3]=>
NULL
[4]=>
NULL
[5]=>
NULL
[6]=>
string(8) "DB_Error"
[7]=>
bool(true)
}
}
[3]=>
array(4) {
["file"]=>
string(26) "/home/ireland/php/PEAR.php"
["line"]=>
int(224)
["function"]=>
string(20) "call_user_func_array"
["args"]=>
array(2) {
[0]=>
array(2) {
[0]=>
string(4) "PEAR"
[1]=>
string(11) "_raiseError"
}
[1]=>
array(8) {
[0]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
[1]=>
NULL
[2]=>
string(18) "wrong "from" param"
[3]=>
NULL
[4]=>
NULL
[5]=>
NULL
[6]=>
string(8) "DB_Error"
[7]=>
bool(true)
}
}
}
[4]=>
array(7) {
["file"]=>
string(30) "/home/ireland/php/DB/Pager.php"
["line"]=>
int(200)
["function"]=>
string(6) "__call"
["class"]=>
string(4) "PEAR"
["object"]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(10) "raiseError"
[1]=>
array(7) {
[0]=>
NULL
[1]=>
string(18) "wrong "from" param"
[2]=>
NULL
[3]=>
NULL
[4]=>
NULL
[5]=>
string(8) "DB_Error"
[6]=>
bool(true)
}
}
}
[5]=>
array(7) {
["file"]=>
string(30) "/home/ireland/php/DB/Pager.php"
["line"]=>
int(200)
["function"]=>
string(10) "raiseError"
["class"]=>
string(4) "PEAR"
["object"]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
["type"]=>
string(2) "->"
["args"]=>
array(7) {
[0]=>
NULL
[1]=>
string(18) "wrong "from" param"
[2]=>
NULL
[3]=>
NULL
[4]=>
NULL
[5]=>
string(8) "DB_Error"
[6]=>
bool(true)
}
}
[6]=>
array(7) {
["file"]=>
string(30) "/home/ireland/php/DB/Pager.php"
["line"]=>
int(103)
["function"]=>
string(7) "getData"
["class"]=>
string(8) "DB_Pager"
["object"]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
["type"]=>
string(2) "->"
["args"]=>
array(3) {
[0]=>
string(1) "3"
[1]=>
int(6)
[2]=>
int(7)
}
}
[7]=>
array(7) {
["file"]=>
string(82) "/home/ireland/public_html/_div/ireland_guide/establishment/content/estInfo-new.php"
["line"]=>
int(375)
["function"]=>
string(5) "build"
["class"]=>
string(8) "DB_Pager"
["object"]=>
object(DB_Pager)#201 (10) {
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(10) "PEAR_Error"
["_expected_errors"]=>
array(0) {
}
["res"]=>
object(DB_result)#203 (11) {
["autofree"]=>
bool(false)
["dbh"]=>
object(DB_mysql)#202 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
resource(19) of type (mysql link)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(13) "ireland_guide"
["password"]=>
string(12) "8dHd!yqN!Bvs"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(13) "ireland_guide"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(13) "ireland_guide"
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["fetchmode"]=>
int(2)
["fetchmode_object_class"]=>
string(8) "stdClass"
["limit_count"]=>
NULL
["limit_from"]=>
NULL
["parameters"]=>
array(0) {
}
["query"]=>
string(2459) "
SELECT
tbl_item_category.item_id,
(DEGREES( ACOS( SIN( RADIANS(52.93880000000000) ) * SIN( RADIANS( min(tbl_category.cat_latitude) ) ) + COS( RADIANS(52.93880000000000) ) * COS( RADIANS( min(tbl_category.cat_latitude) ) ) * COS( RADIANS( min(tbl_category.cat_longitude) - -9.39100000000000) ) ) ) *60 * 1.1515 * 1.609344
) AS distance,
count(mem_id) AS count_mem_id
FROM
tbl_category INNER JOIN tbl_item_category ON tbl_category.cat_id = tbl_item_category.cat_id INNER JOIN tbl_item ON (tbl_item_category.item_id = tbl_item.item_id) INNER JOIN tbl_item_quality tbl_item_quality_0 ON (tbl_item.item_id = tbl_item_quality_0.item_id) INNER JOIN tbl_item_quality tbl_item_quality_1 ON (tbl_item.item_id = tbl_item_quality_1.item_id) LEFT OUTER JOIN tbl_member ON (tbl_item.item_id = tbl_member.item_id AND tbl_member.mem_premiumMember='True') WHERE tbl_item.item_id IN (3131, 3132, 3134, 3135, 3137, 3145, 3148, 3154, 3159, 3160, 3162, 3163, 3166, 3168, 3176, 3182, 3183, 3187, 3188, 3191, 3492, 3498, 3501, 3502, 3504, 3505, 3506, 3507, 3508, 3512, 3535, 3537, 3539, 3542, 3543, 3544, 3545, 3546, 3547, 3551, 3553, 3555, 3556, 3557, 3558, 3560, 3566, 3568, 3583, 3603, 3604, 3790, 3792, 3793, 3798, 3815, 4453, 4545, 4676, 4678, 4744, 5083, 5275, 5309, 5315, 5325, 5357, 5372, 5584, 6054, 6064, 6136, 6137, 6140, 6368, 7361, 7363, 7372, 7449, 7550, 7551, 7991, 8028, 8032, 8072, 8774, 8778, 8809, 8843, 8969, 9284, 9477, 9478, 9498, 9499, 9537, 9608, 9716, 9754, 9802, 9833, 9836, 9945, 9968, 9975, 9991, 10007, 10030, 10080, 10092, 10095, 10114, 10119, 10121, 10137, 10154, 10480, 10481, 10528, 10539, 10677, 10755, 10756, 10757, 10758, 10761, 10762, 10763, 10887, 10891, 10929, 10955, 10956, 10957, 10958, 10960, 11006, 11017, 11116, 11155, 11328, 11563, 11611, 11995, 12003, 12033, 12426, 12440, 12472, 12475, 12723, 12773, 12796, 12941, 13061, 13114, 13116, 13273, 13349, 13394, 13518, 13526, 13655, 13685, 13720, 13728, 13741, 13744, 13879, 13880, 14007, 14018, 14038, 14187, 14230, 14265, 14286, 14360, 14365, 14381, 14382, 14404, 14472, 14483, 14484, 14874, 14884, 14891, 14944, 14990, 14992, 15050, 15087 ) AND ( tbl_item_quality_0.qlt_id IN (211) ) AND ( tbl_item_quality_1.qlt_id IN (212) ) AND tbl_item.item_id != 3182 AND tbl_member.mem_premiumMember='True' AND tbl_item.item_active='True'
AND tbl_item.cfgItem_id = 1
GROUP BY
tbl_item.item_id
HAVING distance is not null
ORDER BY
distance"
["result"]=>
resource(422) of type (mysql result)
["row_counter"]=>
NULL
["statement"]=>
NULL
}
["from"]=>
string(1) "3"
["limit"]=>
int(6)
["numrows"]=>
int(7)
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[8]=>
array(4) {
["file"]=>
string(41) "/home/ireland/public_html/estab/index.php"
["line"]=>
int(394)
["args"]=>
array(1) {
[0]=>
string(82) "/home/ireland/public_html/_div/ireland_guide/establishment/content/estInfo-new.php"
}
["function"]=>
string(7) "require"
}
}
["callback"]=>
NULL
}
