Subversion Repositories SmartDukaan

Rev

Rev 2533 | Rev 3496 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2533 Rev 3280
Line 128... Line 128...
128 
         <partitioning>
 128 
         <partitioning>
129 
           <method>none</method>
 129 
           <method>none</method>
130 
           <schema_name/>
 130 
           <schema_name/>
131 
           </partitioning>
 131 
           </partitioning>
132 
    <connection>catalogDC_Prod</connection>
 132 
    <connection>catalogDC_Prod</connection>
133 
    <sql>SELECT item.id, product_group, brand, model_number, model_name,
133 
    <sql>SELECT SQL_NO_CACHE item.id, product_group, brand, model_number, model_name,
134 
       color, category.label category, parent.label parent_category
 134 
       color, category.label category, parent.label parent_category
135 
FROM item, category, category as parent
135 
FROM item, category, category as parent
136 
where item.category = category.id
136 
where item.category = category.id
137 
and category.parent_category_id = parent.id</sql>
 137 
and category.parent_category_id = parent.id</sql>
138 
    <limit>0</limit>
 138 
    <limit>0</limit>