Drupal.cz

http://www.google.cz/search?…

Ještě dodám..kdyby měl někdo ten samej problém tak exportuje databázi bez těhle tří tabulek a potom je dodělejte přes příkaz sql (nezapomeňte odstranit <?php a ?>) :

<?php
CREATE VIEW uc_order_products_qty_vw (nid,order_count,avg_qty,sum_qty,max_qty,min_qty)  AS SELECT `op`.`nid` AS `nid`, COUNT(`op`.`nid`) AS `order_count`,AVG(`op`.`qty`) AS `avg_qty`, SUM(`op`.`qty`) AS `sum_qty`,MAX(`op`.`qty`) AS `max_qty`, MIN(`op`.`qty`) AS `min_qty` FROM `uc_order_products` `op` GROUP BY `op`.`nid` ORDER BY `op`.`nid`;

CREATE VIEW uc_order_products_user_vw (nid,uid,order_count,avg_qty,sum_qty,max_qty,min_qty)  AS SELECT `op`.`nid` AS `nid`, `o`.`uid` AS `uid`, COUNT(`o`.`order_id`) AS `order_count`, AVG(`op`.`qty`) AS `avg_qty`, SUM(`op`.`qty`) AS `sum_qty`,MAX(`op`.`qty`) AS `max_qty`, MIN(`op`.`qty`) AS `min_qty` FROM `uc_order_products` `op`, `uc_orders` `o` where `op`.`order_id` =`o`.`order_id` GROUP BY `o`.`uid`,`op`.`nid` ORDER BY `o`.`uid`,`op`.`nid`;

CREATE VIEW uc_order_products_pair_vw (nid,pair_nid,pair_sum_qty,order_count)  AS SELECT op1.`nid` AS `nid`, op2.`nid` AS `pair_nid`, SUM(op2.`qty`) AS `pair_sum_qty`, COUNT(op2.`nid`) AS `order_count` FROM `uc_order_products` op1, `uc_order_products` op2 WHERE op1.`order_id` = op2.`order_id` AND op1.`nid` <> op2.`nid` GROUP BY `nid`, `pair_nid`  ORDER BY `nid`, `order_count` DESC, `pair_sum_qty` DESC;
?>