 |
Categories |
 |
select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
Resource id #44
select count(*) as count from categories where parent_id = '24'
Resource id #45
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
Resource id #46
select categories_id from categories where parent_id = '24'
Resource id #47
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
Resource id #48
select categories_id from categories where parent_id = '34'
Resource id #49
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47'
Resource id #50
select categories_id from categories where parent_id = '47'
Resource id #51
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
Resource id #52
select categories_id from categories where parent_id = '46'
Resource id #53
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48'
Resource id #54
select categories_id from categories where parent_id = '48'
Resource id #55
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
Resource id #56
select categories_id from categories where parent_id = '49'
Resource id #57
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '114'
Resource id #58
select categories_id from categories where parent_id = '114'
Resource id #59
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142'
Resource id #60
select categories_id from categories where parent_id = '142'
Resource id #61
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91'
Resource id #62
select categories_id from categories where parent_id = '91'
Resource id #63
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '92'
Resource id #64
select categories_id from categories where parent_id = '92'
Resource id #65
select count(*) as count from categories where parent_id = '74'
Resource id #66
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '74'
Resource id #67
select categories_id from categories where parent_id = '74'
Resource id #68
select count(*) as count from categories where parent_id = '112'
Resource id #69
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '112'
Resource id #70
select categories_id from categories where parent_id = '112'
Resource id #71
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86'
Resource id #72
select categories_id from categories where parent_id = '86'
Resource id #73
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115'
Resource id #74
select categories_id from categories where parent_id = '115'
Resource id #75
select count(*) as count from categories where parent_id = '60'
Resource id #76
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
Resource id #77
select categories_id from categories where parent_id = '60'
Resource id #78
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
Resource id #79
select categories_id from categories where parent_id = '61'
Resource id #80
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
Resource id #81
select categories_id from categories where parent_id = '62'
Resource id #82
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
Resource id #83
select categories_id from categories where parent_id = '63'
Resource id #84
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
Resource id #85
select categories_id from categories where parent_id = '64'
Resource id #86
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
Resource id #87
select categories_id from categories where parent_id = '65'
Resource id #88
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
Resource id #89
select categories_id from categories where parent_id = '70'
Resource id #90
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
Resource id #91
select categories_id from categories where parent_id = '71'
Resource id #92
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
Resource id #93
select categories_id from categories where parent_id = '72'
Resource id #94
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
Resource id #95
select categories_id from categories where parent_id = '73'
Resource id #96
select count(*) as count from categories where parent_id = '99'
Resource id #97
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '99'
Resource id #98
select categories_id from categories where parent_id = '99'
Resource id #99
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
Resource id #100
select categories_id from categories where parent_id = '38'
Resource id #101
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82'
Resource id #102
select categories_id from categories where parent_id = '82'
Resource id #103
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83'
Resource id #104
select categories_id from categories where parent_id = '83'
Resource id #105
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84'
Resource id #106
select categories_id from categories where parent_id = '84'
Resource id #107
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '85'
Resource id #108
select categories_id from categories where parent_id = '85'
Resource id #109
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '88'
Resource id #110
select categories_id from categories where parent_id = '88'
Resource id #111
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '89'
Resource id #112
select categories_id from categories where parent_id = '89'
Resource id #113
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
Resource id #114
select categories_id from categories where parent_id = '35'
Resource id #115
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '93'
Resource id #116
select categories_id from categories where parent_id = '93'
Resource id #117
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '100'
Resource id #118
select categories_id from categories where parent_id = '100'
Resource id #119
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '102'
Resource id #120
select categories_id from categories where parent_id = '102'
Resource id #121
select count(*) as count from categories where parent_id = '131'
Resource id #122
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131'
Resource id #123
select categories_id from categories where parent_id = '131'
Resource id #124
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132'
Resource id #125
select categories_id from categories where parent_id = '132'
Resource id #126
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133'
Resource id #127
select categories_id from categories where parent_id = '133'
Resource id #128
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134'
Resource id #129
select categories_id from categories where parent_id = '134'
Resource id #130
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135'
Resource id #131
select categories_id from categories where parent_id = '135'
Resource id #132
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '136'
Resource id #133
select categories_id from categories where parent_id = '136'
Resource id #134
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138'
Resource id #135
select categories_id from categories where parent_id = '138'
Resource id #136
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139'
Resource id #137
select categories_id from categories where parent_id = '139'
Resource id #138
select count(*) as count from categories where parent_id = '21'
Resource id #139
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
Resource id #140
select categories_id from categories where parent_id = '21'
Resource id #141
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
Resource id #142
select categories_id from categories where parent_id = '40'
Resource id #143
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
Resource id #144
select categories_id from categories where parent_id = '51'
Resource id #145
select count(*) as count from categories where parent_id = '103'
Resource id #146
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '103'
Resource id #147
select categories_id from categories where parent_id = '103'
Resource id #148
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '104'
Resource id #149
select categories_id from categories where parent_id = '104'
Resource id #150
select count(*) as count from categories where parent_id = '22'
Resource id #151
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
Resource id #152
select categories_id from categories where parent_id = '22'
Resource id #153
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
Resource id #154
select categories_id from categories where parent_id = '52'
Resource id #155
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
Resource id #156
select categories_id from categories where parent_id = '53'
Resource id #157
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
Resource id #158
select categories_id from categories where parent_id = '54'
Resource id #159
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55'
Resource id #160
select categories_id from categories where parent_id = '55'
Resource id #161
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56'
Resource id #162
select categories_id from categories where parent_id = '56'
Resource id #163
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
Resource id #164
select categories_id from categories where parent_id = '57'
Resource id #165
select count(*) as count from categories where parent_id = '33'
Resource id #166
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
Resource id #167
select categories_id from categories where parent_id = '33'
Resource id #168
select count(*) as count from categories where parent_id = '143'
Resource id #169
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143'
Resource id #170
select categories_id from categories where parent_id = '143'
Resource id #171
select count(*) as count from categories where parent_id = '90'
Resource id #172
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '90'
Resource id #173
select categories_id from categories where parent_id = '90'
Resource id #174
select count(*) as count from categories where parent_id = '26'
Resource id #175
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
Resource id #176
select categories_id from categories where parent_id = '26'
Resource id #177
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '94'
Resource id #178
select categories_id from categories where parent_id = '94'
Resource id #179
select count(*) as count from categories where parent_id = '121'
Resource id #180
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121'
Resource id #181
select categories_id from categories where parent_id = '121'
Resource id #182
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122'
Resource id #183
select categories_id from categories where parent_id = '122'
Resource id #184
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123'
Resource id #185
select categories_id from categories where parent_id = '123'
Resource id #186
select count(*) as count from categories where parent_id = '96'
Resource id #187
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '96'
Resource id #188
select categories_id from categories where parent_id = '96'
Resource id #189
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129'
Resource id #190
select categories_id from categories where parent_id = '129'
Resource id #191
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124'
Resource id #192
select categories_id from categories where parent_id = '124'
Resource id #193
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125'
Resource id #194
select categories_id from categories where parent_id = '125'
Resource id #195
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126'
Resource id #196
select categories_id from categories where parent_id = '126'
Resource id #197
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '127'
Resource id #198
select categories_id from categories where parent_id = '127'
Resource id #199
select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128'
Resource id #200
select categories_id from categories where parent_id = '128'
Resource id #201
|
