array(8) {
[0]=>
array(9) {
["product_id"]=>
string(5) "91507"
["product_sku"]=>
string(5) "76083"
["product_name"]=>
string(78) "Монитор Samsung E1920NR (CLASBU) 19" | 1280x1024 | 5ms | D-SUB | Black"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "76083.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(56) "Samsung_E1920NR_CLASBU__19__1280x1024__5ms__D-SUB__Black"
["sefcodec"]=>
string(16) "monitoryi_LCD_19"
["category_id"]=>
string(4) "1240"
}
[1]=>
array(9) {
["product_id"]=>
string(5) "90215"
["product_sku"]=>
string(5) "73968"
["product_name"]=>
string(25) "BACK-UPS RS 550 (BR550GI)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "73968.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(23) "BACK-UPS_RS_550_BR550GI"
["sefcodec"]=>
string(33) "UPS_American_Power_Conversion_APC"
["category_id"]=>
string(4) "1158"
}
[2]=>
array(9) {
["product_id"]=>
string(5) "91429"
["product_sku"]=>
string(5) "77391"
["product_name"]=>
string(65) "Samsung E1720NR (CLASB) 17" | 1280 x 1024 | 5ms | D-SUB | Black"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "77391.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(58) "Samsung-E1720NR-CLASB---17--1280-x-1024--5ms--D-SUB--Black"
["sefcodec"]=>
string(16) "monitoryi_LCD_17"
["category_id"]=>
string(4) "1239"
}
[3]=>
array(9) {
["product_id"]=>
string(5) "90206"
["product_sku"]=>
string(5) "35332"
["product_name"]=>
string(28) "BACK-UPS ES 400VA (BE400-RS)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "35332.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(26) "BACK-UPS_ES_400VA_BE400-RS"
["sefcodec"]=>
string(33) "UPS_American_Power_Conversion_APC"
["category_id"]=>
string(4) "1158"
}
[4]=>
array(9) {
["product_id"]=>
string(5) "89153"
["product_sku"]=>
string(5) "59455"
["product_name"]=>
string(38) "Panasonic KX-TS2358 RUB (черный)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "59455.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(32) "Panasonic-KX-TS2358-RUB-chernyiy"
["sefcodec"]=>
string(20) "provodnyie_telefonyi"
["category_id"]=>
string(4) "1143"
}
[5]=>
array(9) {
["product_id"]=>
string(5) "90289"
["product_sku"]=>
string(5) "22256"
["product_name"]=>
string(17) "Pilot - L (1.8м)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "22256.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(13) "Pilot_-_L_18m"
["sefcodec"]=>
string(16) "setevyie_filtryi"
["category_id"]=>
string(4) "1163"
}
[6]=>
array(9) {
["product_id"]=>
string(5) "89142"
["product_sku"]=>
string(5) "11236"
["product_name"]=>
string(38) "Panasonic KX-TS2350 RUB (чёрный)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "11236.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(31) "Panasonic-KX-TS2350-RUB-chrnyiy"
["sefcodec"]=>
string(20) "provodnyie_telefonyi"
["category_id"]=>
string(4) "1143"
}
[7]=>
array(9) {
["product_id"]=>
string(6) "100550"
["product_sku"]=>
string(5) "41667"
["product_name"]=>
string(40) "Sven Optima Pro 8 розеток 1.8 м"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "41667.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(31) "Sven_Optima__Pro_8_rozetok_18_m"
["sefcodec"]=>
string(21) "setevyie_filtryi_SVEN"
["category_id"]=>
string(4) "2508"
}
}
DB function failed with error number 2006
MySQL server has gone away SQL=SELECT p.product_id,p.product_name,x.category_id FROM
jos_vm_product p
LEFT JOIN jos_vm_product_category_xref x ON p.product_id=x.product_id
LEFT JOIN jos_vm_category c ON x.category_id=c.category_id
WHERE p.product_publish='Y'
AND c.category_publish='Y'
ORDER BY p.product_id ASC
LIMIT 20
SQL = SELECT p.product_id,p.product_name,x.category_id FROM
jos_vm_product p
LEFT JOIN jos_vm_product_category_xref x ON p.product_id=x.product_id
LEFT JOIN jos_vm_category c ON x.category_id=c.category_id
WHERE p.product_publish='Y'
AND c.category_publish='Y'
ORDER BY p.product_id ASC
LIMIT 20
44