SQL Query: Select * from `mls_group_access`
SQL Query: Select * from `mls_group_config`
SQL Query: SELECT name, email, rating, comment, created_at FROM mls_product_ratings WHERE product_id = 2094 ORDER BY created_at DESC
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2094 AND status != 2
SQL Query: SELECT * FROM `mls_product_image` WHERE productid = 2094 AND status = 1 ORDER BY `position`
SQL Query: SELECT * FROM `mls_product_category` WHERE productid = 2094
SQL Query: SELECT *,if(parentid=0,id,parentid) as ordered_sub_category FROM `mls_product_categorylist` WHERE status = 1 order by ordered_sub_category , parentid
SQL Query: SELECT *,if(parentid=0,id,parentid) as ordered_sub_category FROM `mls_product_categorylist` WHERE status = 1 order by ordered_sub_category , parentid
SQL Query: SELECT * FROM `mls_product_export_countries` WHERE productid = 2094
SQL Query: SELECT * FROM `mls_country` WHERE `status` = 1 order by country
SQL Query: SELECT * FROM `mls_product_sector` WHERE productid = 2094
SQL Query: SELECT *,if(parentid=0,id,parentid) as ordered_sub_category FROM `mls_sector` WHERE status = 1 order by ordered_sub_category , parentid
SQL Query: SELECT *,if(parentid=0,id,parentid) as ordered_sub_category FROM `mls_sector` WHERE status = 1 order by ordered_sub_category , parentid
Brand
ANY AS PER REQUIREMENT
Material
ANY AS PER REQUIREMENT
Finishing
GOOD
Dimension
ANY AS PER REQUIREMENT
Weight
ANY AS PER REQUIREMENT
Package Type
BASED ON PRODUCT
Energy Efficiency
ANY AS PER REQUIREMENT
Guarantee
APPLICABLE
Warranty
APPLICABLE
Login to see seller contact details.
SQL Query: SELECT p.*, img.image as image, c.id as company_id, c.company_name FROM `mls_products` as p LEFT JOIN ( SELECT * FROM `mls_product_image` WHERE status = 1 GROUP BY productid ) as img on img.productid = p.id LEFT JOIN `mls_company` as c on c.id = p.company_id WHERE p.`status` = 1 AND c.id = 1658
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1923 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1924 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1925 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1926 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1927 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1929 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1933 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1934 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1935 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1936 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1937 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1939 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1941 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1942 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1943 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1944 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1945 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1946 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1947 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1948 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1949 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1950 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1951 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1952 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1956 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1959 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1960 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1961 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1962 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1964 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 1982 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2003 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2004 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2005 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2006 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2007 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2008 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2009 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2010 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2011 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2012 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2013 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2014 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2015 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2016 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2017 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2021 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2022 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2023 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2024 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2033 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2034 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2035 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2045 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2046 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2047 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2048 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2049 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2050 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2051 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2053 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2054 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2055 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2056 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2057 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2058 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2059 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2060 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2061 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2062 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2064 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2065 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2066 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2067 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2068 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2069 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2070 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2071 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2074 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2075 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2076 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2077 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2078 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2079 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2080 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2081 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2082 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2083 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2084 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2085 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2086 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2087 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2088 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2089 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2090 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2091 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2092 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2093 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2095 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2096 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2098 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2100 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2101 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2102 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2103 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2104 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2113 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2119 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2120 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2121 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2129 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2130 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2131 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2132 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2133 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2134 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2135 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2136 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2137 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2138 AND status != 2
SQL Query: SELECT * FROM `mls_product_testimonial` WHERE `product_id` = 2139 AND status != 2
SQL Query: SELECT * FROM `mls_product_category` WHERE productid = 2139
SQL Query: SELECT *,if(parentid=0,id,parentid) as ordered_sub_category FROM `mls_product_categorylist` WHERE status = 1 order by ordered_sub_category , parentidstring(0) "" string(944) "SELECT p.*, img.image AS image, c.id AS company_id, c.company_name FROM `mls_products` AS p LEFT JOIN ( SELECT MIN(id) as id, productid, image FROM `mls_product_image` WHERE status = 1 GROUP BY productid ) AS img ON img.productid = p.id LEFT JOIN `mls_company` AS c ON c.id = p.company_id WHERE p.status = 1 AND p.company_id IN ( SELECT DISTINCT c_id FROM `mls_company_user` WHERE u_id IN ( SELECT userid FROM `mls_users` WHERE status = 1 ) ) AND c.membercode_id IN ( SELECT id FROM `mls_member_code` WHERE status = 1 AND membercode_status = 'active' ) AND p.id IN ( SELECT DISTINCT productid FROM `mls_product_category` WHERE categoryid IN ('623','620','619') ) ORDER BY p.created_at DESC LIMIT 0, 5"