ING. PAVEL ZAHRADNÍK
Tel: +420 723 862 361
\$basket_name: 34_204_52_16_ec2_34_204_52_16_compute_1_amazonaws_com
\$query_basket: CREATE TABLE IF NOT EXISTS `34_204_52_16_ec2_34_204_52_16_compute_1_amazonaws_com` ( `baskets_id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `baskets_items_id` SMALLINT( 5 ) NOT NULL , `baskets_quantity` SMALLINT( 5 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET cp1250 COLLATE cp1250_czech_cs
\$query: SELECT sorts_id, sorts_name, sorts_menu_under, sorts_href, sorts_images FROM sorts ORDER BY sorts_menu_priority
\$query: SELECT i.items_id, i.items_name, i.items_description, SUM(inv.inventory_quantity), inv.inventory_delivery, MAX(inv.inventory_price), im.images_path FROM items i, images im, inventory inv, sorts s WHERE (i.items_id = inv.inventory_items_id AND i.items_visibility = 1 AND i.items_images_id = im.images_id AND (s.sorts_id ="468" OR s.sorts_id ="468") AND s.sorts_id = i.items_sorts_id) GROUP BY i.items_id ORDER BY MAX(inv.inventory_price)
Datové
Tato sekce zatím neobsahuje žádnou položku...
© Copyright 2008 - 2024, Elektrico - ing. Pavel Zahradník, All rights reserved