array(8) {
[0]=>
array(9) {
["product_id"]=>
string(6) "100607"
["product_sku"]=>
string(5) "77966"
["product_name"]=>
string(79) "MS Office Home and Business 2010 32-bit/x64 Russian Russian DVD BOX (T5D-00415)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "77966.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(77) "MS_Office_Home_and_Business_2010_32-bit_x64_Russian_Russian_DVD_BOX_T5D-00415"
["sefcodec"]=>
string(17) "Microsoft__Office"
["category_id"]=>
string(4) "2514"
}
[1]=>
array(9) {
["product_id"]=>
string(5) "90210"
["product_sku"]=>
string(5) "69343"
["product_name"]=>
string(32) "BACK-UPS RS 1100VA (BR1100CI-RS)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "69343.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(30) "BACK-UPS_RS_1100VA_BR1100CI-RS"
["sefcodec"]=>
string(33) "UPS_American_Power_Conversion_APC"
["category_id"]=>
string(4) "1158"
}
[2]=>
array(9) {
["product_id"]=>
string(5) "92677"
["product_sku"]=>
string(5) "86121"
["product_name"]=>
string(132) "MS Windows 7 PRO 32-bit SP1 Russian DSP OEI (DVD) (FQC-04671) (Только для сборщиков ПК и продавцов)"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "86121.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(99) "MS-Windows-7-PRO-32-bit--SP1-Russian--DSP-OEI-DVD--FQC-04671-tolko-dlya-sborschikov-pk-i-prodavtsov"
["sefcodec"]=>
string(9) "Microsoft"
["category_id"]=>
string(4) "1273"
}
[3]=>
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"
}
[4]=>
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"
}
[5]=>
array(9) {
["product_id"]=>
string(5) "90454"
["product_sku"]=>
string(5) "85884"
["product_name"]=>
string(44) "Клавиатура Genius KB-202 USB Black"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "85884.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(23) "Genius_KB-202_USB_Black"
["sefcodec"]=>
string(11) "klaviaturyi"
["category_id"]=>
string(4) "1206"
}
[6]=>
array(9) {
["product_id"]=>
string(5) "89930"
["product_sku"]=>
string(5) "42035"
["product_name"]=>
string(60) "Мышь Logitech RX250 Optical Mouse (910-000199) Black OEM"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "42035.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(49) "Logitech_RX250_Optical_Mouse_910-000199_Black_OEM"
["sefcodec"]=>
string(6) "myishi"
["category_id"]=>
string(4) "1209"
}
[7]=>
array(9) {
["product_id"]=>
string(5) "89899"
["product_sku"]=>
string(5) "36051"
["product_name"]=>
string(41) "Мышь Genius Xscroll Optical USB black"
["product_parent_id"]=>
string(1) "0"
["product_full_image"]=>
string(9) "36051.jpg"
["xml_id"]=>
string(1) "1"
["sefcode"]=>
string(32) "Genius_Xscroll_Optical_USB_black"
["sefcodec"]=>
string(6) "myishi"
["category_id"]=>
string(4) "1209"
}
}
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 c.category_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 c.category_id ASC
LIMIT 20
44