SELECT a.*, b.*, c.i_num_items, tct.*, 1 as theme_category_table_loaded
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "es_ES")
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
LEFT JOIN oc_t_category_epsilon as tct ON a.pk_i_id = tct.fk_i_category_id
WHERE b.s_name != '' AND a.b_enabled = 1
ORDER BY i_position ASC
0.0011470317840576 SELECT a.pk_i_id, a.i_position, b.*, tct.*, 1 as theme_category_table_loaded
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_epsilon as tct ON a.pk_i_id = tct.fk_i_category_id
WHERE b.s_name != '' AND a.b_enabled = 1
GROUP BY a.pk_i_id
ORDER BY i_position ASC