\$basket_name: 3_17_75_227_ec2_3_17_75_227_us_east_2_compute_amazonaws_com
\$query_basket: CREATE TABLE IF NOT EXISTS `3_17_75_227_ec2_3_17_75_227_us_east_2_compute_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 ="218" OR s.sorts_id ="218") AND s.sorts_id = i.items_sorts_id) GROUP BY i.items_id ORDER BY MAX(inv.inventory_price)
Notebooky
© Copyright 2008 - 2024,
Elektrico - ing. Pavel Zahradník, All rights reserved