List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'select b2p.boxes_group, b.code from :table_templates_boxes_to_pages b2p, :table_templates_boxes b, :table_templates t where b2p.templates_id = :templates_id and b2p.page_specific = 1 and b2p.content_page in ("*", "' . OSCOM::getSiteApplication( ) . '/*", "' . OSCOM::getSiteApplication( ) . '/' . substr($OSCOM_Template->getPageContentsFilename( ), 0, strrpos($OSCOM_Template->getPageContentsFilename( ), '.')) . '") and b2p.templates_boxes_id = b.id and b.modules_group = :modules_group and b2p.templates_id = t.id order by b2p.boxes_group, b2p.sort_order' | 1 |
|
| 'select r.reviews_id, r.products_id, greatest(r.date_added, greatest(r.date_added, r.last_modified)) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.code as languages_code from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by date_last_modified desc limit 6' | 1 |
|
| 'Show a warning if the digital product download directory does not exist.' | 1 |
|
| 'Show a warning if PHP is configured to automatically start sessions.' | 1 |
|
| 'Show a warning if the file-based session directory does not exist.' | 1 |
|
| 'Show a warning if the configuration file is writeable.' | 1 |
|
| 'Show a warning message if the installation module exists.' | 1 |
|
| 'Show a warning message if the set language locale does not exist on the server.' | 1 |
|
| 'Show all database queries made.' | 1 |
|
| 'Show Database Queries' | 1 |
|
| 'Show the page execution time.' | 1 |
|
| 'Show The Page Execution Time' | 1 |
|
| 'Show recent searches.' | 1 |
|
| 'select customers_id, customers_gender, customers_lastname, customers_firstname, customers_status, date_account_created from :table_customers order by date_account_created desc limit 6' | 1 |
|
| 'select products_id, greatest(products_date_added, products_last_modified) as date_last_modified from :table_products where parent_id is null order by date_last_modified desc limit 6' | 1 |
|
| 'select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, "1970-01-01")) as date_last_modified, s.orders_status_name, ot.text as order_total from :table_orders o, :table_orders_total ot, :table_orders_status s where o.orders_id = ot.orders_id and ot.class = "total" and o.orders_status = s.orders_status_id and s.language_id = :language_id order by date_last_modified desc limit 6' | 1 |
|
| 'select * from :table_zones where zone_country_id = :zone_country_id and (zone_name like :zone_name or zone_code like :zone_code) order by zone_name' | 1 |
|
| 'select * from :table_languages where languages_id = :languages_id' | 1 |
|
| 'select countries_id, countries_name from :table_countries where countries_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by countries_name' | 1 |
|
| 'select code from :table_currencies where currencies_id = :currencies_id' | 1 |
|
| 'delete from :table_currencies where currencies_id = :currencies_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_currencies order by title' | 1 |
|
| 'select * from :table_currencies where' | 1 |
|
| 'update :table_currencies set title = :title, code = :code, symbol_left = :symbol_left, symbol_right = :symbol_right, decimal_places = :decimal_places, value = :value where currencies_id = :currencies_id' | 1 |
|
| 'insert into :table_currencies (title, code, symbol_left, symbol_right, decimal_places, value) values (:title, :code, :symbol_left, :symbol_right, :decimal_places, :value)' | 1 |
|
| 'select zone_id, zone_name from :table_zones where zone_id in ("' . implode('", "', array_unique(array_filter($_POST['batch'], 'is_numeric'))) . '") order by zone_name' | 1 |
|
| 'select * from :table_zones where zone_id = :zone_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS c.*, count(z.zone_id) as total_zones from :table_countries c left join :table_zones z on (c.countries_id = z.zone_country_id) where (c.countries_name like :countries_name or c.countries_iso_code_2 like :countries_iso_code_2 or c.countries_iso_code_3 like :countries_iso_code_3 or z.zone_name like :zone_name or z.zone_code like :zone_code) group by c.countries_id order by c.countries_name' | 1 |
|
| 'update :table_zones set zone_name = :zone_name, zone_code = :zone_code, zone_country_id = :zone_country_id where zone_id = :zone_id' | 1 |
|
| 'insert into :table_zones (zone_name, zone_code, zone_country_id) values (:zone_name, :zone_code, :zone_country_id)' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS c.*, count(z.zone_id) as total_zones from :table_countries c left join :table_zones z on (c.countries_id = z.zone_country_id) group by c.countries_id order by c.countries_name' | 1 |
|
| 'delete from :table_zones where zone_id = :zone_id' | 1 |
|
| 'select c.*, count(z.zone_id) as total_zones2 from :table_countries c left join :table_zones z on (c.countries_id = z.zone_country_id) where c.countries_id = :countries_id' | 1 |
|
| 'select languages_id from :table_languages where code = :code' | 1 |
|
| 'insert into :table_modules (title, code, author_name, author_www, modules_group) values (:title, :code, :author_name, :author_www, :modules_group)' | 1 |
|
| 'update :table_currencies set value = :value, last_updated = now() where currencies_id = :currencies_id' | 1 |
|
| 'select banners_id, date_scheduled from :table_banners where date_scheduled != ""' | 1 |
|
| 'update :table_customers set customers_gender = :customers_gender, customers_firstname = :customers_firstname, customers_lastname = :customers_lastname, customers_email_address = :customers_email_address, customers_dob = :customers_dob, date_account_last_modified = now() where customers_id = :customers_id' | 1 |
|
| 'update :table_customers set customers_password = :customers_password, date_account_last_modified = now() where customers_id = :customers_id' | 1 |
|
| 'select customers_password from :table_customers where customers_id = :customers_id' | 1 |
|
| 'select customers_password from :table_customers where customers_email_address = :customers_email_address limit 1' | 1 |
|
| 'select customers_id from :table_customers where customers_email_address = :customers_email_address and customers_id != :customers_id limit 1' | 1 |
|
| 'update :table_customers set date_last_logon = now(), number_of_logons = number_of_logons+1 where customers_id = :customers_id' | 1 |
|
| 'select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from :table_banners b, :table_banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id' | 1 |
|
| 'select customers_gender, customers_firstname, customers_lastname, date_format(customers_dob, "%Y") as customers_dob_year, date_format(customers_dob, "%m") as customers_dob_month, date_format(customers_dob, "%d") as customers_dob_date, customers_email_address from :table_customers where customers_id = :customers_id' | 1 |
|
| 'select status from :table_banners where banners_id = :banners_id' | 1 |
|
| 'select banners_id from :table_banners where status = 1 and banners_group = :banners_group' | 1 |
|
| 'select * from :table_banners where banners_id = :banners_id and status = 1' | 1 |
|
| 'select banners_url from :table_banners where banners_id = :banners_id and status = 1' | 1 |
|
| 'update :table_banners set status = 1, date_status_change = now(), date_scheduled = NULL where banners_id = :banners_id' | 1 |
|
| 'update :table_banners set status = 0, date_status_change = now() where banners_id = :banners_id' | 1 |
|
| 'insert into :table_customers (customers_firstname, customers_lastname, customers_email_address, customers_newsletter, customers_status, customers_ip_address, customers_password, customers_gender, customers_dob, number_of_logons, date_account_created) values (:customers_firstname, :customers_lastname, :customers_email_address, :customers_newsletter, :customers_status, :customers_ip_address, :customers_password, :customers_gender, :customers_dob, :number_of_logons, now())' | 1 |
|
| 'select code from :table_modules where modules_group = :modules_group' | 1 |
|
| 'insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values (:configuration_title, :configuration_key, :configuration_value, :configuration_description, :configuration_group_id, :sort_order, :use_function, :set_function, now())' | 1 |
|
| 'select ab.entry_firstname as firstname, ab.entry_lastname as lastname, ab.entry_company as company, ab.entry_street_address as street_address, ab.entry_suburb as suburb, ab.entry_city as city, ab.entry_postcode as postcode, ab.entry_state as state, ab.entry_zone_id as zone_id, ab.entry_country_id as country_id, z.zone_code as zone_code, c.countries_name as country_title from :table_address_book ab left join :table_zones z on (ab.entry_zone_id = z.zone_id), :table_countries c where ab.address_book_id = :address_book_id and ab.entry_country_id = c.countries_id' | 1 |
|
| 'delete from :table_modules where code = :code and modules_group = :modules_group' | 1 |
|
| 'select geo_zone_id, geo_zone_name from :table_geo_zones order by geo_zone_name' | 1 |
|
| 'select id, credit_card_name from :table_credit_cards where credit_card_status = :credit_card_status order by sort_order, credit_card_name' | 1 |
|
| 'select geo_zone_name from :table_geo_zones where geo_zone_id = :geo_zone_id' | 1 |
|
| 'select tax_class_title from :table_tax_class where tax_class_id = :tax_class_id' | 1 |
|
| 'select * from :table_currencies' | 1 |
|
| 'select * from :table_countries order by countries_name' | 1 |
|
| 'select z.zone_id, z.zone_country_id, z.zone_name, c.countries_name from :table_zones z, :table_countries c where' | 1 |
|
| 'select countries_name from :table_countries where countries_id = :countries_id' | 1 |
|
| 'select countries_iso_code_2 from :table_countries where countries_id = :countries_id' | 1 |
|
| 'select countries_iso_code_3 from :table_countries where countries_id = :countries_id' | 1 |
|
| 'select address_format from :table_countries where countries_id = :countries_id' | 1 |
|
| 'select zone_name from :table_zones where zone_id = :zone_id' | 1 |
|
| 'select zone_code from :table_zones where zone_id = :zone_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_currencies where (title like :title or code like :code or symbol_left like :symbol_left or symbol_right like :symbol_right) order by title' | 1 |
|
| 'select currencies_id, title, code from :table_currencies where currencies_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by title' | 1 |
|
| 'insert into :table_banners_history (banners_id, banners_shown, banners_history_date) values (:banners_id, 1, now())' | 1 |
|
| 'delete from :table_products_variants_groups where id = :id' | 1 |
|
| 'select id, title from :table_products_variants_groups where languages_id = :languages_id and id in (":id") order by title' | 1 |
|
| 'select id, title from :table_products_variants_values where id in (":id") and languages_id = :languages_id order by title' | 1 |
|
| 'select languages_id, title from :table_products_variants_values where id = :id' | 1 |
|
| 'select * from :table_products_variants_groups where id = :id and languages_id = :languages_id' | 1 |
|
| 'select max(id) as id from :table_products_variants_groups' | 1 |
|
| 'update :table_products_variants_groups set title = :title, sort_order = :sort_order, module = :module where id = :id and languages_id = :languages_id' | 1 |
|
| 'select * from :table_products_variants_values where id = :id and languages_id = :languages_id' | 1 |
|
| 'select count(*) as total from :table_products_variants_values where products_variants_groups_id = :products_variants_groups_id' | 1 |
|
| 'select max(id) as id from :table_products_variants_values' | 1 |
|
| 'update :table_products_variants_values set title = :title, sort_order = :sort_order where id = :id and languages_id = :languages_id' | 1 |
|
| 'delete from :table_products_variants_values where id = :id and products_variants_groups_id = :products_variants_groups_id' | 1 |
|
| 'select pa.* from :table_product_attributes pa, :table_templates_boxes tb where tb.code = :code and tb.modules_group = :modules_group and tb.id = pa.id and unix_timestamp(now()) > unix_timestamp(str_to_date(pa.value, "%Y-%m-%d"))' | 1 |
|
| 'delete from :table_product_attributes where id = :id and products_id = :products_id' | 1 |
|
| 'select str_to_date(pa.value, "%Y-%m-%d") as products_date_available from :table_product_attributes pa, :table_templates_boxes tb where tb.code = :code and tb.modules_group = :modules_group and tb.id = pa.id' | 1 |
|
| 'select id, title, sort_order from :table_products_variants_values where products_variants_groups_id = :products_variants_groups_id and languages_id = :languages_id order by sort_order, title' | 1 |
|
| 'select id, title, sort_order from :table_products_variants_groups where languages_id = :languages_id order by sort_order, title' | 1 |
|
| 'select payment_module from :table_orders where orders_id = :orders_id limit 1' | 1 |
|
| 'select m.*, mi.* from :table_manufacturers m, :table_manufacturers_info mi where m.manufacturers_id = :manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id' | 1 |
|
| 'update :table_weight_classes_rules set weight_class_rule = :weight_class_rule where weight_class_from_id = :weight_class_from_id and weight_class_to_id = :weight_class_to_id' | 1 |
|
| 'select weight_class_id from :table_weight_classes where weight_class_id != :weight_class_id and language_id = :language_id' | 1 |
|
| 'delete from :table_weight_classes where weight_class_id = :weight_class_id' | 1 |
|
| 'select manufacturers_url, languages_id from :table_manufacturers_info where manufacturers_id = :manufacturers_id' | 1 |
|
| 'select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from :table_manufacturers order by manufacturers_name' | 1 |
|
| 'select manufacturers_id, manufacturers_name from :table_manufacturers where manufacturers_id in (":manufacturers_id") order by manufacturers_name' | 1 |
|
| 'update :table_manufacturers set manufacturers_name = :manufacturers_name, last_modified = now() where manufacturers_id = :manufacturers_id' | 1 |
|
| 'select b2p.boxes_group, b2p.content_page, b.code from :table_templates_boxes_to_pages b2p, :table_templates_boxes b, :table_templates t where b2p.templates_id = :templates_id and b2p.content_page in ("*", "' . OSCOM::getSiteApplication( ) . '/*", "' . OSCOM::getSiteApplication( ) . '/' . substr($OSCOM_Template->getPageContentsFilename( ), 0, strrpos($OSCOM_Template->getPageContentsFilename( ), '.')) . '") and b2p.templates_boxes_id = b.id and b.modules_group = :modules_group and b2p.templates_id = t.id order by b2p.boxes_group, b2p.sort_order' | 1 |
|
| 'insert into :table_manufacturers (manufacturers_name, date_added) values (:manufacturers_name, now())' | 1 |
|
| 'update :table_manufacturers set manufacturers_image = :manufacturers_image where manufacturers_id = :manufacturers_id' | 1 |
|
| 'update :table_manufacturers_info set manufacturers_url = :manufacturers_url where manufacturers_id = :manufacturers_id and languages_id = :languages_id' | 1 |
|
| 'select manufacturers_image from :table_manufacturers where manufacturers_id = :manufacturers_id' | 1 |
|
| 'select products_id from :table_products where manufacturers_id = :manufacturers_id' | 1 |
|
| 'delete from :table_manufacturers where manufacturers_id = :manufacturers_id' | 1 |
|
| 'select p.products_id, pd.products_name, str_to_date(pa.value, "%Y-%m-%d") as products_date_available from :table_products p, :table_products_description pd, :table_product_attributes pa, :table_templates_boxes tb where tb.code = :code and tb.modules_group = :modules_group and tb.id = pa.id and pa.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = :language_id order by products_date_available' | 1 |
|
| 'select customers_name, customers_email_address, orders_status, date_purchased from :table_orders where orders_id = :orders_id' | 1 |
|
| 'delete from :table_product_attributes where id = :id' | 1 |
|
| 'show tables' | 1 |
|
| 'select id, title from :table_products_images_groups where language_id = :language_id order by title' | 1 |
|
| 'select id, title from :table_products_images_groups where id in (":id") and language_id = :language_id order by title' | 1 |
|
| 'select * from :table_products_images_groups where id = :id and language_id = :language_id' | 1 |
|
| 'select max(id) as id from :table_products_images_groups' | 1 |
|
| 'update :table_products_images_groups set title = :title, code = :code, size_width = :size_width, size_height = :size_height, force_size = :force_size where id = :id and language_id = :language_id' | 1 |
|
| 'delete from :table_products_images_groups where id = :id' | 1 |
|
| 'show fields from :table' | 1 |
|
| 'delete from :table_whos_online where session_id = :session_id' | 1 |
|
| 'show keys from :table' | 1 |
|
| 'select :columns from :table' | 1 |
|
| 'insert into ' . $table . ' (' . implode(', ', $table_list) . ') values (' | 1 |
|
| 'delete from :table_sessions' | 1 |
|
| 'delete from :table_whos_online' | 1 |
|
| 'insert into :table_configuration values ("", "Last Database Restore", "DB_LAST_RESTORE", :filename, "Last database restore file", "6", "", "", now(), "", "")' | 1 |
|
| 'select language_id, title from :table_products_images_groups where id = :id' | 1 |
|
| 'select * from :table_whos_online where session_id = :session_id' | 1 |
|
| 'update :table_orders set orders_status = :orders_status, last_modified = now() where orders_id = :orders_id' | 1 |
|
| 'select count(*) as total_products from :table_products where products_types_id = :products_types_id' | 1 |
|
| 'select o.orders_id, o.customers_ip_address, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, greatest(date_purchased, coalesce(last_modified, date_purchased)) as date_sort, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from :table_orders o, :table_orders_total ot, :table_orders_status s where o.orders_id = ot.orders_id and ot.class = "total" and o.orders_status = s.orders_status_id and s.language_id = :language_id' | 1 |
|
| 'select orders_id, customers_name from :table_orders where orders_id in (":orders_id") order by orders_id' | 1 |
|
| 'update :table_products set products_quantity = products_quantity + :products_quantity, products_ordered = products_ordered - :products_ordered where products_id = :products_id' | 1 |
|
| 'select products_quantity from :table_products where products_id = :products_id and products_Status = 0' | 1 |
|
| 'update :table_products set products_status = 1 where products_id = :products_id' | 1 |
|
| 'select * from :table_product_types where id = :id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_product_types order by title' | 1 |
|
| 'select session_id, full_name from :table_whos_online where session_id in (":session_id") order by full_name' | 1 |
|
| 'update :table_product_types set title = :title where id = :id' | 1 |
|
| 'insert into :table_product_types (title) values (:title)' | 1 |
|
| 'delete from :table_product_types where id = :id' | 1 |
|
| 'insert into :table_product_types_assignments (types_id, action, module, sort_order) values (:types_id, :action, :module, :sort_order)' | 1 |
|
| 'select configuration_title, configuration_key, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_key = :configuration_key' | 1 |
|
| 'select customer_id, full_name, ip_address, time_entry, time_last_click, session_id from :table_whos_online order by time_last_click desc' | 1 |
|
| 'update :table_banners_history set banners_shown = banners_shown + 1 where banners_id = :banners_id and date_format(banners_history_date, "%Y%m%d") = date_format(now(), "%Y%m%d")' | 1 |
|
| 'update :table_banners_history set banners_clicked = banners_clicked + 1 where banners_id = :banners_id and date_format(banners_history_date, "%Y%m%d") = date_format(now(), "%Y%m%d")' | 1 |
|
| 'insert into :table_weight_classes (weight_class_id, language_id, weight_class_key, weight_class_title) values (:weight_class_id, :language_id, :weight_class_key, :weight_class_title)' | 1 |
|
| 'select p.products_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_keyword, s.specials_new_products_price, i.image from :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd, :table_specials s where s.status = 1 and s.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by s.specials_date_added desc limit :max_random_select_specials' | 1 |
|
| "select distinct m.manufacturers_id as id, m.manufacturers_name as name from :table_products p, :table_products_to_categories p2c, :table_manufacturers m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . $OSCOM_Category->getID( ) . "' order by m.manufacturers_name" | 1 |
|
| 'select count(*) as total from :table_categories c, :table_categories_description cd where c.parent_id = :parent_id and c.categories_id = cd.categories_id and cd.language_id = :language_id' | 1 |
|
| 'select global_product_notifications from :table_customers where customers_id =:customers_id' | 1 |
|
| 'select orders_id from :table_orders where customers_id = :customers_id order by date_purchased desc limit 1' | 1 |
|
| 'select products_id, products_name from :table_orders_products where orders_id = :orders_id order by products_name' | 1 |
|
| 'select manufacturers_id, manufacturers_name from :table_manufacturers order by manufacturers_name' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Random Product Specials Selection', 'BOX_SPECIALS_RANDOM_SELECT', '10', 'Select a random product on special from this amount of the newest products on specials available', '6', '0', now())" | 1 |
|
| 'select categories_id from :table_categories where parent_id = :parent_id limit 1' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'BOX_SPECIALS_CACHE', '1', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| 'select r.reviews_id, r.reviews_rating, p.products_id, pd.products_name, pd.products_keyword, i.image from :table_reviews r, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd where r.products_id = p.products_id and p.products_status = 1 and r.languages_id = :language_id and p.products_id = pd.products_id and pd.language_id = :language_id and r.reviews_status = 1' | 1 |
|
| 'select substring(reviews_text, 1, 60) as reviews_text from :table_reviews where reviews_id = :reviews_id and languages_id = :languages_id' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Random Review Selection', 'BOX_REVIEWS_RANDOM_SELECT', '10', 'Select a random review from this amount of the newest reviews available', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'BOX_REVIEWS_CACHE', '1', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| 'select distinct p.products_id, pd.products_name, pd.products_keyword from :table_products p, :table_products_description pd, :table_products_to_categories p2c, :table_categories c where p.products_status = 1 and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and :current_category_id in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit :max_display_bestsellers' | 1 |
|
| "select distinct c.categories_id as id, cd.categories_name as name from :table_products p, :table_products_to_categories p2c, :table_categories c, :table_categories_description cd, :table_templates_boxes tb, :table_product_attributes pa where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int) $OSCOM_Language->getID( ) . "' and tb.code = 'Manufacturers' and tb.id = pa.id and pa.products_id = p.products_id and pa.value = '" . (int) $_GET['Manufacturers'] . "' order by cd.categories_name" | 1 |
|
| 'select products_id from :table_products_to_categories where categories_id = :categories_id limit 1' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Minimum List Size', 'BOX_BEST_SELLERS_MIN_LIST', '3', 'Minimum amount of products that must be shown in the listing', '6', '0', now())" | 1 |
|
| 'update :table_customers set customers_newsletter = :customers_newsletter where customers_id = :customers_id' | 1 |
|
| 'select * from :table_orders where orders_id = :orders_id' | 1 |
|
| 'select title, text, class from :table_orders_total where orders_id = :orders_id order by sort_order' | 1 |
|
| 'select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity from :table_orders_products where orders_id = :orders_id' | 1 |
|
| 'select code from :table_modules where modules_group = "OrderTotal"' | 1 |
|
| 'select zone_name from :table_zones where zone_country_id = :zone_country_id order by zone_name' | 1 |
|
| 'select customers_id, customers_firstname, customers_lastname, customers_gender, customers_email_address, customers_password from :table_customers where customers_email_address = :customers_email_address limit 1' | 1 |
|
| 'update :table_customers set global_product_notifications = :global_product_notifications where customers_id = :customers_id' | 1 |
|
| 'select categories_id, categories_name from :table_categories_description where categories_id in (' . implode(',', $OSCOM_Category->getPathArray( )) . ') and language_id = :language_id' | 1 |
|
| 'select count(*) as total from :table_products_notifications where customers_id = :customers_id and products_id not in (' . implode(',', $products_parsed) . ')' | 1 |
|
| 'delete from :table_products_notifications where customers_id = :customers_id and products_id not in (' . implode(',', $products_parsed) . ')' | 1 |
|
| 'select count(*) as total from :table_products_notifications where customers_id = :customers_id' | 1 |
|
| 'delete from :table_products_notifications where customers_id = :customers_id' | 1 |
|
| 'select countries_id from :table_countries where countries_iso_code_2 = :countries_iso_code_2 limit 1' | 1 |
|
| 'select * from :table_zones where zone_country_id = :zone_country_id and (zone_name = :zone_name or zone_code = :zone_code) limit 1' | 1 |
|
| 'select p.products_id, pd.products_name, pd.products_keyword from :table_products p, :table_products_description pd where p.products_status = 1 and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = :language_id order by p.products_ordered desc, pd.products_name limit :max_display_bestsellers' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum List Size', 'BOX_BEST_SELLERS_MAX_LIST', '10', 'Maximum amount of products to show in the listing', '6', '0', now())" | 1 |
|
| 'select count(*) as total from :table_orders_products where orders_id = :orders_id' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'MODULE_CONTENT_NEW_PRODUCTS_CACHE', '60', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Minimum Entries To Display', 'MODULE_CONTENT_ALSO_PURCHASED_MIN_DISPLAY', '1', 'Minimum number of also purchased products to display', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum Entries To Display', 'MODULE_CONTENT_ALSO_PURCHASED_MAX_DISPLAY', '6', 'Maximum number of also purchased products to display', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'MODULE_CONTENT_ALSO_PURCHASED_PRODUCTS_CACHE', '60', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| 'select products_id from :table_products where products_status = :products_status and parent_id is null order by products_date_added desc limit :max_display_new_products' | 1 |
|
| 'select distinct p2c.products_id from :table_products p, :table_products_to_categories p2c, :table_categories c where c.parent_id = :category_parent_id and c.categories_id = p2c.categories_id and p2c.products_id = p.products_id and p.products_status = :products_status and p.parent_id is null order by p.products_date_added desc limit :max_display_new_products' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum Entries To Display', 'MODULE_CONTENT_NEW_PRODUCTS_MAX_DISPLAY', '9', 'Maximum number of new products to display', '6', '0', now())" | 1 |
|
| 'select p.products_id, pa.value as date_expected from :table_products p, :table_templates_boxes tb, :table_product_attributes pa where tb.code = :code and tb.id = pa.id and to_days(str_to_date(pa.value, "%Y-%m-%d")) >= to_days(now()) and pa.products_id = p.products_id and p.products_status = :products_status order by pa.value limit :max_display_upcoming_products' | 1 |
|
| 'insert into :table_whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values (:customer_id, :full_name, :session_id, :ip_address, :time_entry, :time_last_click, :last_page_url)' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum Entries To Display', 'MODULE_CONTENT_UPCOMING_PRODUCTS_MAX_DISPLAY', '10', 'Maximum number of upcoming products to display', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'MODULE_CONTENT_UPCOMING_PRODUCTS_CACHE', '1440', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| 'select configuration_key as cfgKey, configuration_value as cfgValue from :table_configuration' | 1 |
|
| 'select id, code, title from :table_templates' | 1 |
|
| 'select * from :table_languages order by sort_order, name' | 1 |
|
| 'select * from :table_languages_definitions where languages_id = :languages_id and content_group = :content_group' | 1 |
|
| 'select p.products_id, pd.products_name, pd.products_keyword, i.image from :table_orders_products opa, :table_orders_products opb, :table_orders o, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd where opa.products_id = :products_id and opa.orders_id = opb.orders_id and opb.products_id != :products_id and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id group by p.products_id order by o.date_purchased desc limit :limit' | 1 |
|
| 'update :table_whos_online set customer_id = :customer_id, full_name = :full_name, ip_address = :ip_address, time_last_click = :time_last_click, last_page_url = :last_page_url where session_id = :session_id' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'BOX_BEST_SELLERS_CACHE', '60', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Manufacturers List Size', 'BOX_MANUFACTURERS_LIST_SIZE', '1', 'The size of the manufacturers pull down menu listing.', '6', '0', now())" | 1 |
|
| 'select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from :table_manufacturers m left join :table_manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id), :table_products p where p.products_id = :products_id and p.manufacturers_id = m.manufacturers_id' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Show Product Count', 'BOX_CATEGORIES_SHOW_PRODUCT_COUNT', '1', 'Show the amount of products each category has', '6', '0', 'osc_cfg_use_get_boolean_value', 'osc_cfg_set_boolean_value(array(1, -1))', now())" | 1 |
|
| 'select distinct op.products_id from :table_orders o, :table_orders_products op, :table_products p where o.customers_id = :customers_id and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = 1 group by products_id order by o.date_purchased desc limit :limit' | 1 |
|
| 'select products_id, products_name, products_keyword from :table_products_description where products_id in (' . $product_ids . ') and language_id = :language_id order by products_name' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum List Size', 'BOX_ORDER_HISTORY_MAX_LIST', '5', 'Maximum amount of products to show in the listing', '6', '0', now())" | 1 |
|
| 'select manufacturers_id as id, manufacturers_name as text from :table_manufacturers order by manufacturers_name' | 1 |
|
| 'select products_id from :table_products_notifications where products_id = :products_id and customers_id = :customers_id limit 1' | 1 |
|
| 'select count(*) as count from :table_whos_online where session_id = :session_id' | 1 |
|
| 'select products_id from :table_products where products_status = :products_status order by products_date_added desc limit :max_random_select_new' | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Random New Product Selection', 'BOX_WHATS_NEW_RANDOM_SELECT', '10', 'Select a random new product from this amount of the newest products available', '6', '0', now())" | 1 |
|
| "insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'BOX_WHATS_NEW_CACHE', '1', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())" | 1 |
|
| 'select startdate, counter from :table_counter' | 1 |
|
| 'update :table_counter set counter = counter+1' | 1 |
|
| 'insert into :table_counter (startdate, counter) values (:start_date, 1)' | 1 |
|
| 'select orders_id from :table_orders where orders_id = :orders_id' | 1 |
|
| 'select count(*) as total from :table_orders where customers_id = :customers_id' | 1 |
|
| 'insert into :table_banners_history (banners_id, banners_clicked, banners_history_date) values (:banners_id, 1, now())' | 1 |
|
| 'select reviews_id from :table_reviews where' | 1 |
|
| 'select customers_gender, customers_firstname, customers_lastname, customers_email_address, customers_default_address_id from :table_customers where customers_id = :customers_id' | 1 |
|
| 'select entry_country_id, entry_zone_id from :table_address_book where address_book_id = :address_book_id and customers_id = :customers_id' | 1 |
|
| 'select products_id from :table_products_notifications where customers_id = :customers_id limit 1' | 1 |
|
| 'select pd.products_id, pd.products_name from :table_products_description pd, :table_products_notifications pn where pn.customers_id = :customers_id and pn.products_id = pd.products_id and pd.language_id = :language_id order by pd.products_name' | 1 |
|
| 'select count(*) as total from :table_orders o, :table_orders_products op, :table_products p where o.customers_id = :customers_id and o.orders_id = op.orders_id and op.products_id = p.products_id and op.products_id = :products_id' | 1 |
|
| 'select count(*) as total from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1 limit 1' | 1 |
|
| 'select products_id from :table_reviews where reviews_id = :reviews_id' | 1 |
|
| 'update :table_products_description set products_viewed = products_viewed+1 where products_id = :products_id and language_id = :language_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS reviews_id, reviews_text, reviews_rating, date_added, customers_name from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1 order by reviews_id desc limit :batch_pageset, :batch_max_results; select found_rows();' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS r.reviews_id, left(r.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name, p.products_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_keyword, i.image from :table_reviews r, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd where r.reviews_status = 1 and r.languages_id = :languages_id and r.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by r.reviews_id desc limit :batch_pageset, :batch_max_results; select found_rows();' | 1 |
|
| 'select reviews_id, reviews_text, reviews_rating, date_added, customers_name from :table_reviews where reviews_id = :reviews_id and languages_id = :languages_id and reviews_status = 1' | 1 |
|
| 'insert into :table_reviews (products_id, customers_id, customers_name, reviews_rating, languages_id, reviews_text, reviews_status, date_added) values (:products_id, :customers_id, :customers_name, :reviews_rating, :languages_id, :reviews_text, :reviews_status, now())' | 1 |
|
| 'select ab.address_book_id, ab.entry_firstname as firstname, ab.entry_lastname as lastname, ab.entry_company as company, ab.entry_street_address as street_address, ab.entry_suburb as suburb, ab.entry_city as city, ab.entry_postcode as postcode, ab.entry_state as state, ab.entry_zone_id as zone_id, ab.entry_country_id as country_id, z.zone_code as zone_code, c.countries_name as country_title from :table_address_book ab left join :table_zones z on (ab.entry_zone_id = z.zone_id), :table_countries c where ab.customers_id = :customers_id and ab.entry_country_id = c.countries_id order by ab.entry_firstname, ab.entry_lastname' | 1 |
|
| 'select entry_gender as gender, entry_company as company, entry_firstname as firstname, entry_lastname as lastname, entry_street_address as street_address, entry_suburb as suburb, entry_postcode as postcode, entry_city as city, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id, entry_telephone as telephone, entry_fax as fax from :table_address_book where address_book_id = :address_book_id and customers_id = :customers_id' | 1 |
|
| 'select manufacturers_id as id, manufacturers_name as name, manufacturers_image as image from :table_manufacturers where manufacturers_id = :manufacturers_id' | 1 |
|
| 'select p.products_id from :table_products p' | 1 |
|
| 'select count(*) as total from :table_address_book where customers_id = :customers_id' | 1 |
|
| 'select products_id as id, parent_id, products_quantity as quantity, products_price as price, products_model as model, products_tax_class_id as tax_class_id, products_types_id as type_id, products_weight as weight, products_weight_class as weight_class_id, products_date_added as date_added, manufacturers_id, has_children from :table_products where products_id = :products_id and products_status = :products_status' | 1 |
|
| 'select weight_class_title from :table_weight_classes where weight_class_id = :weight_class_id and language_id = :language_id' | 1 |
|
| 'select r.weight_class_from_id, r.weight_class_to_id, r.weight_class_rule from :table_weight_classes_rules r, :table_weight_classes c where c.weight_class_id = r.weight_class_from_id' | 1 |
|
| 'select sum(tax_rate) as tax_rate from :table_tax_rates tr left join :table_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join :table_geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = 0 or za.zone_country_id = :zone_country_id) and (za.zone_id is null or za.zone_id = 0 or za.zone_id = :zone_id) and tr.tax_class_id = :tax_class_id group by tr.tax_priority' | 1 |
|
| 'select tax_description from :table_tax_rates tr left join :table_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join :table_geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = 0 or za.zone_country_id = :zone_country_id) and (za.zone_id is null or za.zone_id = 0 or za.zone_id = :zone_id) and tr.tax_class_id = :tax_class_id group by tr.tax_priority' | 1 |
|
| 'select min(year(products_date_added)) as min_year, max(year(products_date_added)) as max_year from :table_products limit 1' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS distinct p.*, pd.*, m.*, i.image, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price' | 1 |
|
| 'select products_id, has_children from :table_products where products_id = :products_id and products_status = :products_status' | 1 |
|
| 'select avg(reviews_rating) as rating from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1' | 1 |
|
| 'select products_name as name, products_description as description, products_keyword as keyword, products_tags as tags, products_url as url from :table_products_description where products_id = :products_id and language_id = :language_id' | 1 |
|
| 'select p.products_id as id, p.parent_id, p.products_quantity as quantity, p.products_price as price, p.products_model as model, p.products_tax_class_id as tax_class_id, p.products_types_id as type_id, p.products_weight as weight, p.products_weight_class as weight_class_id, p.products_date_added as date_added, p.manufacturers_id, p.has_children, pd.products_name as name, pd.products_description as description, pd.products_keyword as keyword, pd.products_tags as tags, pd.products_url as url from :table_products p, :table_products_description pd where pd.products_keyword = :products_keyword and pd.language_id = :language_id and pd.products_id = p.products_id and p.products_status = :products_status' | 1 |
|
| 'select categories_id from :table_products_to_categories where products_id = :products_id limit 1' | 1 |
|
| 'select action, module from :table_product_types_assignments where types_id = :types_id order by action, sort_order, module' | 1 |
|
| 'select pv.default_combo, pvg.id as group_id, pvg.title as group_title, pvg.module, pvv.id as value_id, pvv.title as value_title, pvv.sort_order as value_sort_order from :table_products_variants pv, :table_products_variants_groups pvg, :table_products_variants_values pvv where pv.products_id = :products_id and pv.products_variants_values_id = pvv.id and pvv.languages_id = :languages_id_pvv and pvv.products_variants_groups_id = pvg.id and pvg.languages_id = :languages_id_pvg order by pvg.sort_order, pvg.title' | 1 |
|
| 'select tb.code, pa.value from :table_product_attributes pa, :table_templates_boxes tb where pa.products_id = :products_id and pa.languages_id in (0, :languages_id) and pa.id = tb.id' | 1 |
|
| 'select address_book_id from :table_address_book where address_book_id = :address_book_id and customers_id = :customers_id' | 1 |
|
| 'update :table_address_book set customers_id = :customers_id, entry_gender = :entry_gender, entry_company = :entry_company, entry_firstname = :entry_firstname, entry_lastname = :entry_lastname, entry_street_address = :entry_street_address, entry_suburb = :entry_suburb, entry_postcode = :entry_postcode, entry_city = :entry_city, entry_state = :entry_state, entry_country_id = :entry_country_id, entry_zone_id = :entry_zone_id, entry_telephone = :entry_telephone, entry_fax = :entry_fax where address_book_id = :address_book_id and customers_id = :customers_id' | 1 |
|
| 'select customers_id from :table_orders where orders_id = :orders_id' | 1 |
|
| 'update :table_products set products_status = 0 where products_id = :products_id' | 1 |
|
| 'insert into :table_orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_state_code, customers_country, customers_country_iso2, customers_country_iso3, customers_telephone, customers_email_address, customers_address_format, customers_ip_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_state_code, delivery_country, delivery_country_iso2, delivery_country_iso3, delivery_address_format, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_state_code, billing_country, billing_country_iso2, billing_country_iso3, billing_address_format, payment_method, payment_module, date_purchased, orders_status, currency, currency_value) values (:customers_id, :customers_name, :customers_company, :customers_street_address, :customers_suburb, :customers_city, :customers_postcode, :customers_state, :customers_state_code, :customers_country, :customers_country_iso2, :customers_country_iso3, :customers_telephone, :customers_email_address, :customers_address_format, :customers_ip_address, :delivery_name, :delivery_company, :delivery_street_address, :delivery_suburb, :delivery_city, :delivery_postcode, :delivery_state, :delivery_state_code, :delivery_country, :delivery_country_iso2, :delivery_country_iso3, :delivery_address_format, :billing_name, :billing_company, :billing_street_address, :billing_suburb, :billing_city, :billing_postcode, :billing_state, :billing_state_code, :billing_country, :billing_country_iso2, :billing_country_iso3, :billing_address_format, :payment_method, :payment_module, now(), :orders_status, :currency, :currency_value)' | 1 |
|
| 'insert into :table_orders_total (orders_id, title, text, value, class, sort_order) values (:orders_id, :title, :text, :value, :class, :sort_order)' | 1 |
|
| 'insert into :table_orders_products (orders_id, products_id, products_model, products_name, products_price, products_tax, products_quantity) values (:orders_id, :products_id, :products_model, :products_name, :products_price, :products_tax, :products_quantity)' | 1 |
|
| 'insert into :table_orders_products_variants (orders_id, orders_products_id, group_title, value_title) values (:orders_id, :orders_products_id, :group_title, :value_title)' | 1 |
|
| 'update :table_orders set orders_status = :orders_status where orders_id = :orders_id' | 1 |
|
| 'update :table_products set products_quantity = :products_quantity where products_id = :products_id' | 1 |
|
| 'update :table_products set products_ordered = products_ordered + :products_ordered where products_id = :products_id' | 1 |
|
| 'select code from :table_modules where modules_group = "Shipping"' | 1 |
|
| 'select * from :table_orders where orders_id = :orders_id limit 1' | 1 |
|
| 'select orders_products_id, products_model, products_name, products_price, products_tax, products_quantity from :table_orders_products where orders_id = :orders_id order by orders_products_id' | 1 |
|
| 'select title, text from :table_orders_total where orders_id = :orders_id order by sort_order' | 1 |
|
| 'select date_added, comments from :table_orders_status_history where orders_id = :orders_id and comments != "" order by orders_status_history_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from :table_orders o, :table_orders_total ot, :table_orders_status s where o.customers_id = :customers_id and o.orders_id = ot.orders_id and ot.class = "total" and o.orders_status = s.orders_status_id and s.language_id = :language_id order by orders_id desc' | 1 |
|
| 'select os.orders_status_name, osh.date_added, osh.comments from :table_orders_status os, :table_orders_status_history osh where osh.orders_id = :orders_id and osh.orders_status_id = os.orders_status_id and os.language_id = :language_id order by osh.date_added' | 1 |
|
| 'select p2c.categories_id, count(*) as total from :table_products p, :table_products_to_categories p2c where p2c.products_id = p.products_id' | 1 |
|
| 'update :table_specials set status = :status, date_status_change = now() where specials_id = :specials_id' | 1 |
|
| 'select * from :table_products_images_groups where language_id = :language_id' | 1 |
|
| 'delete from :table_shopping_carts where customers_id = :customers_id and item_id in ("' . implode('", "', $_delete_array) . '")' | 1 |
|
| 'select item_id, quantity from :table_shopping_carts where customers_id = :customers_id and products_id = :products_id' | 1 |
|
| 'select sc.item_id, sc.products_id, sc.quantity, sc.date_added, p.parent_id, p.products_price, p.products_model, p.products_tax_class_id, p.products_weight, p.products_weight_class, p.products_status from :table_shopping_carts sc, :table_products p where sc.customers_id = :customers_id and sc.products_id = p.products_id order by sc.date_added desc' | 1 |
|
| 'select products_name, products_keyword from :table_products_description where products_id = :products_id and language_id = :language_id' | 1 |
|
| 'select image from :table_products_images where products_id = :products_id and default_flag = :default_flag' | 1 |
|
| 'select products_status from :table_products where products_id = :products_id' | 1 |
|
| 'select products_variants_values_text from :table_shopping_carts_custom_variants_values where customers_id = :customers_id and shopping_carts_item_id = :shopping_carts_item_id and products_id = :products_id and products_variants_values_id = :products_variants_values_id' | 1 |
|
| 'delete from :table_shopping_carts_custom_variants_values where customers_id = :customers_id and shopping_carts_item_id in ("' . implode('", "', $_delete_array) . '")' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS p.products_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_keyword, s.specials_new_products_price, i.image from :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd, :table_specials s where p.products_status = 1 and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = :language_id and s.status = 1 order by s.specials_date_added desc limit :batch_pageset, :batch_max_results; select found_rows();' | 1 |
|
| 'delete from :table_shopping_carts where customers_id = :customers_id' | 1 |
|
| 'delete from :table_shopping_carts_custom_variants_values where customers_id = :customers_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS distinct p.products_id from :table_products p left join :table_product_attributes pa on (p.products_id = pa.products_id) left join :table_templates_boxes tb on (pa.id = tb.id and tb.code = "Manufacturers"), :table_products_description pd, :table_categories c, :table_products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id' | 1 |
|
| 'select specials_id from :table_specials where status = 0 and now() >= start_date and start_date > 0 and now() < expires_date' | 1 |
|
| 'select specials_id from :table_specials where status = 1 and now() >= expires_date and expires_date > 0' | 1 |
|
| 'select specials_new_products_price from :table_specials where products_id = :products_id and status = 1' | 1 |
|
| 'select weight_class_to_id from :table_weight_classes_rules where weight_class_from_id = :weight_class_from_id and weight_class_to_id != :weight_class_to_id' | 1 |
|
| 'select languages_id, title from :table_products_variants_groups where id = :id' | 1 |
|
| 'update :table_weight_classes set weight_class_key = :weight_class_key, weight_class_title = :weight_class_title where weight_class_id = :weight_class_id and language_id = :language_id' | 1 |
|
| 'select id from :table_product_attributes where products_id = :products_id and id = :id limit 1' | 1 |
|
| 'select count(*) as total from :table_products_to_categories where products_id = :products_id and categories_id = :categories_id' | 1 |
|
| 'update :table_products_variants set default_combo = :default_combo where products_id = :products_id' | 1 |
|
| 'update :table_products_variants set default_combo = :default_combo where products_id in (":products_id")' | 1 |
|
| 'update :table_products set has_children = :has_children where products_id = :products_id' | 1 |
|
| 'delete from :table_products_variants where products_id = :products_id and products_variants_values_id not in (":products_variants_values_id")' | 1 |
|
| 'delete from :table_products_variants where products_id = :products_id and products_variants_values_id = :products_variants_values_id' | 1 |
|
| 'select pv.* from :table_products p, :table_products_variants pv where p.parent_id = :parent_id and p.products_id = pv.products_id and pv.products_id not in (":products_id")' | 1 |
|
| 'delete from :table_products_variants where products_id = :products_id' | 1 |
|
| 'select pv.* from :table_products p, :table_products_variants pv where p.parent_id = :parent_id and p.products_id = pv.products_id' | 1 |
|
| 'insert into :table_products_variants (products_id, products_variants_values_id) values (:products_id, :products_variants_values_id)' | 1 |
|
| 'select products_id from :table_products_variants where products_id = :products_id and products_variants_values_id = :products_variants_values_id' | 1 |
|
| 'insert into :table_products (parent_id, products_quantity, products_price, products_model, products_weight, products_weight_class, products_status, products_tax_class_id, products_date_added) values (:parent_id, :products_quantity, :products_price, :products_model, :products_weight, :products_weight_class, :products_status, :products_tax_class_id, :products_date_added)' | 1 |
|
| 'update :table_products set products_quantity = :products_quantity, products_price = :products_price, products_model = :products_model, products_weight = :products_weight, products_weight_class = :products_weight_class, products_status = :products_status, products_tax_class_id = :products_tax_class_id where products_id = :products_id' | 1 |
|
| 'update :table_product_attributes set value = :value where products_id = :products_id and id = :id' | 1 |
|
| 'update :table_products_description set products_name = :products_name, products_description = :products_description, products_keyword = :products_keyword, products_tags = :products_tags, products_url = :products_url where products_id = :products_id and language_id = :language_id' | 1 |
|
| 'insert into :table_products (products_quantity, products_price, products_model, products_date_added, products_weight, products_weight_class, products_status, products_tax_class_id, manufacturers_id) values (:products_quantity, :products_price, :products_model, now(), :products_weight, :products_weight_class, 0, :products_tax_class_id, :manufacturers_id)' | 1 |
|
| 'delete from :table_products_to_categories where products_id = :products_id' | 1 |
|
| 'insert into :table_products (products_quantity, products_price, products_model, products_weight, products_weight_class, products_status, products_tax_class_id, products_date_added) values (:products_quantity, :products_price, :products_model, :products_weight, :products_weight_class, :products_status, :products_tax_class_id, :products_date_added)' | 1 |
|
| 'update :table_products set products_quantity = :products_quantity, products_price = :products_price, products_model = :products_model, products_weight = :products_weight, products_weight_class = :products_weight_class, products_status = :products_status, products_tax_class_id = :products_tax_class_id, products_last_modified = now() where products_id = :products_id' | 1 |
|
| 'select id, value from :table_product_attributes where products_id = :products_id and languages_id in (0, :languages_id)' | 1 |
|
| 'select pv.default_combo, pvg.id as group_id, pvg.title as group_title, pvg.module, pvv.id as value_id, pvv.title as value_title, pvv.sort_order as value_sort_order from :table_products_variants pv, :table_products_variants_groups pvg, :table_products_variants_values pvv where pv.products_id = :products_id and pv.products_variants_values_id = pvv.id and pvv.languages_id = :languages_id and pvv.products_variants_groups_id = pvg.id and pvg.languages_id = :languages_id order by pvg.sort_order, pvg.title' | 1 |
|
| 'select p.*, pd.* from :table_products p, :table_products_description pd where p.products_id = :products_id and p.products_id = pd.products_id and pd.language_id = :language_id' | 1 |
|
| 'select products_name, products_description, products_url, language_id from :table_products_description where products_id = :products_id' | 1 |
|
| 'select p.products_id, p.products_quantity, p.products_price, p.products_model, p.products_weight, p.products_weight_class, p.products_date_added, p.products_last_modified, p.products_status, p.products_tax_class_id, p.manufacturers_id, i.image from :table_products p left join :table_products_images i on (p.products_id = i.products_id and default_flag = :default_flag) where p.products_id = :products_id' | 1 |
|
| 'select pv.default_combo, pvg.id as group_id, pvg.title as group_title, pvv.id as value_id, pvv.title as value_title from :table_products_variants pv, :table_products_variants_groups pvg, :table_products_variants_values pvv where pv.products_id = :products_id and pv.products_variants_values_id = pvv.id and pvv.languages_id = :languages_id and pvv.products_variants_groups_id = pvg.id and pvg.languages_id = :languages_id order by pvg.sort_order, pvg.title' | 1 |
|
| 'select * from :table_products where parent_id = :parent_id' | 1 |
|
| 'select id, title from :table_products_variants_values where products_variants_groups_id = :products_variants_groups_id and languages_id = :languages_id order by sort_order, title' | 1 |
|
| 'select id, code from :table_templates_boxes where modules_group = :modules_group order by code' | 1 |
|
| 'select id, title from :table_products_variants_values where languages_id = :languages_id order by sort_order, title' | 1 |
|
| 'select weight_class_id, weight_class_title from :table_weight_class where language_id = :language_id order by weight_class_title' | 1 |
|
| 'select * from :table_products where products_id = :products_id' | 1 |
|
| 'select * from :table_products_description where products_id = :products_id' | 1 |
|
| 'select * from :table_configuration where configuration_group_id = :configuration_group_id and (configuration_key like :configuration_key or configuration_value like :configuration_value) order by sort_order, configuration_title' | 1 |
|
| 'delete from :table_banners where banners_id = :banners_id' | 1 |
|
| 'update :table_reviews set reviews_text = :reviews_text, reviews_rating = :reviews_rating, last_modified = now() where reviews_id = :reviews_id' | 1 |
|
| 'select (avg(reviews_rating) / 5 * 100) as average_rating from :table_reviews where products_id = :products_id' | 1 |
|
| 'select r.*, pd.products_name from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id) where r.reviews_id = :reviews_id' | 1 |
|
| 'select r.reviews_id, pd.products_name from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id) where r.reviews_id in (":reviews_id") order by pd.products_name' | 1 |
|
| 'select r.reviews_id, r.products_id, r.date_added, r.last_modified, r.reviews_rating, r.reviews_status, pd.products_name, l.code as languages_code from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by r.date_added desc' | 1 |
|
| 'update :table_reviews set reviews_status = 2 where reviews_id = :reviews_id' | 1 |
|
| 'update :table_reviews set reviews_status = 1 where reviews_id = :reviews_id' | 1 |
|
| 'update :table_credit_cards set credit_card_status = :credit_card_status where id = :id' | 1 |
|
| 'insert into :table_credit_cards (credit_card_name, pattern, credit_card_status, sort_order) values (:credit_card_name, :pattern, :credit_card_status, :sort_order)' | 1 |
|
| 'update :table_credit_cards set credit_card_name = :credit_card_name, pattern = :pattern, credit_card_status = :credit_card_status, sort_order = :sort_order where id = :id' | 1 |
|
| 'select * from :table_credit_cards where id = :id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_credit_cards order by sort_order, credit_card_name' | 1 |
|
| 'delete from :table_credit_cards where id = :id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_credit_cards where (credit_card_name like :credit_card_name) order by credit_card_name' | 1 |
|
| 'select banners_image from :table_banners where banners_id = :banners_id' | 1 |
|
| 'insert into :table_products_description (products_id, language_id, products_name, products_description, products_tags, products_url, products_viewed) values (:products_id, :language_id, :products_name, :products_description, :products_tags, :products_url, 0)' | 1 |
|
| 'insert into :table_banners (banners_title, banners_url, banners_image, banners_group, banners_html_text, expires_date, expires_impressions, date_scheduled, status, date_added) values (:banners_title, :banners_url, :banners_image, :banners_group, :banners_html_text, :expires_date, :expires_impressions, :date_scheduled, :status, now())' | 1 |
|
| 'update :table_banners set banners_title = :banners_title, banners_url = :banners_url, banners_image = :banners_image, banners_group = :banners_group, banners_html_text = :banners_html_text, expires_date = :expires_date, expires_impressions = :expires_impressions, date_scheduled = :date_scheduled, status = :status where banners_id = :banners_id' | 1 |
|
| 'select * from :table_banners where banners_id = :banners_id' | 1 |
|
| 'select banners_id, banners_title from :table_banners where banners_id in (":banners_id") order by banners_title' | 1 |
|
| 'select distinct year(banners_history_date) as banner_year from :table_banners_history where banners_id = :banners_id' | 1 |
|
| 'select max(weight_class_id) as weight_class_id from :table_weight_classes' | 1 |
|
| 'select banners_id, banners_title, banners_group, status from :table_banners order by banners_title, banners_group' | 1 |
|
| 'select now() as datetime' | 1 |
|
| 'select version() as version' | 1 |
|
| 'show status like "Uptime"' | 1 |
|
| 'select count(*) as total from :table_products_description where products_keyword = :products_keyword' | 1 |
|
| 'update :table_product_attributes set value = :value where id = :id and products_id = :products_id' | 1 |
|
| 'select pa.id from :table_product_attributes pa, :table_templates_boxes tb where tb.code = :code and tb.modules_group = :modules_group and tb.id = pa.id and products_id = :products_id' | 1 |
|
| 'select id from :table_products_images where products_id = :products_id' | 1 |
|
| 'select products_name, products_description, products_keyword, products_tags, products_url, language_id from :table_products_description where products_id = :products_id' | 1 |
|
| 'select * from :table_configuration where configuration_id = :configuration_id' | 1 |
|
| 'update :table_address_book set entry_gender = :entry_gender, entry_company = :entry_company, entry_firstname = :entry_firstname, entry_lastname = :entry_lastname, entry_street_address = :entry_street_address, entry_suburb = :entry_suburb, entry_postcode = :entry_postcode, entry_city = :entry_city, entry_state = :entry_state, entry_country_id = :entry_country_id, entry_zone_id = :entry_zone_id, entry_telephone = :entry_telephone, entry_fax = :entry_fax where address_book_id = :address_book_id and customers_id = :customers_id' | 1 |
|
| 'update ' . $db_table_prefix . $fk['from_table'] . ' set ' . $fk['from_field'] . ' = :' . $fk['from_field'] . ' where ' . $fk['from_field'] . ' = :' . $fk['from_field'] . '_orig' | 1 |
|
| 'insert into :table_tax_class (tax_class_title, tax_class_description, date_added) values (:tax_class_title, :tax_class_description, now())' | 1 |
|
| 'update :table_tax_class set tax_class_title = :tax_class_title, tax_class_description = :tax_class_description, last_modified = now() where tax_class_id = :tax_class_id' | 1 |
|
| 'select tr.*, tc.tax_class_title, z.geo_zone_id, z.geo_zone_name from :table_tax_rates tr, :table_tax_class tc, :table_geo_zones z where tr.tax_rates_id = :tax_rates_id and tr.tax_class_id = tc.tax_class_id and tr.tax_zone_id = z.geo_zone_id' | 1 |
|
| 'select tr.*, z.geo_zone_id, z.geo_zone_name from :table_tax_rates tr, :table_geo_zones z where tr.tax_class_id = :tax_class_id and tr.tax_zone_id = z.geo_zone_id order by tr.tax_priority, z.geo_zone_name' | 1 |
|
| 'select tc.*, count(tr.tax_rates_id) as total_tax_rates from :table_tax_class tc left join :table_tax_rates tr on (tc.tax_class_id = tr.tax_class_id) where tc.tax_class_id = :tax_class_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS tc.*, count(tr.tax_rates_id) as total_tax_rates from :table_tax_class tc left join :table_tax_rates tr on (tc.tax_class_id = tr.tax_class_id) group by tc.tax_class_id order by tc.tax_class_title' | 1 |
|
| 'delete from :table_tax_rates where tax_rates_id = :tax_rates_id' | 1 |
|
| 'delete from :table_tax_class where tax_class_id = :tax_class_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS tc.*, count(tr.tax_rates_id) as total_tax_rates from :table_tax_class tc left join :table_tax_rates tr on (tc.tax_class_id = tr.tax_class_id) where (tc.tax_class_title like :tax_class_title or tr.tax_description like :tax_description) group by tc.tax_class_id order by tc.tax_class_title' | 1 |
|
| 'select tax_rates_id, tax_description from :table_tax_rates where tax_rates_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by tax_description' | 1 |
|
| 'select tax_class_id, tax_class_title from :table_tax_class where tax_class_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by tax_class_title' | 1 |
|
| 'select 1 from :table_sessions where id = :id' | 1 |
|
| 'delete from :table_sessions where id = :id' | 1 |
|
| 'delete from :table_sessions where expiry < :expiry' | 1 |
|
| 'select * from ' . $query_data[1] . substr($this->queryString, strrpos($this->queryString, ' where ')) | 1 |
|
| 'update :table_tax_rates set tax_zone_id = :tax_zone_id, tax_priority = :tax_priority, tax_rate = :tax_rate, tax_description = :tax_description, last_modified = now() where tax_rates_id = :tax_rates_id' | 1 |
|
| 'update ' . $db_table_prefix . $fk['from_table'] . ' set ' . $fk['from_field'] . ' = null where ' . $fk['from_field'] . ' = :' . $fk['from_field'] | 1 |
|
| 'delete from ' . $db_table_prefix . $fk['from_table'] . ' where ' . $fk['from_field'] . ' = :' . $fk['from_field'] | 1 |
|
| 'select * from ' . $query_data[2] . ' ' . $query_data[3] | 1 |
|
| 'select * from :table_fk_relationships' | 1 |
|
| 'select id, credit_card_name as title, pattern from :table_credit_cards where credit_card_status = 1 order by sort_order, credit_card_name' | 1 |
|
| 'INSERT INTO ' . $table_prefix . substr($sql_query, 16) | 1 |
|
| 'INSERT INTO OSC_' | 1 |
|
| 'select count(*) as total from error_log where message like :message' | 1 |
|
| 'select timestamp, message from error_log where message like :message order by rowid desc' | 1 |
|
| 'select count(*) as total from error_log' | 1 |
|
| 'select timestamp, message from error_log order by rowid desc' | 1 |
|
| 'delete from :table_configuration where configuration_key in ("' . implode('", "', $this->getKeys( )) . '")' | 1 |
|
| 'update :table_languages_definitions set definition_value = :definition_value where definition_key = :definition_key and content_group = :content_group and languages_id = :languages_id' | 1 |
|
| 'select id from :table_languages_definitions where definition_key = :definition_key and content_group = :content_group and languages_id = :languages_id limit 1' | 1 |
|
| 'select count(*) as total from :table_products where products_tax_class_id = :products_tax_class_id' | 1 |
|
| 'insert into :table_tax_rates (tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, date_added) values (:tax_zone_id, :tax_class_id, :tax_priority, :tax_rate, :tax_description, now())' | 1 |
|
| 'select * from :table_configuration where configuration_key = :configuration_key' | 1 |
|
| 'insert into :table_administrators_access (administrators_id, module) values (:administrators_id, :module)' | 1 |
|
| 'select * from :table_configuration where configuration_group_id = :configuration_group_id order by sort_order, configuration_title' | 1 |
|
| 'select cg.*, count(c.configuration_id) as total_entries from :table_configuration_group cg left join :table_configuration c on (cg.configuration_group_id = c.configuration_group_id) where cg.configuration_group_id = :configuration_group_id' | 1 |
|
| 'select cg.configuration_group_id, cg.configuration_group_title, count(c.configuration_id) as total_entries from :table_configuration_group cg, :table_configuration c where cg.visible = 1 and cg.configuration_group_id = c.configuration_group_id group by cg.configuration_group_id order by cg.sort_order, cg.configuration_group_title' | 1 |
|
| 'select distinct cg.configuration_group_id, cg.configuration_group_title, count(c.configuration_id) as total_entries from :table_configuration_group cg, :table_configuration c where (c.configuration_key like :configuration_key or c.configuration_value like :configuration_value) and c.configuration_group_id = cg.configuration_group_id and cg.visible = 1 group by cg.configuration_group_id order by cg.sort_order, cg.configuration_group_title' | 1 |
|
| 'select configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_id in (' . implode(',', array_unique(array_filter($_POST['batch'], 'is_numeric'))) . ')' | 1 |
|
| 'delete from :table_administrators_log where id = :id' | 1 |
|
| 'insert into :table_administrators_log (id, module, module_action, module_id, field_key, old_value, new_value, action, administrators_id, datestamp) values (:id, :module, :module_action, :module_id, :field_key, :old_value, :new_value, :action, :administrators_id, now())' | 1 |
|
| 'select max(id) as id from :table_administrators_log' | 1 |
|
| 'select al.id, al.module, al.module_action, al.module_id, al.action, a.user_name, unix_timestamp(al.datestamp) as datestamp from :table_administrators_log al, :table_administrators a where al.id = :id and al.administrators_id = a.id limit 1' | 1 |
|
| 'select al.id, al.module, al.module_action, al.module_id, a.user_name from :table_administrators_log al, :table_administrators a where al.id in (":id") and al.administrators_id = a.id group by id order by id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS count(al.id) as total, al.id, al.module, al.module_action, al.module_id, al.action, a.user_name, unix_timestamp(al.datestamp) as datestamp from :table_administrators_log al, :table_administrators a where' | 1 |
|
| 'select id, user_name from :table_administrators order by user_name' | 1 |
|
| 'select action, field_key, old_value, new_value from :table_administrators_log where id = :id' | 1 |
|
| 'delete from :table_administrators_access where administrators_id = :administrators_id' | 1 |
|
| 'select administrators_id from :table_administrators_access where administrators_id = :administrators_id and module = :module limit 1' | 1 |
|
| 'select tr.*, z.geo_zone_id, z.geo_zone_name from :table_tax_rates tr, :table_geo_zones z where tr.tax_class_id = :tax_class_id and tr.tax_zone_id = z.geo_zone_id and (tr.tax_description like :tax_description) order by tr.tax_priority, z.geo_zone_name' | 1 |
|
| 'update :table_orders_status set orders_status_name = :orders_status_name where orders_status_id = :orders_status_id and language_id = :language_id' | 1 |
|
| 'select language_id, orders_status_name from :table_orders_status where orders_status_id = :orders_status_id' | 1 |
|
| 'select orders_status_id, orders_status_name from :table_orders_status where orders_status_id in (":orders_status_id") and language_id = :language_id order by orders_status_name' | 1 |
|
| 'select count(*) as total from :table_orders where orders_status = :orders_status' | 1 |
|
| 'select count(*) as total from :table_orders_status_history where orders_status_id = :orders_status_id group by orders_id' | 1 |
|
| 'select * from :table_orders_status where orders_status_id = :orders_status_id and language_id = :language_id' | 1 |
|
| 'select max(orders_status_id) as orders_status_id from :table_orders_status' | 1 |
|
| 'delete from :table_orders_status where orders_status_id = :orders_status_id' | 1 |
|
| 'insert into :table_administrators (user_name, user_password) values (:user_name, :user_password)' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_administrators where (user_name like :user_name) order by user_name' | 1 |
|
| 'delete from :table_administrators where id = :id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS * from :table_administrators order by user_name' | 1 |
|
| 'select * from :table_administrators where id = :id' | 1 |
|
| 'select id from :table_administrators where user_name = :user_name' | 1 |
|
| 'update :table_administrators set user_name = :user_name' | 1 |
|
| 'delete from :table_reviews where reviews_id = :reviews_id' | 1 |
|
| 'select sum(banners_shown) as banners_shown, sum(banners_clicked) as banners_clicked from :table_banners_history where banners_id = :banners_id' | 1 |
|
| 'select module from :table_administrator_shortcuts where administrators_id = :administrators_id' | 1 |
|
| 'update :table_templates_boxes_to_pages set content_page = :content_page, boxes_group = :boxes_group, sort_order = :sort_order, page_specific = :page_specific where id = :id' | 1 |
|
| 'delete from :table_administrator_shortcuts where administrators_id = :administrators_id and module = :module' | 1 |
|
| 'update :table_administrator_shortcuts set last_viewed = now() where administrators_id = :administrators_id and module = :module' | 1 |
|
| 'select module, last_viewed from :table_administrator_shortcuts where administrators_id = :administrators_id' | 1 |
|
| 'select code from :table_modules where modules_group = :modules_group order by code' | 1 |
|
| 'select distinct content_group, count(*) as total_entries from :table_languages_definitions where languages_id = :languages_id group by content_group order by content_group' | 1 |
|
| 'select languages_id, count(*) as total_entries from :table_languages_definitions where content_group = :content_group group by languages_id' | 1 |
|
| 'select * from :table_languages_definitions where id = :id' | 1 |
|
| 'select zone_name, zone_id from :table_zones where zone_country_id = :zone_country_id order by zone_name' | 1 |
|
| 'select distinct zone_country_id from :table_zones order by zone_country_id' | 1 |
|
| 'select * from :table_languages_definitions where languages_id = :languages_id and content_group = :content_group and (definition_key like :definition_key or definition_value like :definition_value) order by definition_key' | 1 |
|
| 'insert into :table_templates_boxes_to_pages (templates_boxes_id, templates_id, content_page, boxes_group, sort_order, page_specific) values (:templates_boxes_id, :templates_id, :content_page, :boxes_group, :sort_order, :page_specific)' | 1 |
|
| 'select distinct content_group, count(*) as total_entries from :table_languages_definitions where languages_id = :languages_id and (definition_key like :definition_key or definition_value like :definition_value) group by content_group order by content_group' | 1 |
|
| 'select z2gz.*, c.countries_name, z.zone_name from :table_zones_to_geo_zones z2gz, :table_countries c, :table_zones z where z2gz.geo_zone_id = :geo_zone_id and z2gz.zone_country_id = c.countries_id and z2gz.zone_id = z.zone_id and (c.countries_name like :countries_name or z.zone_name like :zone_name) order by c.countries_name, z.zone_name' | 1 |
|
| 'delete from :table_templates_boxes_to_pages where id = :id' | 1 |
|
| 'select b2p.*, b.title as box_title, b.code as box_code from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.id = :id and b2p.templates_boxes_id = b.id' | 1 |
|
| 'insert into :table_zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id, date_added) values (:zone_country_id, :zone_id, :geo_zone_id, now())' | 1 |
|
| 'update :table_zones_to_geo_zones set zone_country_id = :zone_country_id, zone_id = :zone_id, last_modified = now() where association_id = :association_id' | 1 |
|
| 'select id, title, code from :table_templates order by title' | 1 |
|
| 'select b2p.*, b.title as box_title from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.templates_id = :templates_id and b2p.templates_boxes_id = b.id and b.modules_group = :modules_group order by b2p.page_specific desc, b2p.boxes_group, b2p.sort_order, b.title' | 1 |
|
| 'insert into :table_geo_zones (geo_zone_name, geo_zone_description, date_added) values (:geo_zone_name, :geo_zone_description, now())' | 1 |
|
| 'update :table_geo_zones set geo_zone_name = :geo_zone_name, geo_zone_description = :geo_zone_description, last_modified = now() where geo_zone_id = :geo_zone_id' | 1 |
|
| 'select z2gz.*, c.countries_name, z.zone_name from :table_zones_to_geo_zones z2gz left join :table_countries c on (z2gz.zone_country_id = c.countries_id) left join :table_zones z on (z2gz.zone_id = z.zone_id) where z2gz.association_id = :association_id' | 1 |
|
| 'select b2p.*, b.title as box_title from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.id = :id and b2p.templates_boxes_id = b.id' | 1 |
|
| 'insert into :table_administrator_shortcuts (administrators_id, module, last_viewed) values (:administrators_id, :module, null)' | 1 |
|
| 'select languages_id, name, code from :table_languages where languages_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by name' | 1 |
|
| 'select gz.*, count(z2gz.association_id) as total_entries from :table_geo_zones gz left join :table_zones_to_geo_zones z2gz on (gz.geo_zone_id = z2gz.geo_zone_id) where gz.geo_zone_id = :geo_zone_id' | 1 |
|
| 'delete from :table_languages_definitions where content_group = :content_group' | 1 |
|
| 'select id, title, sort_order, module from :table_products_variants_groups where languages_id = :languages_id' | 1 |
|
| 'select id, products_id, value from :table_product_attributes where languages_id = :languages_id' | 1 |
|
| 'select products_id, products_name, products_description, products_keyword, products_tags, products_url from :table_products_description where language_id = :language_id' | 1 |
|
| 'select categories_id, categories_name from :table_categories_description where language_id = :language_id' | 1 |
|
| 'select manufacturers_id, manufacturers_url from :table_manufacturers_info where languages_id = :languages_id' | 1 |
|
| 'update :table_languages_definitions set content_group = :content_group, definition_key = :definition_key, definition_value = :definition_value where definition_key = :definition_key and languages_id = :languages_id and content_group = :content_group' | 1 |
|
| 'select definition_key, content_group from :table_languages_definitions where definition_key = :definition_key and languages_id = :languages_id and content_group = :content_group' | 1 |
|
| 'delete from :table_languages_definitions where languages_id = :languages_id' | 1 |
|
| 'insert into :table_languages (name, code, locale, charset, date_format_short, date_format_long, time_format, text_direction, currencies_id, numeric_separator_decimal, numeric_separator_thousands, parent_id) values (:name, :code, :locale, :charset, :date_format_short, :date_format_long, :time_format, :text_direction, :currencies_id, :numeric_separator_decimal, :numeric_separator_thousands, :parent_id)' | 1 |
|
| 'update :table_languages set name = :name, code = :code, locale = :locale, charset = :charset, date_format_short = :date_format_short, date_format_long = :date_format_long, time_format = :time_format, text_direction = :text_direction, currencies_id = :currencies_id, numeric_separator_decimal = :numeric_separator_decimal, numeric_separator_thousands = :numeric_separator_thousands, parent_id = :parent_id where languages_id = :languages_id' | 1 |
|
| 'select l.*, count(ld.languages_id) as total_definitions from :table_languages l left join :table_languages_definitions ld on (l.languages_id = ld.languages_id) where' | 1 |
|
| 'select id, status_name from :table_orders_transactions_status where language_id = :language_id' | 1 |
|
| 'select id, title, code, size_width, size_height, force_size from :table_products_images_groups where language_id = :language_id' | 1 |
|
| 'insert into :table_orders_transactions_status (id, language_id, status_name) values (:id, :language_id, :status_name)' | 1 |
|
| 'select id, title, css_key from :table_shipping_availability where languages_id = :languages_id' | 1 |
|
| 'insert into :table_shipping_availability (id, languages_id, title, css_key) values (:id, :languages_id, :title, :css_key)' | 1 |
|
| 'update :table_languages_definitions set definition_value = :definition_value where definition_key = :definition_key and languages_id = :languages_id and content_group = :content_group' | 1 |
|
| 'update :table_languages set name = :name, code = :code, locale = :locale, charset = :charset, date_format_short = :date_format_short, date_format_long = :date_format_long, time_format = :time_format, text_direction = :text_direction, currencies_id = :currencies_id, numeric_separator_decimal = :numeric_separator_decimal, numeric_separator_thousands = :numeric_separator_thousands, parent_id = :parent_id, sort_order = :sort_order where languages_id = :languages_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS l.*, count(ld.id) as total_definitions from :table_languages l left join :table_languages_definitions ld on (l.languages_id = ld.languages_id) group by l.languages_id order by l.sort_order, l.name' | 1 |
|
| 'delete from :table_languages where languages_id = :languages_id' | 1 |
|
| 'delete from :table_languages_definitions where id = :id' | 1 |
|
| 'insert into :table_weight_classes (weight_class_id, weight_class_key, language_id, weight_class_title) values (:weight_class_id, :weight_class_key, :language_id, :weight_class_title)' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS l.*, count(ld.id) as total_definitions from :table_languages l left join :table_languages_definitions ld on (l.languages_id = ld.languages_id) where (l.name like :name or l.code like :code or ld.definition_key like :definition_key or ld.definition_value like :definition_value) group by l.languages_id order by l.name' | 1 |
|
| 'select * from :table_languages_definitions where languages_id = :languages_id and' | 1 |
|
| 'select z2gz.*, c.countries_name, z.zone_name from :table_zones_to_geo_zones z2gz left join :table_countries c on (z2gz.zone_country_id = c.countries_id) left join :table_zones z on (z2gz.zone_id = z.zone_id) where z2gz.geo_zone_id = :geo_zone_id order by c.countries_name, z.zone_name' | 1 |
|
| 'select b2p.*, b.title as box_title from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.id in (":id") and b2p.templates_boxes_id = b.id order by b.title' | 1 |
|
| 'select id, products_variants_groups_id, title, sort_order from :table_products_variants_values where languages_id = :languages_id' | 1 |
|
| 'update :table_categories_description set categories_name = :categories_name where categories_id = :categories_id and language_id = :language_id' | 1 |
|
| 'select s.specials_id, pd.products_name from :table_specials s, :table_products_description pd where s.specials_id in (":specials_id") and s.products_id = pd.products_id and pd.language_id = :language_id order by pd.products_name' | 1 |
|
| 'select p.products_id, p.products_price, p.products_tax_class_id, pd.products_name, s.specials_new_products_price from :table_products p left join :table_specials s on (p.products_id = s.products_id), :table_products_description pd where p.products_id = pd.products_id and pd.language_id = :language_id and p.has_children = 0 order by pd.products_name' | 1 |
|
| 'select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from :table_products p, :table_specials s, :table_products_description pd where p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = s.products_id order by pd.products_name' | 1 |
|
| 'select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, s.specials_new_products_price, s.expires_date, s.start_date, s.status from :table_specials s, :table_products p, :table_products_description pd where s.specials_id = :specials_id and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = :language_id' | 1 |
|
| 'update :table_categories set sort_order = :sort_order, last_modified = now() where categories_id = :categories_id' | 1 |
|
| 'update :table_categories set categories_image = :categories_image where categories_id = :categories_id' | 1 |
|
| 'select count(*) as total from :table_tax_rates where tax_zone_id = :tax_zone_id' | 1 |
|
| 'select * from :table_customers where ' | 1 |
|
| 'update :table_customers set customers_gender = :customers_gender, customers_firstname = :customers_firstname, customers_lastname = :customers_lastname, customers_email_address = :customers_email_address, customers_dob = :customers_dob, customers_newsletter = :customers_newsletter, customers_status = :customers_status, date_account_last_modified = now() where customers_id = :customers_id' | 1 |
|
| 'select count(*) as total from :table_products where products_weight_class = :products_weight_class' | 1 |
|
| 'insert into :table_categories (parent_id, date_added) values (:parent_id, now())' | 1 |
|
| 'select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from :table_newsletters order by date_added desc' | 1 |
|
| 'select weight_class_id, weight_class_title from :table_weight_class where weight_class_id in (":weight_class_id") and language_id = :language_id order by weight_class_title' | 1 |
|
| 'select c.*, cd.* from :table_categories c, :table_categories_description cd where c.categories_id = :categories_id and c.categories_id = cd.categories_id and cd.language_id = :language_id' | 1 |
|
| 'delete from :table_categories where categories_id = :categories_id' | 1 |
|
| 'delete from :table_newsletters where newsletters_id = :newsletters_id' | 1 |
|
| 'insert into :table_newsletters (title, content, module, date_added, status) values (:title, :content, :module, now(), 0)' | 1 |
|
| 'insert into :table_customers (customers_gender, customers_firstname, customers_lastname, customers_email_address, customers_dob, customers_newsletter, customers_status, number_of_logons, date_account_created) values (:customers_gender, :customers_firstname, :customers_lastname, :customers_email_address, :customers_dob, :customers_newsletter, :customers_status, :number_of_logons, now())' | 1 |
|
| 'update :table_newsletters set title = :title, content = :content, module = :module where newsletters_id = :newsletters_id' | 1 |
|
| 'update :table_customers set customers_password = :customers_password where customers_id = :customers_id' | 1 |
|
| 'select * from :table_newsletters where newsletters_id = :newsletters_id' | 1 |
|
| 'select newsletters_id, title from :table_newsletters where newsletters_id in (":newsletters_id") order by title' | 1 |
|
| 'select * from :table_weight_classes where weight_class_id = :weight_class_id and language_id = :language_id' | 1 |
|
| 'select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from :table_products p, :table_specials s, :table_products_description pd where s.specials_id = :specials_id and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = :language_id limit 1' | 1 |
|
| 'select products_price from :table_products where products_id = :products_id limit 1' | 1 |
|
| 'select top 1 id, user_name, user_password from :table_administrators where user_name = :user_name' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS gz.*, count(z2gz.association_id) as total_entries from :table_geo_zones gz left join :table_zones_to_geo_zones z2gz on (gz.geo_zone_id = z2gz.geo_zone_id) group by gz.geo_zone_id order by gz.geo_zone_name' | 1 |
|
| 'delete from :table_zones_to_geo_zones where association_id = :association_id' | 1 |
|
| 'delete from :table_geo_zones where geo_zone_id = :geo_zone_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_status, c.date_account_created, a.entry_country_id from :table_customers c left join :table_address_book a on (c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id) where (c.customers_firstname like :customers_firstname or c.customers_lastname like :customers_lastname) order by c.customers_lastname, c.customers_firstname' | 1 |
|
| 'delete from :table_customers where customers_id = :customers_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS gz.*, count(z2gz.association_id) as total_entries from :table_geo_zones gz left join :table_zones_to_geo_zones z2gz on (gz.geo_zone_id = z2gz.geo_zone_id), :table_countries c, :table_zones z where z2gz.zone_country_id = c.countries_id and z2gz.zone_id = z.zone_id and (gz.geo_zone_name like :geo_zone_name or gz.geo_zone_description like :geo_zone_description or c.countries_name like :countries_name or z.zone_name like :zone_name) group by gz.geo_zone_id order by gz.geo_zone_name' | 1 |
|
| 'select z2gz.association_id, z2gz.zone_country_id, c.countries_name, z2gz.zone_id, z.zone_name from :table_zones_to_geo_zones z2gz left join :table_countries c on (z2gz.zone_country_id = c.countries_id) left join :table_zones z on (z2gz.zone_id = z.zone_id) where z2gz.association_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by c.countries_name, z.zone_name' | 1 |
|
| 'select language_id, weight_class_key, weight_class_title from :table_weight_classes where weight_class_id = :weight_class_id' | 1 |
|
| 'select geo_zone_id, geo_zone_name from :table_geo_zones where geo_zone_id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by geo_zone_name' | 1 |
|
| 'select id, user_name, user_password from :table_administrators where user_name = :user_name limit 1' | 1 |
|
| 'delete from :table_specials where specials_id = :specials_id' | 1 |
|
| 'select SQL_CALC_FOUND_ROWS c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_status, c.date_account_created, a.entry_country_id from :table_customers c left join :table_address_book a on (c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id) order by c.customers_lastname, c.customers_firstname' | 1 |
|
| 'select ab.address_book_id, ab.entry_gender as gender, ab.entry_firstname as firstname, ab.entry_lastname as lastname, ab.entry_company as company, ab.entry_street_address as street_address, ab.entry_suburb as suburb, ab.entry_city as city, ab.entry_postcode as postcode, ab.entry_state as state, ab.entry_zone_id as zone_id, ab.entry_country_id as country_id, ab.entry_telephone as telephone_number, ab.entry_fax as fax_number, z.zone_code as zone_code, c.countries_name as country_title from :table_address_book ab left join :table_zones z on (ab.entry_zone_id = z.zone_id), :table_countries c where ab.customers_id = :customers_id and ab.entry_country_id = c.countries_id' | 1 |
|
| 'select r.weight_class_to_id, r.weight_class_rule, c.weight_class_title from :table_weight_classes_rules r, :table_weight_classes c where r.weight_class_from_id = :weight_class_from_id and r.weight_class_to_id != :weight_class_to_id and r.weight_class_to_id = c.weight_class_id and c.language_id = :language_id order by c.weight_class_title' | 1 |
|
| 'select weight_class_id, weight_class_key, weight_class_title from :table_weight_classes where language_id = :language_id order by weight_class_title' | 1 |
|
| 'insert into :table_specials (products_id, specials_new_products_price, specials_date_added, expires_date, start_date, status) values (:products_id, :specials_new_products_price, now(), :expires_date, :start_date, :status)' | 1 |
|
| 'update :table_specials set specials_new_products_price = :specials_new_products_price, specials_last_modified = now(), expires_date = :expires_date, start_date = :start_date, status = :status where specials_id = :specials_id' | 1 |
|
| 'select email_address, date_sent from :table_newsletters_log where newsletters_id = :newsletters_id order by date_sent desc' | 1 |
|
| 'select orders_status_id, orders_status_name from :table_orders_status where language_id = :language_id' | 2 |
|
| 'insert into :table_products_variants_values (id, languages_id, products_variants_groups_id, title, sort_order) values (:id, :languages_id, :products_variants_groups_id, :title, :sort_order)' | 2 |
|
| 'select id from :table_templates_boxes where code = :code and modules_group = :modules_group' | 2 |
|
| 'insert into :table_orders_status (orders_status_id, language_id, orders_status_name) values (:orders_status_id, :language_id, :orders_status_name)' | 2 |
|
| 'insert into :table_manufacturers_info (manufacturers_id, languages_id, manufacturers_url) values (:manufacturers_id, :languages_id, :manufacturers_url)' | 2 |
|
| 'insert into :table_templates_boxes (title, code, author_name, author_www, modules_group) values (:title, :code, :author_name, :author_www, :modules_group)' | 2 |
|
| 'select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from :table_categories c, :table_categories_description cd where c.parent_id = :parent_id and c.categories_id = cd.categories_id and cd.language_id = :language_id order by sort_order, cd.categories_name' | 2 |
|
| 'select count(*) as products_count from :table_products where manufacturers_id = :manufacturers_id' | 2 |
|
| 'select orders_status_id, orders_status_name from :table_orders_status where language_id = :language_id order by orders_status_name' | 2 |
|
| 'select c.categories_id, c.parent_id, c.categories_image, cd.categories_name from :table_categories c, :table_categories_description cd where c.categories_id = cd.categories_id and cd.language_id = :language_id order by c.parent_id, c.sort_order, cd.categories_name' | 2 |
|
| 'select ' . $fk['to_field'] . ' from ' . $query_data[2] . ' ' . $query_data[3] | 2 |
|
| 'select ' . $fk['from_field'] . ' from ' . $db_table_prefix . $fk['from_table'] . ' where ' . $fk['from_field'] . ' = "' . $Qchild->value($fk['to_field']) . '" limit 1' | 2 |
|
| 'select id, user_name from :table_administrators where id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by user_name' | 2 |
|
| 'select distinct b2p.boxes_group from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.templates_id = :templates_id and b2p.templates_boxes_id = b.id and b.modules_group = :modules_group and b2p.boxes_group not in (:boxes_group) order by b2p.boxes_group' | 2 |
|
| 'select id, title from :table_templates_boxes where modules_group = :modules_group order by title' | 2 |
|
| 'select id from :table_templates where code = :code' | 2 |
|
| 'select sum(url_clicked) as total from :table_manufacturers_info where manufacturers_id = :manufacturers_id' | 2 |
|
| 'select weight_class_id, weight_class_title from :table_weight_classes where language_id = :language_id order by weight_class_title' | 2 |
|
| 'delete from :table_templates_boxes where code = :code and modules_group = :modules_group' | 2 |
|
| 'select count(*) as total_products from :table_products_variants pv, :table_products_variants_values pvv where pvv.products_variants_groups_id = :products_variants_groups_id and pvv.id = pv.products_variants_values_id' | 2 |
|
| 'select count(*) as total_entries from :table_products_variants_values where products_variants_groups_id = :products_variants_groups_id' | 2 |
|
| 'select count(*) as total_products from :table_products_variants where products_variants_values_id = :products_variants_values_id' | 2 |
|
| 'insert into error_log (timestamp, message) values (:timestamp, :message)' | 2 |
|
| 'delete from :table_languages_definitions where definition_key = :definition_key and content_group = :content_group' | 2 |
|
| 'insert into :table_products_images_groups (id, language_id, title, code, size_width, size_height, force_size) values (:id, :language_id, :title, :code, :size_width, :size_height, :force_size)' | 2 |
|
| 'select weight_class_id, weight_class_key, weight_class_title from :table_weight_classes where language_id = :language_id' | 2 |
|
| 'insert into :table_weight_classes_rules (weight_class_from_id, weight_class_to_id, weight_class_rule) values (:weight_class_from_id, :weight_class_to_id, :weight_class_rule)' | 2 |
|
| 'select orders_status from :table_orders where orders_id = :orders_id' | 2 |
|
| 'select count(*) as count from :table_banners_history where banners_id = :banners_id and date_format(banners_history_date, "%Y%m%d") = date_format(now(), "%Y%m%d")' | 2 |
|
| 'select SQL_CALC_FOUND_ROWS distinct p.*, pd.products_name from :table_products p, :table_products_description pd, :table_products_to_categories p2c where p.parent_id is null and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id in (:categories_id)' | 2 |
|
| 'update :table_categories set parent_id = :parent_id, last_modified = now() where categories_id = :categories_id' | 2 |
|
| 'select id, image, default_flag from :table_products_images where products_id = :products_id order by sort_order' | 2 |
|
| 'select pvg.id as group_id, pvg.title as group_title, pvg.module, pvv.id as value_id, pvv.title as value_title from :table_products_variants pv, :table_products_variants_values pvv, :table_products_variants_groups pvg where pv.products_id = :products_id and pv.products_variants_values_id = pvv.id and pvv.languages_id = :languages_id_pvv and pvv.products_variants_groups_id = pvg.id and pvg.languages_id = :languages_id_pvg' | 2 |
|
| 'select id from :table_products_images where products_id = :products_id and default_flag = :default_flag limit 1' | 2 |
|
| 'select id, credit_card_name from :table_credit_cards where id in ("' . implode('", "', array_unique(array_filter(array_slice($_POST['batch'], 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))) . '") order by credit_card_name' | 2 |
|
| 'select * from :table_products where parent_id = :parent_id and products_status = :products_status' | 2 |
|
| 'insert into :table_shopping_carts_custom_variants_values (shopping_carts_item_id, customers_id, products_id, products_variants_values_id, products_variants_values_text) values (:shopping_carts_item_id, :customers_id, :products_id, :products_variants_values_id, :products_variants_values_text)' | 2 |
|
| 'insert into :table_shopping_carts (customers_id, item_id, products_id, quantity, date_added) values (:customers_id, :item_id, :products_id, :quantity, now())' | 2 |
|
| 'select max(item_id) as item_id from :table_shopping_carts where customers_id = :customers_id' | 2 |
|
| 'select SQL_CALC_FOUND_ROWS p.*, pd.products_name from :table_products p, :table_products_description pd where p.parent_id is null and p.products_id = pd.products_id and pd.language_id = :language_id' | 2 |
|
| 'delete from :table_shopping_carts where customers_id = :customers_id and item_id = :item_id' | 2 |
|
| 'select min(products_price) as min_price, max(products_price) as max_price, sum(products_quantity) as total_quantity, min(products_status) as products_status from :table_products where parent_id = :parent_id' | 2 |
|
| 'insert into :table_products_description (products_id, language_id, products_name, products_description, products_keyword, products_tags, products_url) values (:products_id, :language_id, :products_name, :products_description, :products_keyword, :products_tags, :products_url)' | 2 |
|
| 'insert into :table_product_attributes (id, products_id, languages_id, value) values (:id, :products_id, :languages_id, :value)' | 2 |
|
| 'delete from :table_countries where countries_id = :countries_id' | 2 |
|
| 'select * from :table_zones where zone_country_id = :zone_country_id order by zone_name' | 2 |
|
| 'update :table_countries set countries_name = :countries_name, countries_iso_code_2 = :countries_iso_code_2, countries_iso_code_3 = :countries_iso_code_3, address_format = :address_format where countries_id = :countries_id' | 2 |
|
| 'insert into :table_countries (countries_name, countries_iso_code_2, countries_iso_code_3, address_format) values (:countries_name, :countries_iso_code_2, :countries_iso_code_3, :address_format)' | 2 |
|
| 'select distinct banners_group from :table_banners order by banners_group' | 2 |
|
| 'insert into :table_categories_description (categories_id, language_id, categories_name) values (:categories_id, :language_id, :categories_name)' | 2 |
|
| 'select categories_id from :table_products_to_categories where products_id = :products_id' | 2 |
|
| 'select products_id, products_name from :table_products_description where products_id in (":products_id") and language_id = :language_id order by products_name' | 2 |
|
| 'delete from :table_shopping_carts_custom_variants_values where customers_id = :customers_id and shopping_carts_item_id = :shopping_carts_item_id' | 2 |
|
| 'delete from :table_address_book where address_book_id = :address_book_id and customers_id = :customers_id' | 2 |
|
| 'delete from :table_orders where orders_id = :orders_id' | 2 |
|
| 'select products_id, products_quantity from :table_orders_products where orders_id = :orders_id' | 2 |
|
| 'select module from :table_administrators_access where administrators_id = :administrators_id' | 2 |
|
| 'select count(distinct action) as total_assignments from :table_product_types_assignments where types_id = :types_id' | 2 |
|
| 'select module from :table_product_types_assignments where types_id = :types_id and action = :action order by sort_order, module' | 2 |
|
| 'select products_quantity from :table_products where products_id = :products_id' | 2 |
|
| 'select distinct action from :table_product_types_assignments where types_id = :types_id order by action' | 2 |
|
| 'select group_title, value_title from :table_orders_products_variants where orders_id = :orders_id and orders_products_id = :orders_products_id order by id' | 2 |
|
| 'delete from :table_product_types_assignments where types_id = :types_id and action = :action' | 2 |
|
| 'delete from :table_whos_online where time_last_click < :time_last_click' | 2 |
|
| 'update :table_configuration set configuration_value = :configuration_value, last_modified = now() where configuration_key = :configuration_key' | 2 |
|
| 'select customers_id from :table_customers where customers_email_address = :customers_email_address limit 1' | 2 |
|
| 'insert into :table_products_variants_groups (id, languages_id, title, sort_order, module) values (:id, :languages_id, :title, :sort_order, :module)' | 2 |
|
| 'select id, title, module from :table_products_variants_groups where languages_id = :languages_id order by sort_order, title' | 2 |
|
| 'select ab.*, z.zone_code, z.zone_name, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format from :table_address_book ab left join :table_zones z on (ab.entry_zone_id = z.zone_id) left join :table_countries c on (ab.entry_country_id = c.countries_id) where ab.customers_id = :customers_id and ab.address_book_id = :address_book_id' | 2 |
|
| 'select customers_newsletter from :table_customers where customers_id = :customers_id' | 2 |
|
| 'select global_product_notifications from :table_customers where customers_id = :customers_id' | 3 |
|
| 'select orders_status_name from :table_orders_status where orders_status_id = :orders_status_id and language_id = :language_id' | 3 |
|
| 'insert into :table_orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values (:orders_id, :orders_status_id, now(), :customer_notified, :comments)' | 3 |
|
| 'select zone_id from :table_zones_to_geo_zones where geo_zone_id = :geo_zone_id and zone_country_id = :zone_country_id order by zone_id' | 3 |
|
| 'delete from :table_products where products_id = :products_id' | 3 |
|
| 'insert into :table_products_to_categories (products_id, categories_id) values (:products_id, :categories_id)' | 3 |
|
| 'delete from :table_configuration where configuration_key = :configuration_key' | 3 |
|
| 'update :table_shopping_carts set quantity = :quantity where customers_id = :customers_id and item_id = :item_id' | 3 |
|
| 'select value from :table_sessions where id = :id' | 3 |
|
| 'insert into :table_products_images (products_id, image, default_flag, sort_order, date_added) values (:products_id, :image, :default_flag, :sort_order, :date_added)' | 3 |
|
| 'insert into :table_languages_definitions (languages_id, content_group, definition_key, definition_value) values (:languages_id, :content_group, :definition_key, :definition_value)' | 4 |
|
| 'select zone_id from :table_zones where zone_country_id = :zone_country_id and zone_code like :zone_code' | 4 |
|
| 'select zone_id from :table_zones where zone_country_id = :zone_country_id and zone_name like :zone_name' | 4 |
|
| 'select tax_class_id, tax_class_title from :table_tax_class order by tax_class_title' | 4 |
|
| 'update :table_customers set customers_default_address_id = :customers_default_address_id where customers_id = :customers_id' | 4 |
|
| 'select configuration_title, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_key = :configuration_key' | 4 |
|
| 'insert into :table_address_book (customers_id, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id, entry_telephone, entry_fax) values (:customers_id, :entry_gender, :entry_company, :entry_firstname, :entry_lastname, :entry_street_address, :entry_suburb, :entry_postcode, :entry_city, :entry_state, :entry_country_id, :entry_zone_id, :entry_telephone, :entry_fax)' | 4 |
|
| 'select zone_id from :table_zones where zone_country_id = :zone_country_id limit 1' | 5 |
|
| 'update :table_configuration set configuration_value = :configuration_value where configuration_key = :configuration_key' | 13 |
|