| 0.0007 |
SELECT `c`.`cart_id`, `c`.`customers_id`, `c`.`session_id`, `c`.`products_name`, `c`.`products_id`, `c`.`is_free`, `c`.`is_virtual`, `c`.`qty`, `c`.`weight`, `c`.`tax`, `c`.`ht_price`, `c`.`final_price`, `c`.`options_id`, `c`.`options_values_id`, `c`.`is_gift`
FROM `cart` `c`
WHERE `c`.`session_id` = 'ud63hfk5sjsg969n2bpetpor0cgk6iv2'
AND `c`.`shops_id` = 1
ORDER BY `cart_id` ASC
|
| 0.0470 |
SELECT `p`.`products_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price
FROM `products_to_categories` `ptc`
JOIN `categories` `c` ON `c`.`categories_id` = `ptc`.`categories_id`
JOIN `categories_shops` `cs` ON `c`.`categories_id` = `cs`.`categories_id` AND `cs`.`shops_id` = 1
JOIN `products` `p` ON `p`.`products_id` = `ptc`.`products_id`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
LEFT JOIN `products_artists` `pa` ON `pa`.`products_id` = `p`.`products_id`
LEFT JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
WHERE `p`.`products_status` = 1
AND `ptc`.`categories_id` = 5
GROUP BY `p`.`products_id`
ORDER BY `p`.`products_date_available` DESC, `p`.`products_id` DESC
LIMIT 448, 32
|
| 0.0003 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 8719
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0002 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 8719
ORDER BY `artists_name` ASC
|
| 0.0002 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 8719
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 8719
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 8702
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 8702
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 8702
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 8702
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 8448
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 8448
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 8448
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 8448
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 8691
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 8691
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 8691
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 8691
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 7025
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 7025
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 7025
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 7025
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6941
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6941
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6941
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6941
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6611
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6611
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6611
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6611
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6458
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6458
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6458
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6458
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6456
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6456
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6456
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6456
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6221
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6221
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6221
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6221
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 4518
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 4518
ORDER BY `artists_name` ASC
|
| 0.0002 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 4518
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 4518
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 3398
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 3398
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 3398
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 3398
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 7022
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 7022
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 7022
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 7022
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6946
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6946
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6946
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6946
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6518
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6518
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6518
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6518
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6432
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6432
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6432
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6432
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6430
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6430
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6430
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6430
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6288
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6288
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6288
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6288
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 5995
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 5995
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 5995
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 5995
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 5767
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 5767
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 5767
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 5767
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 4575
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 4575
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 4575
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 4575
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 4334
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 4334
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 4334
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 4334
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 3820
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 3820
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 3820
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 3820
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 4748
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 4748
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 4748
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 4748
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6334
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6334
ORDER BY `artists_name` ASC
|
| 0.0002 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6334
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6334
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 7214
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 7214
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 7214
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 7214
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 922
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 922
ORDER BY `artists_name` ASC
|
| 0.0002 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 922
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 922
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 6698
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 6698
ORDER BY `artists_name` ASC
|
| 0.0002 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 6698
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 6698
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 7246
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 7246
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 7246
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 7246
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 5896
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 5896
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 5896
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 5896
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 8271
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 8271
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 8271
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 8271
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 8693
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 8693
ORDER BY `artists_name` ASC
|
| 0.0001 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 8693
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 8693
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0279 |
SELECT `p`.`products_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price
FROM `products_to_categories` `ptc`
JOIN `categories` `c` ON `c`.`categories_id` = `ptc`.`categories_id`
JOIN `categories_shops` `cs` ON `c`.`categories_id` = `cs`.`categories_id` AND `cs`.`shops_id` = 1
JOIN `products` `p` ON `p`.`products_id` = `ptc`.`products_id`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
LEFT JOIN `products_artists` `pa` ON `pa`.`products_id` = `p`.`products_id`
LEFT JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
WHERE `p`.`products_status` = 1
AND `ptc`.`categories_id` = 5
GROUP BY `p`.`products_id`
ORDER BY `p`.`products_date_available` DESC, `p`.`products_id` DESC
|
