SELECT 
  c.category_id, 
  c.parent_id, 
  cd.category 
FROM 
  cscart_categories c 
  INNER JOIN cscart_category_descriptions cd ON (cd.category_id = c.category_id) 
ORDER BY 
  c.parent_id ASC

Query time 0.00032

Result

category_id parent_id category
1 0 Hard Dance
2 0 House
3 0 Hard Trance
4 0 Hard House
6 0 Exclusive
50 0 Free Downloads
7 0 Featured
13 0 Compilations
20 0 Sample Packs
57 0 DJ Charts & Bundles
21 0 Classics
22 0 Hardcore
60 0 CDs, Vinyl & USB
25 0 Hardstyle
43 0 Merchandise
28 1 Tech Dance
37 1 Top 10
31 3 German Trance
38 3 Top 10
29 4 Bounce
30 4 NRG
36 4 Top 10
35 6 Top 10
80 6 New Exclusive Releases - Past 7 Days
87 7 Featured Hardcore
88 7 Featured Hard House
58 7 Featured Merchandise
63 7 Featured Hardstyle New
65 7 Featured Hard Trance New
66 7 Featured Hard Dance New
76 7 Featured Compilations
17 13 Hard Dance
18 13 Hard House
19 13 Hard Trance
23 13 Hardcore
26 13 Hardstyle
77 13 Top 50
86 20 Track Stems
74 20 Sample Packs
75 20 VST Preset Banks
78 20 Project Files
42 21 Top 25
32 22 Freeform
33 22 Gabba
34 22 Old Skool
39 22 Top 10
40 25 Top 10
44 43 Mens Clothing
45 43 Womens Clothing
85 43 Flags
48 43 Hoodies
52 43 Hats
53 43 Bags
54 43 Phone Cases
69 43 Mugs
81 43 Slipmats
82 43 Kids Clothing
46 44 Mens T-Shirts
51 44 Mens Sweatshirts
47 45 Womens T-Shirts
56 45 Womens Vests
68 57 Label Back Catalogue Bundles
71 57 DJ Charts
72 57 Bundles
61 60 CD's
62 60 Vinyl
70 60 USB
83 82 Kids T-Shirts
84 82 Baby Vests