left start: 0.0182 sec
left end: 0.208 sec
listing start: 0.2953 sec
listing end: 1.3656 sec
END: 1.366 sec

select p.products_image1, p.description products_name , p.products_id, p.products_price,p.products_price_special, p.products_price final_price from products p , products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and ( p2c.categories_id = '1036' or p2c.categories_id = '1037' or p2c.categories_id = '1038' or p2c.categories_id = '1039' or p2c.categories_id = '1040' or p2c.categories_id = '1041' or p2c.categories_id = '1042' or p2c.categories_id = '1043' or p2c.categories_id = '1044' or p2c.categories_id = '1045' or p2c.categories_id = '1046' or p2c.categories_id = '1047' or p2c.categories_id = '1048' or p2c.categories_id = '1049' or p2c.categories_id = '1050' or p2c.categories_id = '1051' or p2c.categories_id = '1052' or p2c.categories_id = '1053' or p2c.categories_id = '1054' or p2c.categories_id = '1055' or p2c.categories_id = '1056' or p2c.categories_id = '1057' or p2c.categories_id = '1058' or p2c.categories_id = '1059' or p2c.categories_id = '1060' or p2c.categories_id = '1061' or p2c.categories_id = '1062' or p2c.categories_id = '1063' or p2c.categories_id = '1064' or p2c.categories_id = '1065' or p2c.categories_id = '1066' or p2c.categories_id = '1067' or p2c.categories_id = '1068' or p2c.categories_id = '1069' or p2c.categories_id = '1070' or p2c.categories_id = '1071' or p2c.categories_id = '1072' or p2c.categories_id = '1073' or p2c.categories_id = '1074' or p2c.categories_id = '1075' or p2c.categories_id = '1076' or p2c.categories_id = '1077' or p2c.categories_id = '1078' or p2c.categories_id = '1079' or p2c.categories_id = '1080' or p2c.categories_id = '1081' or p2c.categories_id = '1082' or p2c.categories_id = '1083' or p2c.categories_id = '1084' or p2c.categories_id = '1085' or p2c.categories_id = '1086' or p2c.categories_id = '1087' or p2c.categories_id = '1088' or p2c.categories_id = '1089' or p2c.categories_id = '1090' or p2c.categories_id = '1091' or p2c.categories_id = '1092' or p2c.categories_id = '1093' or p2c.categories_id = '1094' or p2c.categories_id = '1095' or p2c.categories_id = '1096' or p2c.categories_id = '1097' or p2c.categories_id = '1098' or p2c.categories_id = '1099' or p2c.categories_id = '1100' or p2c.categories_id = '1101' or p2c.categories_id = '1102' or p2c.categories_id = '1103' or p2c.categories_id = '1104' or p2c.categories_id = '1105' or p2c.categories_id = '1106' or p2c.categories_id = '1107' or p2c.categories_id = '1108' or p2c.categories_id = '1109' or p2c.categories_id = '1110' or p2c.categories_id = '1111' or p2c.categories_id = '1112' or p2c.categories_id = '1113' or p2c.categories_id = '1114' or p2c.categories_id = '1115' or p2c.categories_id = '1116' or p2c.categories_id = '1117' or p2c.categories_id = '1118' or p2c.categories_id = '1119' or p2c.categories_id = '1120' or p2c.categories_id = '1121' or p2c.categories_id = '1122' or p2c.categories_id = '1123' or p2c.categories_id = '1124' or p2c.categories_id = '1125' or p2c.categories_id = '1126' or p2c.categories_id = '1127' or p2c.categories_id = '1128' or p2c.categories_id = '1129' or p2c.categories_id = '1130' or p2c.categories_id = '1131' or p2c.categories_id = '1132' or p2c.categories_id = '1133' or p2c.categories_id = '1134' or p2c.categories_id = '1135' or p2c.categories_id = '1136' or p2c.categories_id = '1137' or p2c.categories_id = '1138' or p2c.categories_id = '1139' or p2c.categories_id = '1140' or p2c.categories_id = '1141' or p2c.categories_id = '1142' or p2c.categories_id = '1143' or p2c.categories_id = '1144' or p2c.categories_id = '1145' or p2c.categories_id = '1146' or p2c.categories_id = '1147' or p2c.categories_id = '1148' or p2c.categories_id = '1149' or p2c.categories_id = '1150' or p2c.categories_id = '1151' or p2c.categories_id = '1152' or p2c.categories_id = '1153' or p2c.categories_id = '1154' or p2c.categories_id = '1155' or p2c.categories_id = '1156' or p2c.categories_id = '1157' or p2c.categories_id = '1158' or p2c.categories_id = '1159' or p2c.categories_id = '1160' or p2c.categories_id = '1161' or p2c.categories_id = '1162' or p2c.categories_id = '1163' or p2c.categories_id = '1164' or p2c.categories_id = '1165' or p2c.categories_id = '1166' or p2c.categories_id = '1167' or p2c.categories_id = '1168' or p2c.categories_id = '1169' or p2c.categories_id = '1170' or p2c.categories_id = '1171' or p2c.categories_id = '1172' or p2c.categories_id = '1173' or p2c.categories_id = '1174' or p2c.categories_id = '1175' or p2c.categories_id = '1176' or p2c.categories_id = '1177' or p2c.categories_id = '1178' or p2c.categories_id = '1179' or p2c.categories_id = '1180' or p2c.categories_id = '1181' or p2c.categories_id = '1182' or p2c.categories_id = '1183' or p2c.categories_id = '1184' or p2c.categories_id = '1185' or p2c.categories_id = '1186' or p2c.categories_id = '1187' or p2c.categories_id = '1188' or p2c.categories_id = '1189' or p2c.categories_id = '1190' or p2c.categories_id = '1191' or p2c.categories_id = '1192' or p2c.categories_id = '1193' or p2c.categories_id = '1194' or p2c.categories_id = '1195' or p2c.categories_id = '1196' or p2c.categories_id = '1197' or p2c.categories_id = '1198' or p2c.categories_id = '1199' or p2c.categories_id = '1200' or p2c.categories_id = '1201' or p2c.categories_id = '1202' or p2c.categories_id = '1203' or p2c.categories_id = '1204' or p2c.categories_id = '1205' or p2c.categories_id = '1206' or p2c.categories_id = '1207' or p2c.categories_id = '1208' or p2c.categories_id = '1209' or p2c.categories_id = '1210' or p2c.categories_id = '1211' or p2c.categories_id = '1212' or p2c.categories_id = '1213' or p2c.categories_id = '1214' or p2c.categories_id = '1215' or p2c.categories_id = '1216' or p2c.categories_id = '1217' or p2c.categories_id = '1218' or p2c.categories_id = '1219' or p2c.categories_id = '1220' or p2c.categories_id = '1221' or p2c.categories_id = '1222' or p2c.categories_id = '1223' or p2c.categories_id = '1224' or p2c.categories_id = '1225' or p2c.categories_id = '1226' or p2c.categories_id = '1227' or p2c.categories_id = '1228' or p2c.categories_id = '1229' or p2c.categories_id = '1230' or p2c.categories_id = '1231' or p2c.categories_id = '1232' or p2c.categories_id = '1233' or p2c.categories_id = '1234' or p2c.categories_id = '1235' or p2c.categories_id = '1236' or p2c.categories_id = '1237' or p2c.categories_id = '1238' or p2c.categories_id = '1239' or p2c.categories_id = '1240' or p2c.categories_id = '1241' or p2c.categories_id = '1242' or p2c.categories_id = '1243' or p2c.categories_id = '1244' or p2c.categories_id = '1245' or p2c.categories_id = '1246' or p2c.categories_id = '1247' or p2c.categories_id = '1248' or p2c.categories_id = '1249' or p2c.categories_id = '1250' ) group by products_id_group order by p.description