array(11) { [0]=> array(9) { ["product_id"]=> string(6) "103643" ["product_sku"]=> string(5) "40454" ["product_name"]=> string(136) "Чехол для ноутбука Tucano Stile Work Out, WOSM, кожа/нейлон, 15,4" (внут. 42x32x7 ), цвет черный" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "40454.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(92) "chehol_dlya_noutbuka_Tucano_Stile_Work_Out_WOSM_koja_neylon_154_vnut_42x32x7__tsvet_chernyiy" ["sefcodec"]=> string(20) "sumki_dlya_noutbukov" ["category_id"]=> string(4) "1138" } [1]=> array(9) { ["product_id"]=> string(5) "94739" ["product_sku"]=> string(5) "71058" ["product_name"]=> string(61) "Мышь Logitech Mouse M555b Bluetooth Cordless (910-001267)" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "71058.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(50) "Logitech_Mouse_M555b_Bluetooth_Cordless_910-001267" ["sefcodec"]=> string(20) "myishi_besprovodnyie" ["category_id"]=> string(4) "1210" } [2]=> array(9) { ["product_id"]=> string(5) "89529" ["product_sku"]=> string(5) "87520" ["product_name"]=> string(66) "Сумка Case Logic VNA-216K, нейлон, 15-16", черная" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "87520.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(47) "sumka-Case-Logic-VNA-216K-neylon-15-16-chernaya" ["sefcodec"]=> string(20) "sumki_dlya_noutbukov" ["category_id"]=> string(4) "1138" } [3]=> array(9) { ["product_id"]=> string(6) "102273" ["product_sku"]=> string(5) "88635" ["product_name"]=> string(72) "Сумка Case Logic ENA-116K, полиэстер, 15-16", черная" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "88635.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(50) "sumka-Case-Logic-ENA-116K-poliester-15-16-chernaya" ["sefcodec"]=> string(20) "sumki_dlya_noutbukov" ["category_id"]=> string(4) "1138" } [4]=> array(9) { ["product_id"]=> string(5) "94735" ["product_sku"]=> string(5) "80144" ["product_name"]=> string(50) "Мышь Logitech Mouse M310 Wireless (910-001679)" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "80144.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(39) "Logitech_Mouse_M310_Wireless_910-001679" ["sefcodec"]=> string(20) "myishi_besprovodnyie" ["category_id"]=> string(4) "1210" } [5]=> array(9) { ["product_id"]=> string(5) "90285" ["product_sku"]=> string(5) "22255" ["product_name"]=> string(18) "Pilot - GL (1.8м)" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "22255.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(14) "Pilot_-_GL_18m" ["sefcodec"]=> string(16) "setevyie_filtryi" ["category_id"]=> string(4) "1163" } [6]=> array(9) { ["product_id"]=> string(5) "99258" ["product_sku"]=> string(5) "85914" ["product_name"]=> string(51) "16Gb TRANSCEND (TS16GJF700) USB3.0 Jet Flash Retail" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "85914.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(48) "16Gb_TRANSCEND_TS16GJF700_USB30_Jet_Flash_Retail" ["sefcodec"]=> string(14) "USB_Flash_16gb" ["category_id"]=> string(4) "2426" } [7]=> array(9) { ["product_id"]=> string(5) "94742" ["product_sku"]=> string(5) "70356" ["product_name"]=> string(78) "Мышь Logitech Mouse Nano M305 cordless dark silver (910-000941/910-000937)" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "70356.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(67) "Logitech_Mouse_M305_Nano_Cordless_910-000941_910-000937_Dark_Silver" ["sefcodec"]=> string(20) "myishi_besprovodnyie" ["category_id"]=> string(4) "1210" } [8]=> array(9) { ["product_id"]=> string(5) "99198" ["product_sku"]=> string(5) "38827" ["product_name"]=> string(49) "8Gb TRANSCEND (TS8GJFV10) USB2.0 Jet Flash Retail" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "38827.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(46) "8Gb-TRANSCEND-TS8GJFV10-USB20-Jet-Flash-Retail" ["sefcodec"]=> string(14) "USB_Flash__8gb" ["category_id"]=> string(4) "2425" } [9]=> array(9) { ["product_id"]=> string(4) "8685" ["product_sku"]=> string(5) "45848" ["product_name"]=> string(127) "PARITY Влажные чистящие салфетки для мониторов и телевизоров.(туба) 105шт." ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "45848.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(79) "vlajnyie_chistyaschie_salfetki_dlya_monitorov_i_televizorov_PARITY__tuba_105sht" ["sefcodec"]=> string(21) "chistyaschie_sredstva" ["category_id"]=> string(4) "1102" } [10]=> array(9) { ["product_id"]=> string(4) "8696" ["product_sku"]=> string(5) "24046" ["product_name"]=> string(132) "ПАРИТЕТ [AT24069] чистящие салфетки для мониторов и телевизоров (в тубе, 75шт)" ["product_parent_id"]=> string(1) "0" ["product_full_image"]=> string(9) "24046.jpg" ["xml_id"]=> string(1) "1" ["sefcode"]=> string(80) "chistyaschie_salfetki_dlya_monitorov_i_televizorov_paritet_AT24069__v_tube_75sht" ["sefcodec"]=> string(21) "chistyaschie_sredstva" ["category_id"]=> string(4) "1102" } }

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 DESC
LIMIT 20