Advertisement
Guest User

Untitled

a guest
Jun 14th, 2011
903
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. 511a512,518
  2. > $position = $idxAdapter->getCheckSql('ca.category_id=MIN(ce.entity_id)',
  3. > 'MIN(' . $idxAdapter->quoteIdentifier('cp.position') . ')',
  4. > 'ROUND((MIN(' . $idxAdapter->quoteIdentifier('ce.position') . ') + 1) * ' .
  5. > '(MIN(' . $idxAdapter->quoteIdentifier('ce.level') . ') + 1) * 10000, 0) + ' .
  6. > 'MIN(' . $idxAdapter->quoteIdentifier('cp.position') . ')'
  7. > );
  8. >
  9. 514c521
  10. < ca.category_id, cp.product_id
  11. ---
  12. > ca.category_id, cp.product_id, {$position} as `position`
  13. 522c529,530
  14. < $this->insertFromSelect($sql, $anchorProductsTable, array('category_id' , 'product_id'));
  15. ---
  16. > $this->insertFromSelect($sql, $anchorProductsTable, array('category_id' , 'product_id', 'position'));
  17. >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement